Select Page
graphical user interface, application

Building and sharing Jupyter Books in Azure Data Studio

The notebook experience in Azure Data Studio allows users to create and share documents containing live code, execution results, and narrative text. Potential usage includes data cleaning and transformation, statistical modeling, troubleshooting guides, data visualization, and machine learning. Jupyter books ... continue reading
Azure Data Explorer connectivity support in Azure Data Studio

Analyze data in Azure Data Explorer using Kusto Query Language (KQL) extension in Azure Data Studio

The Kusto (KQL) extension in Azure Data Studio is now available in preview. This native Kusto (KQL) support brings another modern data experience to Azure Data Studio, a cross-platform client for Windows, macOS, and Linux. Users can now connect and ... continue reading

Changing default MAXDOP in Azure SQL Database

Executive Summary To improve customer workload performance and reduce unnecessary resource utilization, the default MAXDOP setting for new databases in Azure SQL Database is changing from the previous default of 0 (unlimited) to 8. Why MAXDOP matters The “max degree ... continue reading

Data Exposed + MVPs = Better together

Today, we have exciting news to share as part of the launch of joint efforts between multiple organizations in Microsoft and the MVP community. I thought it'd be interesting to take a look at how far we've come (and how ... continue reading

Expanding SQL Server Big Data Clusters capabilities, now on Red Hat OpenShift

SQL Server Big Data Clusters (BDC) is a new capability brought to market as part of the SQL Server 2019 release. BDC extends SQL Server's analytical capabilities beyond in-database processing of transactional and analytical workloads by uniting the SQL engine ... continue reading

Load data from Azure Blob storage into Azure SQL | New Data Exposed episode

Curious how loading data in Azure SQL Database is different than SQL Server? In this short episode, I walk through loading a single file (located in Azure Blob storage) into Azure SQL Database. This is all done using a SQL ... continue reading

Load data from Azure Blob storage into Azure SQL | New Data Exposed episode

Curious how loading data in Azure SQL Database is different than SQL Server? In this short episode, I walk through loading a single file (located in Azure Blob storage) into Azure SQL Database. This is all done using a SQL ... continue reading

New Data Exposed episode: Updating connection policies for Azure SQL

Ever wondered which connection policy you should use for Azure SQL, and what the performance impacts might be? In the latest episode of Data Exposed, we walk through how to set the policy with PowerShell Notebooks in Azure Data Studio, ... continue reading

How to use Jupyter Notebooks in Azure Data Studio

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 ... continue reading

New Data Exposed episode: How to connect to Azure SQL Database from Azure Data Studio

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 ... continue reading