Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Modernizing SQL Server the Right Way

PASS Data Community Summit via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn how to modernize SQL Server effectively in this comprehensive conference talk. Explore the importance of treating upgrades as full-fledged projects and discover the free tools provided by Microsoft for a successful upgrade experience. Gain insights into compatibility levels, deprecated features, and new functionalities. Walk through the upgrade process, including the Database Migration Guide, and understand the crucial phases of discovery and assessment. Watch demonstrations of the Data Migration Assistant (DMA) tool and learn about functional performance tests. Delve into the Database Experiments Assistant and post-migration considerations. Explore the Beacon Path and Automatic One Correction, and get introduced to a new tool and its capabilities.

Syllabus

Introduction
Why Upgrade
Compatibility Levels
Deprecated vs Discontinued
New Features
Upgrade Process
Database Migration Guide
Discover Phase
Assessment Phase
DMA Tool Walkthrough
DMA Tool Demo
Functional Performance Tests
Database Experiments Assistant
Demo
Post Migration
Beacon Path
Automatic One Correction
New Tool
What does it do

Taught by

PASS Data Community Summit

Reviews

Start your review of Modernizing SQL Server the Right Way

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.