In this video, Emily Lisa and Anna Hoffman discuss how to make a database zone redundant in Azure SQL, and the High Availability benefits of the zone redundant configuration.

Content index:

  • [00:47] What is an availability zone?
  • [01:25] How does it relate to Azure SQL?
  • [02:14] Regions that support Availability Zones
  • [03:10] Demo to Enable Zone Redundant Configuration
  • [04:10] How it affects SLAs

In the second part of this two-part video segment, Rohit Nayak dives deeper into the new capabilities for Azure SQL Database for Private Endpoints.

Be sure to watch the first episode to understand what Private Endpoint for Azure SQL Database.

Time index:

  • [01:09] Set-up
  • [02:00] Demo: How to connect from Public IP Address to Private Endpoint
  • [08:36] Connecting Client VM to SQL Database with a Private Endpoint
  • [10:45] How to check your deployment succeeded
  • [14:08] Now that you created a Private IP Address, can you login to the IP Address itself?
  • [15:50] Double-checking on another machine
  • [16:30] 3 key takeaways

In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show how to create auto-failover groups in Azure SQL using PowerShell notebooks and a Java application.

This video was based on a tutorial, which you can follow here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-implement-geo-distributed-database?tabs=azure-powershell&WT.mc_id=dataexposed-c9-niner.

To compare geo-replication and auto-failover groups, refer to the table here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity#compare-geo-replication-with-failover-groups&WT.mc_id=dataexposed-c9-niner.

Time Index:

  • [00:30] Background
  • [01:15] Comparing geo-replication and auto-failover groups
  • [02:12] Tutorial for implementing a geo-distributed database
  • [02:45] Demo starts
  • [04:55] Failover initiated
  • [06:21] Fail back and summary

In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show one way for loading data from Azure Blob storage into Azure SQL Database.

Time Index:

  • [00:25] Background
  • [01:25] Azure SQL Notebook in Azure Data Studio
  • [02:06] Step 1: Create a table and schema
  • [02:20] Step 2: Create a master key
  • [02:37] Step 3: Create a database scoped credential
  • [03:16] Step 4: Create an external data source to the container
  • [04:15] Step 5: Bulk insert a single file and tips
  • [06:18] Summary

More Data Exposed: https://www.youtube.com/playlist?list=PLlrxD0HtieHieV7Jls72yFPSKyGqycbZR&WT.mc_id=dataexposed-c9-niner

In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show PowerShell notebooks and Azure SQL inside Azure Data Studio. Learn how you can leverage PowerShell notebooks and other CLI tools in them to manage your Azure SQL Databases and Managed Instances.

Time index:

  • [00:00] Intro
  • [00:32] Notebooks in Azure Data Studio
  • [01:20] PowerShell kernel for notebooks
  • [02:20] Setting up Azure (Az) module for PowerShell in your notebook
  • [03:17] Running interactive commands in the integrated terminal in Azure Data Studio
  • [04:21] Resources
  • [04:53] Wrap-up

More Data Exposed videos:

https://www.youtube.com/playlist?list=PLlrxD0HtieHieV7Jls72yFPSKyGqycbZR&WT.mc_id=dataexposed-c9-niner

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.

Learn more about the deployment options for Azure SQL Database. 

More information.

[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: Provisioned vs Serverless
[09:16] – Compute Generation: Gen4 vs Gen5
[10:01] – Decision points for Provisioned vs Serverless compute tiers
[13:25] – Saving money with Azure Hybrid Use Benefits
[13:58] – Business Critical tier and read scale-out
[15:42] – Hyperscale tier
[21:03] – Summary of deployment options
[22:17] – Finalizing the creation of a new Azure SQL Database
[23:02] – Summary and wrap-up

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 protection stature.

Data discovery & classification is part of the Advanced Data Security (ADS) offering, which is a unified package for advanced SQL security capabilities.

Find out more about Advanced Data Security at: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-advanced-data-security?WT.mc_id=dataexposed-c9-niner-fw .