Provision a SQL Server on an Azure Virtual MachineCompare on-premises Azure costsDeploy an Azure SQL DatabaseIdentify compatibility issuesMigrate a SQL Server database to Azure SQL DatabaseMigrate a SQL Server database to Azure SQL Managed InstanceMigrate SQL Server databases to SQL Server on Azure Virtual MachineAccess to Azure SQL Database with Microsoft Entra IDConfigure a server-based firewall rule using the Azure portalEnable Microsoft Defender for SQL and Data ClassificationIsolate problems with monitoringDetect and correct fragmentation issuesIdentify and resolve blocking issuesIdentify database design issuesIsolate problem areas in poorly performing queriesDiagnose a slow query and generate a fix with CopilotDeploy an Azure SQL Database using an Azure Resource Manager templateCreate a CPU status alert for a SQL ServerDeploy an automation runbook to automatically rebuild indexesConfigure geo replication for Azure SQL DatabaseBackup to URL
DP-300 Labs
Lab exercises for DP-300: Administering Microsoft Azure SQL Solutions. Includes Applied Skills, Microsoft Learn, and Microsoft GitHub labs.