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.
What you'll learn
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.
Table of contents
- Introduction and Backups 3m
- Improved Security Features and Dynamic Data Masking 2m
- Demo: Enabling and Using Dynamic Data Masking 3m
- Row-level Security and Always Encrypted 2m
- Transparent Data Encryption and Geo-replication 2m
- Demo: Setting up Geo-replication 3m
- Elastic Database Pools and In-memory for Premium Tier 2m
- Query Store and Index Advisor 3m
- Demo: Query Store 6m
- Demo: Index Advisor 3m
- Module Summary 1m
- Introduction and Monitoring Options 1m
- Azure Portal, Monitor Dashboard, and Alerts 2m
- Demo: Monitor Dashboard 3m
- Demo: Alerts 3m
- Resource and Service Health Dashboards, DMVs, and 3rd-party Tools 4m
- Demo: Using Resource and Service Health Dashboards 3m
- Tuning Options and DMVs 3m
- Demo: Capturing File and Wait Statistics 3m
- DTU Tiers and Query Store 2m
- Demo: Exploring DTU Tiers 4m
- Demo: Query Store 4m
- Index Advisor and Auto-tuning 2m
- Demo: Examining Index Advisor 1m
- Tuning Differences and Module Summary 2m
- Course Summary 5m
About the author
Tim has worked with SQL server for the past 25 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. Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passi... more