Azure SQL Database for the SQL Server DBA
Course info
Course info
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
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
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.