In the first part of this two-part video series, Kate Smith gives an introduction to what Azure SQL Database Elastic jobs are, and when you should consider using them, as well as what products support Elastic Jobs. [00:40] What are elastic jobs[01:26] When should we use elastic jobs[02:35] What databases are supported[03:20] Moving databases To learn more, visit: Fundamental Concepts for Elastic Jobs in Azure SQL Database

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. [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 SLAsAdditional Resources:High-availability and Azure SQL Database: https://docs.microsoft.com/azure/sql-database/sql-database-high-availability?WT.mc_id=dataexposed-c9-ninerRegions and Availability Zones in Azure: https://docs.microsoft.com/azure/availability-zones/az-overview?WT.mc_id=dataexposed-c9-ninerRegions that support Availability Zones in Azure: https://docs.microsoft.com/azure/availability-zones/az-region?WT.mc_id=dataexposed-c9-ninerSLA for Azure SQL Database: https://azure.microsoft.com/support/legal/sla/sql-database/v1_4/?WT.mc_id=dataexposed-c9-niner

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. Watch the first episode to understand what Private Endpoint for Azure SQL Database is. Additional Resources:Private Link in Azure SQL DatabasePrivate Link for AzureEven more videos on the topic [01:09] Set-up[02:00] Demo: How to connect from Public IP Address to Private Endpoint[08:36] Demo: 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 the first part of this two-part video segment, Rohit Nayak explains what Private Endpoint for Azure SQL Database is and how it relates to the overall connectivity story for Azure SQL. Additional Resources:Private Link in Azure SQL DatabasePrivate Link for AzureEven more videos on the topic [00:46] Connectivity architecture for public endpoint[01:46] Private Link overview[03:55] Why Private Link?[05:08] How does Private Endpoint work?[06:55] Client connectivity scenarios to Private Endpoint[09:05] Summary and what's next

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. Found our more at the following links:- Drive higher utilization of Azure HDInsight clusters with autoscale: https://azure.microsoft.com/en-us/blog/drive-higher-utilization-of-azure-hdinsight-clusters-with-autoscale/?WT.mc_id=dataexposed-c9-niner- Automatically scale Azure HDInsight clusters: https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-autoscale-clusters?WT.mc_id=dataexposed-c9-niner [00:33] Introduction[01:00] Customer challenge[01:55] Static clusters[03:40] Solution is HDInsightAutoscale[06:00] Demo of deployment[09:05] Demo of load-balanced scaling[10:00] Demo of scheduled scaling[11:20] Validating cluster size

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. [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 Follow Anna Hoffman and Jeroen ter Heerdt on Twitter at https://twitter.com/AnalyticAnna and https://twitter.com/JeroenterHeerdt.

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. For more info, see https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=azuresqldb-current&WT.mc_id=dataexposed-c9-niner [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

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 [00:23] Background[01:24] Demo explanation[01:48] Checking the connection policy[02:30] Update to Proxy and test[04:01] Update to Redirect and test[05:05] Comparing Proxy and Redirect[06:02] Closing

In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show how you can get started with Azure CLI and the Azure Cloud Shell with respect to Azure SQL. For more info, see https://docs.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest&WT.mc_id=dataexposed-c9-niner. [00:00] Intro[00:38] Intro to the Azure Cloud Shell (ACS)[01:06] Switch between Bash and PowerShell in ACS[01:20] Azure CLI is cross-platform[01:48] Set Azure subscription[02:05] Set default resource group and logical server[02:28] Demo of Azure CLI SQL commands[03:37] All Azure CLI commands available[04:28] Azure CLI in PowerShell notebooks in Azure Data Studio

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. For more info, see https://docs.microsoft.com/en-us/sql/azure-data-studio/sql-notebooks?view=sql-server-ver15&WT.mc_id=dataexposed-c9-niner. [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