Native Windows principals for SQL Managed Instance | Data Exposed

Published: 22 August 2024
on channel: Microsoft Developer
1,086
21

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/t...
Native Windows principals: https://learn.microsoft.com/en-us/azu...

📌 Let's connect:
Twitter - Anna Hoffman,   / 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


On this page of the site you can watch the video online Native Windows principals for SQL Managed Instance | Data Exposed with a duration of hours minute second in good quality, which was uploaded by the user Microsoft Developer 22 August 2024, share the link with friends and acquaintances, this video has already been watched 1,086 times on youtube and it was liked by 21 viewers. Enjoy your viewing!