Introduction to Azure SQL for beginners (1 of 61) | Azure SQL for Beginners

Posted on Posted in aft-sql, Azure SQL

Azure SQL for beginners is a series to help bring SQL Server professionals to Azure SQL (Azure SQL Database, Azure SQL Managed Instance, and SQL Server in Azure VM). In this video, you’ll get an overview of how (and why) the series is structured. For the full Azure SQL Fundamentals learning path on Microsoft Learn, visit: https://aka.ms/azuresqlfundamentalsyt Watch […]

Drive higher utilization of Azure HDInsight clusters with Autoscale | Data Exposed

Posted on Posted in aft-sql, Azure Services, HDi

Are you looking to gain more control of the costs of operating your growing Azure HDInsight clusters? Are you interested in driving higher utilization of your Azure HDInsight clusters? If yes, then you should definitely watch this video to learn about how to leverage Azure HDInsight Autoscale feature to help you achieve higher cost efficiency. […]

Updating connection policies for Azure SQL | Data Exposed

Posted on Posted in aft-sql, SQL Data Services

In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show the connection policy options available and why you might choose one over the other. For more info, see: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture#connectivity-architecture&WT.mc_id=dataexposed-c9-niner. The videos from Rohit on Connectivity that Anna mentions at the beginning of the video can be found here: 1. https://www.youtube.com/watch?v=e0tWC0XmOgc&list=PL3EZ3A8mHh0yxojwiqsWHtsPX8Uwy4gmW&index=20&t=0s&WT.mc_id=dataexposed-c9-niner 2. https://www.youtube.com/watch?v=h07zqaVgtkE&list=PL3EZ3A8mHh0yxojwiqsWHtsPX8Uwy4gmW&index=19&t=0s&WT.mc_id=dataexposed-c9-niner    […]

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] – […]