Select Page

Configuring backup storage redundancy in Azure SQL

Database backups are an essential part of any business continuity and disaster recovery strategy, because they protect your data from corruption or deletion. In Azure SQL there are two types of automated backups that customers can use for restoring their ... continue reading
image001.png

Quickly Setting Up a Sandbox with Azure SQL DB/MI and AAD Synchronization

  Introduction   During the migration journey from SQL Server to Azure SQL Database or Managed Instance, the customers I meet often wondering how to deal with the Integrated Authentication, their applications, especially the legacy ones. The following tutorial will ... continue reading
business-critical-service-tier.png

User initiated manual failover on SQL Managed Instance

High availability is a fundamental part of SQL Managed Instance (MI) platform that works transparently for your database applications.  As such, failovers from primary to secondary nodes in case of node degradation or fault detection, or during our regular monthly software ... continue reading

Configuring backup storage redundancy in Azure SQL Managed Instance

Database backups are an essential part of any business continuity and disaster recovery strategy, because they protect your data from corruption or deletion. In Azure SQL Managed Instance there are two types of automated backups that customers can use for ... continue reading

Changing default MAXDOP in Azure SQL Database

Executive Summary To improve customer workload performance and reduce unnecessary resource utilization, the default MAXDOP setting for new databases in Azure SQL Database is changing from the previous default of 0 (unlimited) to 8. Why MAXDOP matters The “max degree ... continue reading
Adrian_Rupp_0-1590520284345.png

Part 4 – SQL Server TDE and Extensible Key Management Using Azure Key Vault

Configure SQL Server This is Part: 4 of a 4-part blog series: After setting up Azure Active Directory and registering the AAD Application and additionally creating an Azure Key Vault, the next step is to put it all together in ... continue reading
Adrian_Rupp_0-1590519409809.png

Part 2 (PowerShell) – SQL Server TDE and Extensible Key Management Using Azure Key Vault

Set up an Azure Active Directory Service Principal and Azure Key Vault using PowerShell This is Part: PS2 (PowerShell) of a 4-part blog series: This blog in the series provides the step-by-step instructions to configure Azure Active Directory using PowerShell ... continue reading
Adrian_Rupp_0-1590519050548.png

Part 3 (Portal) – SQL Server TDE and Extensible Key Management Using Azure Key Vault

Create a Key Vault using the Azure Portal This is Part: AP3 (Azure Portal) of a 4-part blog series: This blog in the series provides the step-by-step instructions to create an Azure Key Vault using the Azure Portal. To grant ... continue reading
Adrian_Rupp_0-1590518598997.png

Part 2 (Portal) – SQL Server TDE and Extensible Key Management Using Azure Key Vault

Set up an Azure Active Directory service principal using the Azure Portal This is Part: AP2 (Azure Portal) of a 4-part blog series: This blog in the series provides the step-by-step instructions to configure Azure Active Directory using the Azure ... continue reading
Monitoring screenshot.png

Monitoring options available for Azure SQL Managed Instance

For production workloads running on your Azure SQL Managed Instance it is very important to continuously understand the resource consumption and any potential performance issues such that you can react in time and have your business running smoothly. There exist ... continue reading