Native Windows principals for SQL Managed Instance | Data Exposed

This capability simplifies the migration to SQL Managed Instance and unblock the migration of legacy applications that are tied to windows logins. This feature plays a vital role for SQL Managed Instance link. Managed Instance link enables near real-time data replication between SQL Server and SQL Managed Instance, the read-only replica in the cloud prevents creation of Microsoft Entra principals. The Windows authentication metadata mode allows customers to use an existing Windows login to authenticate to the replica if a failover happens. 0:00 Introduction 1:55 Native Window principals 10:00 Authentication metadata mode comparison ✔️Resources: Authenticating Microsoft Entra ID using windows principal metadata - Public Preview: https://techcommunity.microsoft.com/t5/azure-sql-blog/authenticating-microsoft-entra-id-using-windows-principal/ba-p/4168647 Native Windows principals: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/native-windows-principals?view=azuresql 📌 Let's connect: Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL