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!

Episoder(287)

Episode 271: Pass Summit 2023 Wrap-Up

Episode 271: Pass Summit 2023 Wrap-Up

This past November, Eugene and I attended the 2023 PASS Data Community Summit (aka PASS Summit) in Seattle, while Kevin headed down to Orlando for the Microsoft Live! 360 event in Orlando. Having no r...

29 Des 202338min

Episode 270: Medallion Architecture

Episode 270: Medallion Architecture

Moving up the ranks in the holy technology wars is the medallion architecture, and boy are we interested in getting your thoughts. Not since the 2008 Olympics and Michael Phelps' tenth of a second win...

21 Nov 202339min

Episode 269: Why Do I Need a Managed Service Provider?

Episode 269: Why Do I Need a Managed Service Provider?

In this Episode, Carlos talks about managed services and shares some of the benefits of working with an MSP, as well as potential cons.  The term manage services refers to the practice of outsourcing ...

19 Okt 202316min

Episode 268: AI and the Future of the Database

Episode 268: AI and the Future of the Database

We love hearing from our listeners!!! In this episode, a long-time listener asked about the future of AI in the data platform space. We thought this was a very interesting topic as Microsoft has been ...

28 Sep 202353min

Episode 267: Microsoft Fabric

Episode 267: Microsoft Fabric

All your data, all your teams—in one place. What am I? If you said Microsoft Fabric, you win! When I interned with Cisco Systems in 2000, I supported a platform called Unified Messaging. At that time,...

12 Sep 202343min

Episode 266: Working with Containers

Episode 266: Working with Containers

We're kicking off Season 7 with containers! Spinning up a VM may not be such a big deal anymore; however, most of us still have to request from another group one and wait. Even waiting on an Azure VM ...

29 Aug 202336min

Episode 265: WHY and What's Next

Episode 265: WHY and What's Next

Compañeros! In May, SQL Data Partners was acquired by Marathon Consulting.  There were many moving parts to get this done and we are excited to finally bring this news to the podcast.  In this episode...

28 Jun 202331min

Episode 264: Verified Backups

Episode 264: Verified Backups

A backup is only helpful when you can restore the backup. This should not prove to be overly shocking; however, normally we get the satisfaction of taking a backup and feel like all is well. Ideally, ...

12 Apr 202341min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
mikkels-paskenotter
foreldreradet
rss-strid-de-norske-borgerkrigene
treningspodden
rss-bisarr-historie
jakt-og-fiskepodden
rss-sunn-okonomi
sinnsyn
takk-og-lov-med-anine-kierulf
ukast
hverdagspsyken
rss-bak-luftfarten
gravid-uke-for-uke
lederskap-nhhs-podkast-om-ledelse
fryktlos
level-up-med-anniken-binz
tomprat-med-gunnar-tjomlid