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!

Jaksot(286)

SQL Data Partners Podcast: Episode 06 Build Your Personal Brand

SQL Data Partners Podcast: Episode 06 Build Your Personal Brand

Steve Jones, the editor from SQL Server central and I talk about the need to build your own brand and we share a few ideas on how to do that.  We talk about Steve's brand and how he built that over time and some options available to allow you the most opportunities possible.  This episode is a must have for those looking to kick it up a notch on the opportunity meter. Be sure to check out the show notes at http://sqldatapartners.com/2015/08/25/episode-06-build-your-personal-brand.

26 Elo 201532min

SQL Data Partners Episode 05: Principal of Least Privilege

SQL Data Partners Episode 05: Principal of Least Privilege

Robert Verell and I chat about good security practices and the principle of least privilege.  We discuss Robert's rule to never give anyone db_owner, other groups and Robert's home grown group to give instead of db_owner. Be sure to check out http://sqldatapartners.com/2015/08/19/principleofleastprivilege/ for the show notes.

19 Elo 201531min

SQL Data Partners Podcast Episode 04: Advanced Backup Options

SQL Data Partners Podcast Episode 04: Advanced Backup Options

We finish up our conversation with MVP Tim Radney on backup options with discussions on encryption and Azure.  Tim also shares his favorite tools and his super hero power of choice. Erik Véliz, the creator of SQL Server Booster is looking for folks to help with his lastest update.  Check out sqlserverbooster.com for more info. Also be sure to check out http://sqldatapartners.com/2015/08/11/episode04 for the shownotes and a chance to win Tim's book.

12 Elo 201519min

SQL Data Partners Podcast Episode 03: Backup and Recovery

SQL Data Partners Podcast Episode 03: Backup and Recovery

I chat with MVP Tim Radney about Backup and Recovery options in SQL Server.  We chatted for quite awhile and I ended up making two episodes out of our conversation.  This episode focuses on why we backup and some core ideas.  Advanced features will be in episode 04.  You can register to win a copy of Tim's book on Backup and Recovery by visiting sqldatapatners.com/podcast.  Also be sure to check out the very cool offer from SQL Skills at the end of the session. Be sure to check out http://sqldatapartners.com/2015/08/05/podcast-episode-03-backup-and-recovery/ for show notes

5 Elo 201531min

SQL Data Partners Podcast Episode 02: Extended Events

SQL Data Partners Podcast Episode 02: Extended Events

I was in Argentina for the SQLSaturday event in May of 2015 and made friends with Javier Villegas, a 20 year veteran in the DBA world.  While extended events have been around for some time, many are still getting used to this new feature and I talk with Javier about how he uses extended events and how we might get started.   Be sure to check out http://sqldatapartners.com/2015/08/05/podcast-episode-02-extended-events/ for show notes and links to content discussed in this episode.

5 Elo 201524min

SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About

SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About

Today I am super happy to announce the launch of my podcast and I start with episode 00. In this episode I take some time to go through my journey in becoming a data professional and how I think the podcast will be of value to you. We talk about why I am making the podcast and what kind of person will find it useful. I also discuss how you I want to be your compañero on your journey as a data professional. We discuss the following in today's episode.SQL CruiseApexSQL Refactor

5 Elo 201524min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-vegaaneista-tykkaan
aamukahvilla
rss-valo-minussa-2
rss-narsisti
adhd-podi
rss-duodecim-lehti
psykologia
rss-vapaudu-voimaasi
aloita-meditaatio
jari-sarasvuo-podcast
rss-tripsteri
queen-talk
rss-laadukasta-ensihoitoa
adhd-tyylilla
puhutaan-koiraa
rss-koira-haudattuna
ilona-rauhala