3/14/2023 0 Comments Azure data studio mysql![]() The first lab of the Database Administration on Microsoft Azure course is to deploy a SQL Virtual Machine (Free SQL Server License: SQL 2019 Developer on Windows Server 2019) in the Azure portal. 1.) Provision A SQL Server On An Azure Virtual Machine You need to set up the Virtual Machine, restore the database, and query it to ensure it is available. The proof of concept will use SQL Server on an Azure Virtual Machine and a backup of the AdventureWorksDW database. You need to create a test environment for use in a proof of concept. Lab Scenario: You are a database administrator for AdventureWorks. So let’s understand the working of each of these labs in brief!! Module 1- The Role of the Azure Database Administrator Enable Geo-Replication For Azure SQL Database.Deploy An Azure Automation Runbook (or elastic job) To Rebuild Indexes On An Azure SQL Database.Configure Notifications Based On Performance Metrics.Deploy An Azure Template From A QuickStart Template On GitHub.Use Query Hints To Impact Performance In AdventureWorks2017.Use Query Store To Detect And Handle Regression In AdventureWorks2017. ![]() Isolate Problem Areas In Poorly Performing Queries In AdventureWorks2017.Identify Issues With Database Design AdventureWorks2017.Detect And Correct Fragmentation Issues.Use Query Store To Observe Blocking Problems. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |