It's just SQL: CLR in Azure SQL Database Managed Instance | Data Exposed

Posted on Posted in aft-sql, SQL Azure

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. In this video, Anna Hoffman and Colin Murphy go over what CLR is, how to […]

How to connect to Azure SQL Database from Azure Data Studio | Data Exposed

Posted on Posted in aft-sql, SQL Azure

Want to get started with Azure Data Studio (https://docs.microsoft.com/en-us/sql/azure-data-studio/download) 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. [00:00] – Introduction [00:25] – Demo showing how to connect to Azure SQL Database from Azure Data […]

Deployment options for Azure SQL Database | Data Exposed

Posted on Posted in aft-sql, SQL, SQL Azure

Learn more about the deployment options for Azure SQL Database. More information: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-technical-overview [00:00] – Introduction [00:41] – Deployment options in Azure SQL Database, including elastic pool, single database and Managed Instance [03:33] – DTU service tiers (Basic, Standard, Premium) [07:08] – vCore service tiers (General Purpose, Hyperscale, Business Critical) [08:08] – General Purpose tier: […]

It's just SQL: Collations in Azure SQL Database Managed Instance | Data Exposed

Posted on Posted in aft-sql, SQL Azure

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 SQL Database Managed Instance. [00:00] – Introduction [00:29] – What is a collation? [00:55] – […]

Discovering, classifying, labeling & protecting SQL data – now available for all | Data Exposed

Posted on Posted in SQL Azure

Learn all about the new data classification capabilities built into Azure SQL Database. Data Classification enables discovering, classifying, labeling & protecting the sensitive data in your databases. Examples of sensitive data include business, financial, healthcare, personally identifiable data (PII). Discovering and classifying your most sensitive data can play a pivotal role in your organizational information […]