Lets .NET code run inside SQL Server (common language runtime); SQL Server on VMs and SQL Managed Instance support it, while Azure SQL Database doesn't.
Also called common language runtime.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains CLR in context, with comparison tables and the common traps.
Terms in this definition
- SQL Server
The relational database from Microsoft that organisations host and run themselves, in their own data centres or on VMs. Its engine also sits underneath the Azure SQL services and SQL database in Fabric.
- Virtual machines
Infrastructure-as-a-service compute giving complete control of the operating system, making it a fit for lift-and-shift moves and for software relying on OS-level pieces like COM.
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- Azure SQL Database
Platform-as-a-service database offered as a single database or in an elastic pool, sized up to 4 TB or 128 TB on Hyperscale. SQL Agent, CLR and queries across databases aren't available.
Related terms
- Azure SQL Managed Instance
Fully managed SQL Server instance offering almost complete compatibility, including SQL Agent, CLR and queries across databases; disaster recovery to another region is achieved with auto-failover groups.
- SQLCLR
The ability to run .NET Framework CLR code within SQL Server as procedures, functions, triggers or types. A database project containing such objects still requires .NET Framework when it is built.