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!

Avsnitt(287)

Episode 239: Bi-directional HA/DR to Azure SQL

Episode 239: Bi-directional HA/DR to Azure SQL

SQL Server 2022 has been announced and we are excited to start unpacking the new features. For this episode, we start with a very interesting feature--Bi-directional HA/DR to Azure SQL. We have the ab...

15 Dec 202134min

Episode 238: Getting Started with Power BI - Part 2

Episode 238: Getting Started with Power BI - Part 2

Part 2 Power BI has been described as a "self-service" BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address b...

8 Dec 202131min

Episode 237: Getting Started with Power BI - Part 1

Episode 237: Getting Started with Power BI - Part 1

Part 1 Power BI has been described as a "self-service" BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address b...

1 Dec 20211h 6min

Episode 236: Database Monitoring with SQL Sentry

Episode 236: Database Monitoring with SQL Sentry

Building your own scripts to monitor SQL Server seems like a very reasonable thing to do. We're smart folks and SQL Server is what we do for a living—we should be able to figure this out. Upon further...

17 Nov 202142min

Episode 235: SQL Trail 2021 In-person Q&A

Episode 235: SQL Trail 2021 In-person Q&A

Live Podcast! We decided it was time to try and get together in person and reconnect. As we did, we pulled out the microphone and started recording. As a result, we break the single topic mode this we...

3 Nov 202125min

Episode 234: Communication Tips for the IT Pro

Episode 234: Communication Tips for the IT Pro

As a data pro, you are negotiating and problem-solving all the time, often without knowing it. Your success as a professional as your company evolves its Data Platform depends on how well you can comm...

7 Okt 20211h 1min

Episode 233: ScriptDOM

Episode 233: ScriptDOM

Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the documentation is scarce. Mala Mahadevan uses it, loves it, and graciously offered to come back to ...

15 Sep 202146min

Episode 232: Giving Technical Presentations

Episode 232: Giving Technical Presentations

Public speaking is not fun for most; however, it can be very rewarding. Chris Seferlis chats with us about a few tips he has on being a speaker. Most of the tactical advice we defer to a toastmasters ...

1 Sep 202154min

Populärt inom Utbildning

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