Skip to content

Latest commit

 

History

History
57 lines (35 loc) · 4.87 KB

02-ModernizingYourDataEstateWithSQLServer2019.md

File metadata and controls

57 lines (35 loc) · 4.87 KB
Raw

Workshop: SQL Ground-to-Cloud

A Microsoft workshop from the SQL Server team

02 - Modernizing Your Data Estate with SQL Server 2019

SQL Server 2019 is a modern data platform designed to tackle the challenges of today's data professional. SQL Server 2019 is not just an upgrade option from previous releases of SQL Server.

The WideWorldImporters company has been evaluating upgrading several SQL Server 2008 instances along with some instances of SQL Server 2012, 2014, and even 2016. WideWorldImporters wants to know whether SQL Server 2019 will solve some of the challenges they face including:

  • Improving query performance without having to make application changes
  • Classifying key data columns and being able to audit access to these columns to meet the needs of GDPR compliance.
  • Providing better database availability when applications use long-running transactions.
  • Allowing the WideWorldImporters team to access data from sources like Oracle, Azure SQL Database, and Azure CosmosDB without having to develop expensive ETL jobs.
  • The database team at WideWorldImporters has evaluated SQL Server on Linux but SQL Server 2017 didn't include Replication, a feature they need for their application. They would like to evaluate how SQL Server Replication on Linux works. They also want to understand more about container technology and how it can be used with SQL Server
  • WideWorldImporters also would like to know other capabilities exist in SQL Server 2019 that might help them before more efficient and extend the capabilities of T-SQL.
  • WideWorldImporters also would like to learn more about how they can plan and execute a migration to SQL Server 2019 and reduce their risk for upgrades.
  • WideWorldImporters is also evaluating Azure SQL so wants to know what features in SQL Server 2019 also work in Azure.

In this workshop module, you will see the capabilities in SQL Server 2019 that can provide solutions for these challenges.

NOTE: Make sure you check out the prerequisite page before you start. You'll need all of the items loaded there before you can proceed with the workshop. Instructor led workshops may have provided all the resources in the prerequisites.

Activity: SQL Server 2019 Lab

In this activity, you will complete a series of modules from the SQL Server 2019 Lab.

Instructor led workshops will use modules from the SQL Server 2019 lab along with the PowerPoint slides SQL Server 2019 Modern Data Platform. Instructor led labs may not go through all modules in the SQL Server 2019 lab.

Activity Steps

To complete this module, go to https://github.com/microsoft/sqlworkshops/blob/master/sql2019lab/README.md.

When you are done with the SQL Server 2019 lab you have completed Module 02 of the SQL Server Ground to Cloud Workshop! Proceed to the next module using the link in Next Steps below.

For Further Study

Next Steps

Next, Continue to 03 - Working with Big Data Clusters on SQL Server 2019.