With the Common Language Runtime (CLR) hosted in Microsoft SQL Server (called CLR integration), you can author stored procedures, triggers, user-defined functions, user-defined types, and user-defined aggregates in managed code. CLR is also available in Azure SQL Database Managed Instance ... continue reading

Want to get started with Azure Data Studio but don't know where to begin? In this video, Anna Hoffman shows you how to get connected to Azure SQL Database for the first time using Azure Data Studio ... continue reading

Executive summary M-series provides close to 30 GB of memory per core and up to 128 cores, enabling significant scale-up capability in Azure SQL Database. For the same IoT workload, we achieved 3 times higher throughput on M-series compared to ... continue reading

Azure SQL Database provides a number of options to optimize your deployment to best fit your needs. In this video we explain the different options and their aspects. More information: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas ... continue reading

You're probably familiar with Collations in SQL Server, but how do Collations change in Azure SQL Database Managed Instance? In this video, Anna Thomas and Colin Murphy cover a brief overview of collations (https://docs.microsoft.com/en-us/sql/t-sql/statements/collations) and how they're different in Azure ... continue reading

When you migrate your SQL Server data estate to Azure SQL Database managed instance, what you get is not just a good old SQL Server, secured and enriched with the newest features, and without a burden of managing backups, patching, ... continue reading

Many organizations seek to do more with their data than pump out dashboards and reports. Applying advanced analytical approaches such as machine learning is an essential arena of knowledge for any data professional. While database administrators (DBAs) don't necessarily have ... continue reading

For production workloads running on your Azure SQL Database managed instance it is very important to continuously understand the resource consumption and any potential performance issues such that you can react in time and have your business running smoothly. There ... continue reading

When working with Azure AD authentication for Azure SQL DB and DW, you may sometimes encounter certain issues. The table below contains some of the Azure AD authentication problems that may appear when accessing SQL DB/DW, as well as how ... continue reading

Organizations that embraced the option to run Microsoft SQL Server 2017 on Linux have been looking forward to the release of SQL Server 2019. Regardless of which operating system (OS) you choose, it's the same SQL Server database code, and ... continue reading