Azure SQL Deep Dive
40mAdvanced2023-05-12
Authors
Jeremy Villeneuve
Founder of Halvanta, LLC, an IT consulting firm
Course details
If you’re a database or server administrator spending too much time administering SQL Server, Azure SQL may be just the tool you need. Azure SQL is a cost-effective way to run SQL Server databases in the cloud, providing global scaling, failover, redundant point-in-time backups, automatic upgrades, modern security, and more, all enabled by simply pressing a few checkboxes. In this course, Jeremy Villeneuve shows you how to plan a migration to Azure SQL. He provides a technical overview of the differences in administering these databases, and examines the advantages and challenges when transitioning to platform-as-a-service managed Azure SQL Databases.
Skills covered
AdvancedDatabase DevelopmentDatabase ManagementAzureNetwork AdministrationCloud PlatformsNetwork and System AdministrationCloud ComputingMicrosoftSoftware Development
Concepts
Introduction
- Move from MSSQL on-premise to Azure SQL
- What you should know
Azure SQL Deployment Options
- Hosting SQL Server databases in the cloud
- Azure shared responsibility for cloud computing
- Get more control with Azure SQL Managed Instances
Set up an Azure SQL Database Server
- User authentication with Azure SQL
- How many database transaction units do you need
- Create a new Azure SQL Database
- Securing connections into your Azure SQL Server
Migrate SQL Databases into Azure SQL
- Migration strategies for Azure SQL Databases
- Lift and shift existing SQL Server instances
Azure SQL Security
- Encrypting your data at rest
- Securing data that is moving in transit
Azure SQL High Availability and Disaster Recovery
- Backing up your Azure SQL Databases
- Replication services for a high uptime
Monitoring Azure SQL Databases
- Performance monitoring in Azure SQL portal
- Track down long-running queries in Azure SQL
Conclusion
- Clean up Azure resources