Category Archives for Microsoft Azure
Blue-Green Deployment in Azure
When you are deploying a new change into production, the associated deployment should be in a predictable manner. In simple terms, this means no disruption and zero downtime! The safe strategy can be achieved by working with two identical infrastructures – the “green” environment hosting the current production and the “blue” environment with the new […]
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
Azure Solutions Architect | Day 3 Review and Q/A
Implement VMs for Windows and Linux [AZ-303/304] Azure Virtual Machines (VM) is one of several types of on-demand, scalable computing resources that Azure offers. Typically, you choose a VM when you need more control over the computing environment than the other choices offer. Azure virtual machines can be used in various ways. Read Our Blog […]
Read More
Long Term Backup Retention [LTR] On Azure SQL Managed Instance
In this blog, I have covered the overview of Long-Term Backup Retention [LTR] On Azure SQL Managed Instance. Also how to create, configure, restore a backup, and many more things which are essential to learn as a database administrator. What Is Long-Term Backup Retention Most of the applications have regulatory, consistency or other business purposes […]
Read More
Azure Solutions Architect | Day 1 Review and Q/A
Azure Active Directory [AZ-303/304] Azure Active Directory ➪ is a cloud-based identity and access management service offered by Microsoft that helps employees sign in and access resources. Azure AD Join ➪ lets you join the devices directly to Azure AD without joining on-premises Active Directory. At the same time, it is user productive and secure. […]
Read More
Azure RBAC vs Azure Policy vs Azure Blueprints
➽ The blog post – https://k21academy.com/az30419 will cover an overview of azure governance and its services and their differences. ➽ What comes to your mind when you see the word Governance? Is it a rule, or is it policy? Whatever it may be, don’t you think the company needs Governance to run effectively and efficiently. […]
Read More
Schedule And Automate SQL Server DB Replication
In this blog, I have covered steps to Schedule And Automate SQL Server DB Replication between different servers [SQL Server 2017 or Windows Server 2016]. We cover this in detail in our Azure Data Database Administrator [DP-300] Training program. Introduction SQL Server DB replication is a technology that is used to copy or distribute, data […]
Read More
Everything you need to know about Power BI Service
This blog walks you through the Power BI Service and everything you need to know about Power BI Service Microsoft Power BI Service The Power BI Service is a cloud-based☁️ service where users view and interact with the reports. The Microsoft Power BI service, also referred to as Power BI online, is the SaaS (Software […]
Read More