SQL Server: Understanding and Using Azure SQL Database

Azure SQL Database is finally on a par with on-premises SQL Server! This course describes and demonstrates using Azure SQL Database and its features as well as migration strategies for migrating existing SQL Server databases to Azure SQL Database.
Course info
Rating
(16)
Level
Intermediate
Updated
August 17, 2017
Duration
2h 8m
Table of contents
Introduction
4m 52s
Description
Course info
Rating
(16)
Level
Intermediate
Updated
August 17, 2017
Duration
2h 8m
Description

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this course, SQL Server: Understanding and Using Azure SQL Database, you'll learn the fundamentals of Azure SQL Database from a DBA perspective. First, you'll learn what Azure SQL Database is at a high level and then dive straight into the numerous features, many of which were finally introduced in the box version of SQL Server 2016. Next, you'll explore some of the unsupported features to show the differences between the on-premises SQL Server product and Azure SQL Database. Then you'll learn about the various pricing structures as well as different methods for migrating on-premises data to Azure SQL Database. Finally, you'll dig into the methods for monitoring and troubleshooting performance in Azure SQL Database. After watching this course, you should have a solid understanding of Azure SQL database and its many features and capabilities.

About the author
About the author

Tim is a Principal Consultant with SQLskills. He has worked with SQL server for the past 15 years, in a variety of roles including DBA, Lead DBA, and multi-department manager, which have given him extensive experience planning and implementing large-scale environment changes and upgrades.

More from the author
Transcript
Transcript

Hello, my name is Tim Radney and welcome to my course SQL Server: Understanding and Using Azure SQL Database. I am a SQL Server consultant with SQLskills as well as a Microsoft Data Platform MVP, and when I attended the Fall SQLintersection conference in 2015 I got really excited about Azure SQL Database. SQL Database had been available for quite a while, however it was finally comparable to on-premises SQL Server. Azure SQL Database is Microsoft’s relational database cloud solution.

In this course we will discuss the many features that come with Azure SQL Database. We will cover restore services, Dynamic Data Masking, Always Encrypted, Row-level security, TDE, Elastic pools, Query Store, and Index Advisor. While Azure SQL Database can do a lot of new cool things, there are many aspects of on-premises SQL Server that we are used to that are not included in Azure SQL Database. We will discuss how clients are dealing with those situations as well as other Azure platform solutions that solve those issues.

We will examine the various performance tiers and pricing options to include DTUs, eDTUs, and DSUs.

Migrating your databases from on-premises is not as simple as a backup and restore operation. We will cover multiple tools for testing your on-premises databases for compatibility with Azure SQL Database and explore various tools and methodologies for migrating your data and schemas.

Lastly, we will examine built-in and third party tools for monitoring Azure SQL Databases and explore and discuss various tuning options.

I hope you’ll join me as we explore Azure SQL database and its many features and capabilities in this course SQL Server: Understanding and Using Azure SQL Database.