Brent Ozar Unlimited demonstrates how to install Azure Data Studio for Microsoft SQL Server in this livestream.
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.
- [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
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.
[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
More Data Exposed videos:
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.
- Announcing Jupyter Book support blog
- Download and install Azure Data
- microsoft/azuredatastudio GitHub
- Latest news on the SQL Server
- Create a free account
In this video, will learn how to use text and code cells to build an interactive document experience.
In addition, you’ll see some basics to edit your SQL notebook.
Learn more about SQL Notebooks here:
Want to get started with Azure Data Studio but don’t know where to begin?
In this video, Anna Hoffman shows you how to get connected to Azure SQL Database for the first time using Azure Data Studio.
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.
Did you know that Azure Data Studio has a rich notebook experience?
Whether you need a Python, Pyspark, or a fully integrated SQL kernel, you can start creating and editing your notebooks from anywhere in one tool.
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