Category Archives for DP-300
[DP-300] Day6 Q/A Review – Automation of Tasks, Azure Policies, Plan & Implement HA/DR Environment
In this post, I have shared some quick tips on Azure Automation, including Q/A and useful links from the Day 6 live session of our current batch of Azure Database Administrator Training Program [DP-300]. Do check our blog at k21academy.com/dp300day6 What are Azure Resource Manager Templates? An ARM template is a JavaScript Object Notation file […]
Read More
Microsoft Azure Database Administrator [DP-300] Exam Questions
In this blog, we are going to cover Microsoft Azure Database Administrator Associate DP-300 Exam Questions that give you an idea and understanding that generally what type of questions are asked in the DP-300 Associate-level Exam. Azure Database Administrator Associate [DP-300] Certificate is important This includes administering knowledge around T-SQL for administrative management purposes. Participants […]
Read More
[DP-300] Day5 Q/A Review – Understanding SQL Server Query Plans
An execution plan in SQL Server is a simple graphical representation of the operations that the query optimizer generates to calculate the most efficient way to return a set of results. The query optimizer calculates a cost for multiple possible plans based on the statistics it has on the columns being utilized and the possible […]
Read More
[DP-300] Day4 Q/A Review – Monitor And Optimize Operational Resources
Azure offers tools for monitoring the Azure Database by using the Azure metrics tool, you may lack some specific controls around hardware that you would have in an on-premises environment which makes understanding how to identify and resolve performance bottlenecks while in Azure SQL that is much more critical. And experience using Windows Performance Monitor […]
Read More
[DP-300] Day3 Q/A Review: Implement A Secure Environment
Implement a secure environment Azure SQL Database has several authentication and authorization options that are different from the options in SQL Server. This is because Azure SQL Database and Azure SQL Managed Instance rely on Azure Active Directory instead of Windows Server Active Directory. In Azure, while implementing a secure environment we explore encryptions, firewalls, […]
Read More
Plan And Implement Data Platform Resources
In plan and implement data platform resources we Configure virtual machine sizing, storage, and networking options to ensure adequate performance for your database workloads. Provision and deploy Azure SQL Database and Azure SQL managed instance. And compare and configure Open Source Azure Database offerings with Azure SQL offerings. Do Check Our Blog at k21academy.com/dp300day2 Azure […]
Read More
[DP-300] Day1 Q/A Review – The Role of Azure Database Administrator
A Modern database administrator is responsible for the design, implementation, maintenance, and performance of database systems. They work with on-premises and cloud-based data platform solutions built on Azure Data Services and SQL Server. The main goal is to ensure the availability and consistent performance of various applications running on the database server. What is Azure […]
Read More
Introduction To Azure Data Studio
In this blog, we are covering an overview of Azure Data Studio (ADS), its features, comparisons, the scope of settings, querying data, backup, and restore a database. What Is Azure Data Studio? ADS is a cross-platform database tool for any data professional like SQL Developer, DBA, PowerBI Developer, or any developers who are working directly […]
Read More
Migrate SQL Server To an Azure SQL Managed Instance [Offline]
In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Offline] using a database migration service (Adventureworks2016 database ) with minimal downtime and these roles are mainly performed by the database administrator. What Is Azure SQL Managed Instance? SQL Managed Instance is a PaaS deployment […]
Read More
Migrate SQL Server To an Azure SQL Managed Instance [Online]
In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Online] using a database migration service (Adventureworks2016 database ) with minimal downtime and these roles are mainly performed by the database administrator. What Is Azure SQL Managed Instance? SQL Managed Instance is a PaaS deployment […]
Read More