Jupyter Notebooks bring a wonderful capability to hand someone a single file that contains both code, and instructions on how to run that code.

What happens when you need to do the same thing as one of your existing Notebooks, but now you need to do it at scale? What if you could take your existing Notebook and add parameters for things like Server name & Database? In this episode with Aaron Nelson, take a look at how new features in Azure Data Studio can help you take your Notebooks to the next level of re-usability.

Resources:

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