Episode 229: Data Migration Assistant

Episode 229: Data Migration Assistant

The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the name can be a bit misleading, (What? Microsoft have confusing names—that's a first), the major benefit to the tool is the assessment feature to alert you of potential issues when you upgrade. Issues are broken into three major categories:

  • Breaking Changes
  • Behavior Changes
  • Deprecated Changes

While each change should be reviewed, many times we allow deprecated features to remain unresolved as they are still supported in SQL Server; however, we certainly want to put those on the backlog because one day Microsoft will finally pull the plug and we want to be ahead of the curve.

You can find the show notes and video for today's episode at https://sqldatapartners.com/2021/07/21/episode-229-data-migration-assistant. Have fun on the SQL Trail!

Episoder(287)

Episode 223: Podcast Update

Episode 223: Podcast Update

With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episo...

14 Apr 20219min

Episode 222: Azure Arc-enabled Data Services

Episode 222: Azure Arc-enabled Data Services

Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from th...

24 Mar 20211h 4min

Episode 221: SQL Trail March 2021 Retrospective

Episode 221: SQL Trail March 2021 Retrospective

Virtual conferences are just not the same as the conferences we are used to, but we're still determined to provide a good learning and networking environment for our friends. We very much miss having...

22 Mar 202139min

Episode 220: Microsoft Ignite Recap

Episode 220: Microsoft Ignite Recap

As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss someth...

10 Mar 202145min

Episode 219: SQL Server Inventory

Episode 219: SQL Server Inventory

How do you document your SQL Server environments? I can remember walking through Brent Ozar's takeover script back in the day and how cumbersome it was to put all that information together. We have a ...

24 Feb 202147min

Episode 218: File Growths

Episode 218: File Growths

In this episode of the SQL Data Partners Podcast, Eugene and I go back to our DBA beginnings and talk about database file growth, how to manage files and how to tell when a file has grown. The show no...

17 Feb 202130min

Episode 217: A Little Something About A Few Things

Episode 217: A Little Something About A Few Things

The story begins with a process that has been running forever and suddenly decides to cause grief by filling up tempdb. We talk about patching, and we talk about mental health. We talk a little about ...

10 Feb 202134min

Episode 216: EDI vs ETL

Episode 216: EDI vs ETL

When working on a customer on an import process, she made the comment—if we were doing true EDI, we'd [Do X]. The comment got me thinking—Aren't we working on an EDI process? As someone who frequentl...

3 Feb 202132min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
rss-strid-de-norske-borgerkrigene
foreldreradet
treningspodden
rss-sunn-okonomi
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
merry-quizmas
gravid-uke-for-uke
rss-kunsten-a-leve
rss-kull
hagespiren-podcast
hverdagspsyken
rss-var-forste-kaffe
fryktlos
rss-mann-i-krise-med-sagen
smart-forklart