Post Content
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.
Chapters:
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 Read More Microsoft Developer
#windowsDeveloper #windows