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.

Time Index:

  • [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.

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 how you can get started with Azure CLI and the Azure Cloud Shell with respect to Azure SQL.      

Time Index:

  • [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

For more info, see https://docs.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest&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