{"id":4879,"date":"2024-06-16T15:58:00","date_gmt":"2024-06-16T15:58:00","guid":{"rendered":"https:\/\/davidpapkin.net\/?page_id=4879"},"modified":"2024-06-16T15:58:00","modified_gmt":"2024-06-16T15:58:00","slug":"microsoft-azure-dp-300-info","status":"publish","type":"page","link":"https:\/\/davidpapkin.com\/?page_id=4879","title":{"rendered":"Microsoft Azure DP-300 info"},"content":{"rendered":"\n

This David Papkin page has course info on Microsoft Azure DP-<\/a>300<\/a>.<\/p>\n\n\n\n

What is Azure SQL?<\/a><\/p>\n\n\n\n

Features comparison: Azure SQL Database and Azure SQL Managed Instance<\/a><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

T-SQL differences between SQL Server & Azure SQL Managed Instance<\/a><\/p>\n\n\n\n

What is Azure SQL Managed Instance?<\/a><\/p>\n\n\n\n

High Availability<\/strong><\/p>\n\n\n\n

https:\/\/learn.microsoft.com\/en-us\/training\/modules\/deploy-iaas-solutions-with-azure-sql\/5-explain-high-availability-and-disaster-recovery-options<\/a><\/p>\n\n\n\n

Use read-only replicas to offload read-only query workload<\/a><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Azure Backup for SQL Server<\/h3>\n\n\n\n

The Azure Backup solution requires an agent to be installed on the virtual machine. The agent then communicates with an Azure service that manages automatic backups of your SQL Server databases. <\/p>\n\n\n\n

Azure Backup also provides a central location that you can use to manage and monitor the backups to ensure meeting any specified RPO\/RTO metrics.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Best Practices <\/strong><\/p>\n\n\n\n

Performance best practices for SQL Server on Azure VMs<\/a><\/p>\n\n\n\n

Checklist: Best practices for SQL Server on Azure VMs<\/a><\/p>\n\n\n\n

<\/p>\n\n\n\n

Compatibility<\/strong><\/p>\n\n\n\n

Azure SQL Compatibility Levels<\/p>\n\n\n\n

https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/statements\/alter-database-transact-sql-compatibility-level?view=sql-server-ver16<\/a><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Migration<\/strong><\/p>\n\n\n\n

Migration overview: SQL Server to Azure SQL Managed Instance<\/a><\/p>\n\n\n\n

Azure Database Migration Service<\/a><\/p>\n\n\n\n

How to migrate SQL Server databases to Azure using DMS demo<\/a><\/p>\n\n\n\n

Azure Database Migration Service to SQL M.I. | Data Exposed demo<\/a><\/p>\n\n\n\n

How to migrate SQL Server to Azure SQL Database offline using Azure Data Studio demo<\/a><\/p>\n\n\n\n

Database Migration Assistant<\/a><\/p>\n\n\n\n

Database Experimentation Assistant<\/a><\/p>\n\n\n\n

What is SQL Data Sync for Azure?<\/a><\/p>\n\n\n\n

T-SQL differences between SQL Server and Azure SQL Database<\/a><\/p>\n\n\n\n

Transparent data encryption<\/a><\/p>\n\n\n\n

Query columns using Always Encrypted with SQL Server Management Studio<\/a><\/p>\n\n\n\n

Enabling TDE within a Microsoft SQL Server Database<\/span><\/p>\n\n\n\n

\n
\n

1.Set a master key within the master database using the CREATE MASTER KEY ENCRYPTION command.<\/p>\n\n\n\n

2.Create a certificate in the master database, which will be used for the encryption using the CREATE CERTIFICATE command.<\/p>\n\n\n\n

3.Create a database encryption key within the database, which allows you to enable TDE with the CREATE DATABASE ENCRYPTION KEY command.<\/p>\n\n\n\n

4.Once the encryption key is created, it needs to be enabled using the ALTER DATABASE command.<\/p>\n<\/div>\n\n\n\n

Scoped Configuration Options<\/span><\/strong><\/p>\n\n\n\n

ALTER DATABASE SCOPED CONFIGURATION<\/h3>\n\n\n\n