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.

You can learn more about Private Link in Azure SQL Database here https://docs.microsoft.com/en-us/azure/sql-database/sql-database-private-endpoint-overview?WT.mc_id=dataexposed-c9-niner , and Private Link generally for Azure here https://docs.microsoft.com/en-us/azure/private-link/private-endpoint-overview?WT.mc_id=dataexposed-c9-niner.

At the beginning, Rohit mentions a playlist with other videos you should review to get more background on the topic. You can see the playlist here: https://www.youtube.com/playlist?list=PL3EZ3A8mHh0xtbf4Cr2yR4-xsUtELwPjw?WT.mc_id=dataexposed-c9-niner

Time Index

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

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