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

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

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

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

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

Hello, my name is Chris Vetter and I am a Premier Field Engineer with Microsoft. I am here to discuss Installing SQL Server 2016 for Configuration Manager in a PubSec Environment. The intent of this guide is to install SQL ... continue reading

Procedure The purpose of this guide is to provide the steps needed to deploy a 2-node Windows Server Failover Cluster (WSFC) hosting a clustered instance of SQL Server 2019. A 3rd Windows server running on a separate subnet will also ... continue reading

We are announcing support for Azure AD pass-through and password hash authentication for Azure SQL DB (single database and database pools), Managed Instance, and Azure Synapse (formerly SQL DW). Azure AD password hash authentication is the simplest way to enable ... continue reading

Hi there, I am Matt Balzan and I am a Microsoft PFE with the Windows and Devices team, in the UK. Today I am going to show you how to manage and troubleshoot the collections that are affecting the performance ... continue reading

Introduced with SQL Server 2016, the PolyBase feature enabled access to non-relational data stores, namely Hadoop and Azure Blob Storage all while using the familiar and popular Transact-SQL language. SQL Server 2019 builds upon that foundation by unlocking the ability ... continue reading