SQL Server Team articles

Avatar photo
SQL Server Team
Published 
2 min read

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 browse their Azure Data Explorer clusters and databases, write and run KQL, as well as author notebooks with Kusto kernel, all equipped with IntelliSense.
Published 
7 min read

The September 2020 release of Azure Data Studio is now available 

The September release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started. Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our GitHub.
Published 
3 min read

The release of the Azure Data Studio extension generator is now available 

This post is co-authored by Anjali Agarwal and Laura Jiang. The release of the Azure Data Studio extension generator is now available. Install the generator through npm and get started with extension development with these Azure Data Studio extension tutorials. The Azure Data Studio extension generator is a command line tool designed to help extension authors get started with the process of extension development.
Published 
2 min read

The August 2020 release of Azure Data Studio is now available 

The August release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started. Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions. Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our GitHub.
Published 
2 min read

SQL Server Management Studio 18.6 is now generally available  

The release of SQL Server Management Studio (SSMS) 18.6 is now available for download. Today we’re sharing some of the updates from the release and the ongoing work in SQL Server Management Studio. Download SSMS 18.6 and read on for some highlights from the SSMS Release Notes.  The 18.6 release is the second major release of SSMS in 2020 and packs several high impact changes, including a fix for crashes in database diagrams. Key fixes include:   Save to XEL file error fix.  Bacpac file import error fix.
Published 
3 min read

The July 2020 release of Azure Data Studio is now available 

The July release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started. Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions. Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our GitHub.
Published 
2 min read

Unlock your free Azure replica for SQL Server with DH2i 

Are you aware that you may be entitled to a free SQL Server license in the cloud for disaster recovery? Recently-announced licensing benefits enable this scenario, and a third-party offering from DH2i can help you set up this configuration to ensure business continuity for your business.
Published 
1 min read

Apache Spark Connector for SQL Server and Azure SQL is now open source 

Accelerating big data analytics with the Spark connector for SQL Server  We’re happy to announce that we have open–sourced the Apache Spark Connector for SQL Server and Azure SQL on GitHub. Born out of Microsoft’s SQL Server Big Data Clusters investments, the Apache Spark Connector for SQL Server and Azure SQL is a high-performance connector that enables you to use transactional data in big data analytics and persists results for ad-hoc queries or reporting.
Published 
4 min read

The June 2020 release of Azure Data Studio is now available 

The June release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started. Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions. Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our GitHub.
Published 
3 min read

The May 2020 release of Azure Data Studio is now available 

The May release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started. Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions. Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our GitHub.
Published 
2 min read

Announcing mssql-cli is now generally available on macOS and Linux 

We are excited to announce that mssql-cli is now generally available on macOS and Linux. mssql-cli is an open source and cross-platform command-line tool (CLI) to manage SQL Server on-prem and on the cloud. We are a proud member of the dbcli family of open source command line tools to manage relational databases.
Published 
2 min read

Migrate SQL workloads to the cloud with confidence 

Wouldn’t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence. That type of crystal ball is essentially what Microsoft gives us in the form of Microsoft Database Experimentation Assistant (DEA).