With Azure Data Studio turning 3, it is maturing quite well.

Azure Data Studio is a game-changer for all Data Professionals.

Join Warwick Rudd as he shows you what Azure Data Studio has for Data Professionals and why it makes it easier for you to do your job.

Azure Data Studio is a cross-platform client tool with hybrid and poly cloud capabilities – now brings KQL experiences for modern data professionals.

In this episode, Julie Koesmarno shows KQL magic in Notebooks and the native KQL experiences – all in Azure Data Studio.

You’ll also learn more about the use cases for KQL experiences in Azure Data Studio and our roadmap.

In this episode with Drew Skwiers-Koballa, you will be introduced to a new experience for database development with the SQL Database Projects extension for Azure Data Studio. 

Whether you are familiar with SQL Server Data Tools (SSDT) or new to SQL projects, you can start editing and building SQL projects in Azure Data Studio on Windows, macOS, and Linux.

Related links:

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

Vicky Harp joins Scott Hanselman to show how Azure Data Studio combined the simple and robust SQL query editing experience of tools like SSMS with the flexibility and collaboration of Jupyter Notebooks. The November 2019 release of Azure Data Studio included SQL Server 2019 Guide as a Jupyter Book, which provides a richer troubleshooting experience.     

Related

SandDance provides data visualization in the context of the data you are operating in and gives you interactive data exploration where you can quickly find pattern, trends and anomalies from the data.

It’s rich interactive 3D viewer gives the effects of different attributes on the data and its ease of use provides data engineers with a powerful in place tool to visualize their data.

Find out more.