Linked servers enable the SQL Server and Azure SQL Database Managed Instance to read data from remote data sources and execute commands against the remote database servers.

In this video, Anna Thomas and Colin Murphy go over configuring linked servers in Azure SQL Database Managed Instance.

At the end, Anna briefly mentions creating a linked server to the readable secondary replica for read-heavy workloads.

To provide customers with an easier network configuration, all newly created virtual clusters will be enabled for access over global virtual network peering connections, now in general availability.

This enables customers to pair managed instances in failover group configuration, in an easy and performant way, by simply connecting virtual networks in different regions. By utilizing global virtual network peering for your managed instances, you will save time through easy network configuration and offload your gateways from database replication traffic.

Review this new feature and more in this episode with Srdan Bozovic.

Time Index:

  • [00:42] Why Global VNet Peering Support is Important
  • [01:39] Auto-failover group connectivity architecture
  • [03:52] Take advantage of Global VNet Peering Support

Resources:

With the Common Language Runtime (CLR) hosted in Microsoft SQL Server (aka CLR integration), you can author stored procedures, triggers, user-defined functions, user-defined types, and user-defined aggregates in managed code.

The CLR is also available in Azure SQL Database Managed Instance.

In this video, Anna Hoffman and Colin Murphy go over what CLR is, how to set it up in Azure SQL Database Managed Instance, and simple example of Regular Expressions in Azure SQL Database Managed Instance.