Azure SQL Database for the SQL Server DBA

Azure SQL Database is Microsoft's Database as a Service offering. This course will help you take advantage of your existing SQL Server skills and learn about managing, high availability, and performance of this cloud first solution.
Course info
Rating
(76)
Level
Intermediate
Updated
Dec 20, 2016
Duration
2h 47m
Table of contents
Course Overview
What Is Azure SQL Database?
Connecting and Managing Azure SQL Database
Understanding the Service Tiers
Recovery in Azure SQL Database
Migrating to and from Azure SQL Database
Monitoring and Tuning Azure SQL Database
Description
Course info
Rating
(76)
Level
Intermediate
Updated
Dec 20, 2016
Duration
2h 47m
Description

Azure SQL Database is Microsoft's Database as a Service in the cloud. This course, Azure SQL Database for the SQL Server DBA, will show you some of the similarities to SQL Server but also why experienced DBAs will still need to learn some of the key differences. You will get to see the differences in management, high availability, performance, and monitoring of this cloud-first solution. You will also learn about the different service model and tiers that are specific to Azure SQL Database and how to migrate successfully to the platform. When you're finished with the course, you will understand how to leverage your existing SQL Server skills and apply them to a successful Azure SQL Database project.

About the author
About the author

Warner is a SQL Server Certified Master, MVP, and Principal Consultant at Pythian. He manages clients in many industries and leads a talented team that maintains and innovates with their data solutions. When he's not working in Ottawa, Ontario, he can be found in his home country of Costa Rica.

More from the author
More courses by Warner Chaves
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone, my name is Warner Chaves and welcome to my course Azure SQL Database for the SQL Server DBA. I'm a principal consultant at Pythian and a Microsoft data platform MVP. Azure SQL Database is Microsoft's cloud first database. It is closely aligned with SQL Server, but it's different in management, availability, and performance characteristics. It's a perfect fit for SQL Server DBAs to expand their cloud skills. This course is tailored for the SQL Server DBA that wants to get up and running with this cloud service as quickly as possible. Some of the topics that we will cover include provisioning of server and databases, understanding the service models and tiers, performance, database transaction units, and monitoring the service. The course will provide examples both in the portal interface and with Azure PowerShell so you can learn both approaches. By the end of the course you'll be able to confidently apply your SQL Server experience to building or migrating a database solution to the cloud into Azure SQL Database. Before beginning the course you only need to be familiar with basic SQL Server administration. I hope you'll join me on this journey to learn Azure SQL Database with the Azure SQL Database for the SQL Server DBA course here at Pluralsight.