SSMS 18.0 Public Preview 5 Released
We are very excited to announce the release of Public Preview 5 of SQL Server Management Studio (SSMS) 18.0. This release has a number of new features and capabilities and several bug fixes across SQL Server Management Objects (SMO), UI, etc. You can d …
Modify Azure SQL Database Managed Instance using Azure CLI
Azure SQL Managed Instance is fully-managed SQL Server Database Engine hosted in Azure cloud. With Managed Instance you can easily add/remove cores associated to the instance and change the reserved size of the instance. You can use Azure CLI to easily …
Create Azure SQL Managed Instance using Azure CLI
Azure command line interface (CLI) is a set of commands that you can use to create and manage Azure resources. In this post your will see how can you create Managed Instance using Azure CLI. The Azure CLI is Microsoft’s cross-platform command-lin …
Cumulative Update #4 for SQL Server 2016 SP2
The 4th cumulative update release for SQL Server 2016 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing mo …
Cumulative Update #12 for SQL Server 2016 SP1
The 12th cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing m …
Diagnostic Data for Synchronous Statistics Update Blocking
Consider the following query execution scenario: You execute a SELECT query that triggers an automatic synchronous statistics update. The synchronous statistics update begins execution and your query waits (is essentially blocked) until the fresh stati …
Creating a data hub for your analytics with PolyBase
Data is the new currency of the digital world, and Microsoft is uniquely positioned to help businesses and consumers get the most out of their data assets. With the leading database in the world, SQL Server, and the rapidly growing Azure cloud data pla …
Released: Public Preview for SSRS 2017+ Management Pack with Power BI Reporting Server Support
We are getting ready to release an update for SQL Server Reporting Services 2017+ Management Pack. We are introducing support for monitoring Power BI Report Server with this management pack. It now provides the same level of monitoring f …
What Azure permissions are required to create SQL Managed Instance?
Azure SQL Managed Instance is a fully managed SQL Server Instance hosted in Azure cloud that is placed in your Azure VNet. Users who are creating instances need to have some permissions. In this post you will see the minimal permissions required to cre …
Public preview of derived tables and views on graph tables in MATCH queries
SQL Server 2017 and Azure SQL Database introduced native graph database capabilities for modeling many-to-many relationships. The first implementation of SQL Graph introduced support for nodes to represent entities, edges to represent relatio …
Introducing Scalar UDF Inlining
Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s runtime conditions. These improvements included: batch mode adaptive joins, batch mode mem …
Announcing: Preview of Machine Learning Services with R support in Azure SQL Database
We are excited to announce that Machine Learning Services with support for R is now available for public preview on Azure SQL Database. Machine Learning Services has transformed SQL Server into a versatile machine learning platform. We are now bringing …
Harness the future with the ultimate hybrid platform for data and AI
Today Im excited to give the Day 1 keynote at PASS Summit v.20, a gathering of our longtime community of SQL Server users and data professionals. PASS Summit is an amazing chance to see the faces of old and new friends. Its a place to meet with custome …
The November release of Azure Data Studio is now available
We are excited to announce the November release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studioand review the Release Notes to get started. Note: If you are currently using the preview version …