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.

Sydney Smith joins Scott Hanselman to show the rich editing experience provided by the PowerShell extension in Azure Data Studio by creating a SQL Server in a Linux Docker container with external storage—all using PowerShell Core in Azure Data Studio.

To get started with the notebook used in the episode check out: PowerShell/vscode-powershell

[00:01:36] Demo – Getting started – installing modules

[00:04:45] Demo – Creating a new editor file