Episode 279: SQL Server Migrations Demystified

Episode 279: SQL Server Migrations Demystified

If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere.

Or perhaps you'll find yourself migrating from another database into SQL Server.

No matter which way you slice it, SQL Server migrations can be daunting, not to mention complex and time-consuming. While we know there are risks and many things that can go wrong, the "new" Microsoft continues to put time and effort towards making successful SQL Server migrations attainable for everyone.

In this episode of the podcast, we chat with Tejas Shah and Sudhir Raparla, 2 of the Microsoft Project Managers responsible for SQL Server migration tooling. They share practical perspectives on approaching your SQL migration with confidence and the tools and enhancements that will help.

During the conversation, Tejas and Sudhir also take us through the 5 migration steps they want you to consider as you undertake your SQL Server migration process.

Even though we've migrated thousands of databases, I had to go back and peek at a couple of the new features the migration tooling team has added. One intriguing addition is the Azure SQL Pricing repository, which is part of the SQL Server Migration assistant and can help with determining costs based on industry standards, deployment recommendations, target sizing, and monthly savings based on your unique scenario.

Let us know what you think! What SQL migration features have you come to trust and rely on? Did you get any good takeaways from today's podcast or have some questions? Leave us a comment and some love ❤️ on LinkedIn, X, Facebook, or Instagram.

The show notes for today's episode can be found at Episode 279: SQL Server Migrations Demystified. Have fun on the SQL Trail!

Avsnitt(287)

Episode 263: SQL Server This 'n That

Episode 263: SQL Server This 'n That

When we couldn't confirm a guest speaker by recording time, Eugene, Kevin, Amanda, and I decided the show must go on, so we went into the ideas vault and pulled out a couple of listener questions we h...

29 Mars 202342min

Episode 262: Learning Azure Synapse Pt 1

Episode 262: Learning Azure Synapse Pt 1

Learning new technology can be difficult—especially when it's a technology in an area you are not familiar with. In this episode, Eugene walks us through some of the challenges he has faced getting s...

15 Mars 202332min

Episode 261: The Data Lakehouse

Episode 261: The Data Lakehouse

It would appear Microsoft has run out of words to use for new features/products, so they are just going to recycle existing words for a bit of fun at our expense. In this episode we explore the Azure...

1 Mars 202350min

Episode 260: Contained Availability Groups

Episode 260: Contained Availability Groups

We're back with another SQL Server 2022 feature—Contained Availability Groups. Have you ever failed over to a secondary node and then found a job or login missing? This new Enterprise-only feature a...

15 Feb 202336min

Episode 259: T-SQL Snapshot Backups

Episode 259: T-SQL Snapshot Backups

We kick off the new year discussing a new feature in SQL Server 2022 called Transact-SQL snapshot backups. Good luck with the Google search on this feature--we know we had fun. 😊 These are not the sn...

17 Jan 202327min

Episode 258: Leave 2022 Enter 2023

Episode 258: Leave 2022 Enter 2023

As we close out the year, we take a look back and think about all those SQL Server 2022 episodes we didn't record this year—and then make the goal to increase this count in the new year. 😊 We discuss...

27 Dec 202230min

Episode 257: The Business of Working for Yourself

Episode 257: The Business of Working for Yourself

Have you ever thought about working for yourself? It can be very enticing for some, and in this episode, we talk with John Sterrett about the pros and cons of running your own organization. We tackle ...

30 Nov 202239min

Episode 256: The Community Episode

Episode 256: The Community Episode

Seven years ago, I started the SQL Data Partners Podcast. We have now arrived at Episode 256, and we dedicate this episode to you, the community. Thanks to everyone who has joined us along the way, an...

3 Nov 202256min

Populärt inom Utbildning

historiepodden-se
rss-bara-en-till-om-missbruk-medberoende-2
det-skaver
harrisons-dramatiska-historia
nu-blir-det-historia
roda-vita-rosen
not-fanny-anymore
alska-oss
johannes-hansen-podcast
sektledare
sa-in-i-sjalen
rss-max-tant-med-max-villman
allt-du-velat-veta
rss-viktmedicinpodden
rikatillsammans-om-privatekonomi-rikedom-i-livet
rss-foraldramotet-bring-lagercrantz
i-vantan-pa-katastrofen
rss-sjalsligt-avkladd
rss-basta-livet
sex-pa-riktigt-med-marika-smith