Select Page

General availability for Azure AD server principals (logins) for SQL Managed Instance

We are happy to announce a general availability (GA) for Azure AD server principals (Azure AD logins) for SQL managed instance (MI). This feature allows Azure AD users to create logins in the master database for MI, grant MI server ... continue reading
Query.Results.png

T-SQL DDL support for Windows users migration from SQL Server databases to SQL Managed Instance

We are happy to announce a public preview for T-SQL DDL support for Windows domain users migration from SQL Server on-premises databases to SQL managed instance (MI) with Azure AD authentication. The migration process for databases from SQL Server on-premises ... continue reading

Enabling communication traces in C# application for Azure AD authentication with SQL DB using token-based mechanism with Multi-factor authentication (MFA)

First published on MSDN on Aug 29, 2017 SQL server security team presents a code sample ( as VS project) allowing to enable communication traces for ADAL managed library used to support Universal Authentication with MFA for SQL DB ( ... continue reading

Token-based authentication including Multi-factor auth (MFA) for Azure SQL DB using Azure Active Directory (AD)

First published on MSDN on Aug 18, 2017 SQL server security team presents an application solution for token-based authentication with multi-factor (MFA) support for SQL DB using Azure AD auth. The zip file attached below with the codes sample and ... continue reading
debugg.png

Azure AD Service Principal authentication to SQL DB – Code Sample

The following application provides an example of using Azure AD Service Principal (SP) to authenticate and connect to Azure SQL database. This application measures the time it takes to obtain an access token, total time it takes to establish a ... continue reading