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

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

HDFS Tiering is Microsoft’s latest contribution to the Apache HDFS open source project.

In this video, learn how to use the HDFS tiering feature in SQL Server big data clusters, to seamlessly get access to your remote HDFS compatible storages for querying and analysis.

To learn more, check out our documentation: https://docs.microsoft.com/sql/big-data-cluster/hdfs-tiering?view=sql-server-ver15&WT.mc_id=dataexposed-c9-niner.