Enhance your Log Analytics data exploration in Azure Data Studio
The Azure Monitor Logs extension in Azure Data Studio is now available in preview. The extension is supported in Azure Data Studio August 2021 release, v1.32.0.Administrators can enable platform logging and metrics to one of their Azure services such as ... continue reading
Recent updates for Data-Tier Application Framework and SqlPackage
In this article, we will cover some recent changes to the Data-Tier Application Framework (DacFx) and SqlPackage. DacFx is a library that provides APIs for database deployment and development scenarios and SqlPackage is a command line interface to DacFx for ... continue reading
What’s new with SQL Server Big Data Clusters
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
OPS119: Databases are cattle too! Running highly available databases consistently with Azure Arc
Have you heard people say 'containers or Kubernetes is not for databases'? Let me show you how that is definitely not the case in 2021. Kubernetes provides an abstraction layer over any infrastructure and an orchestration engine that powers Arc ... continue reading
SQL Tools December release recap
The December releases of Azure Data Studio 1.25 and SQL Server Management Studio (SSMS) 18.8 are now generally available. Additionally, the mssql extension for Visual Studio Code has recently been updated to version 1.10.0. Read on to learn more about ... continue reading
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
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
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
