Episode
Native Windows principals for SQL Managed Instance | Data Exposed
with Anna Hoffman, Sravani Saluru
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
- 00:00 - Introduction
- 01:55 - Native Window principals
- 10:00 - Authentication metadata mode comparison
- 15:21 - Demo
Recommended resources
- Authenticating Microsoft Entra ID using windows principal metadata - Public Preview
- Native Windows principals
Related episodes
- Data Exposed | Microsoft Learn
- To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
- Microsoft Azure SQL
- Microsoft SQL Server
- Microsoft Developer
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
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
- 00:00 - Introduction
- 01:55 - Native Window principals
- 10:00 - Authentication metadata mode comparison
- 15:21 - Demo
Recommended resources
- Authenticating Microsoft Entra ID using windows principal metadata - Public Preview
- Native Windows principals
Related episodes
- Data Exposed | Microsoft Learn
- To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
- Microsoft Azure SQL
- Microsoft SQL Server
- Microsoft Developer
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
Have feedback? Submit an issue here.