Select Page
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
Installing SQL 2016 for Configuration Manager in a PubSec Environment

Installing SQL 2016 for Configuration Manager in a PubSec Environment

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
JoshuaLent_0-1586198850488.jpeg

Create a SQL FCI with a Tertiary AG Replica

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
Last1.png

Azure AD pass-through and password hash authentication support for SQL DB, DW and Managed Instance

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
SCCM: Housekeeping Collections

SCCM: Housekeeping Collections

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
bake13_0-1583785090535.png

Use SQL Server 2019 PolyBase to Virtualize a Sybase IQ Database

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