Announcing Updates to the Modern Servicing Model for SQL Server
On September 28, 2017 we announced the Modern Servicing Model for SQL Server. In that announcement, we made reference to two changes in SQL Server 2017 servicing: SQL Server 2017 Cumulative Updates (CU) will be released monthly for the 1st year, …
Released: SSAS and SSRS 2017+ Management Packs (7.0.10.0)
We are happy to announce that Management Packs for SQL Server 2017 Analysis Services and Reporting Services are released. Please download at: Microsoft System Center Management Pack for SQL Server 2017+ Analysis Services Microsoft System Center Ma …
SSMS 18.0 public preview released
We are very excited to announce the public preview of SQL Server Management Studio 18.0. SSMS has been ported to the VS 2017 Isolated Shell, which brings with it many improvements to look and feel and accessibility. This release expands platform suppor …
Analysing inventory of Managed Instances using T-SQL
Sometime you would need to know how many Managed Instance you have created in Azure cloud. Although you can find all information about the Azure SQL Managed Instances in Azure portal or API (ARM, PowerShell, Azure CLI), sometime it is hard to list all …
Public Preview of Graph Edge Constraints on SQL Server 2019
SQL Server 2017 and Azure SQL Database introduced native graph database capabilities used to model many-to-many relationships. The first implementation of SQL Graph introduced support for nodes to represent entities, edges to represent relationships an …
SQL Server 2019: Celebrating 25 years of SQL Server Database Engine and the path forward
This post is authored by Amit Banerjee, Principal PM Manager, SQL Server andBob Ward,Principal Architect, Microsoft SQL Server Data Services. SQL Server has provided enterprises the capability to manage all facets of their relational data. Over the yea …
August 2018 Leaderboard of Database Systems contributors on MSDN
Congratulations to our August top 10 contributors! Alberto Morillo and Visakh Murukesan maintain their top positions. This Leaderboard initiative was started in October 2016 to recognize the top Database Systems contributors on MSDN forums. T …
SQL Vulnerability Assessment now supports Azure SQL Data Warehouse and Azure SQL Database Managed Instance
SQL Vulnerability Assessment is now available for Azure SQL Data Warehouse and for Azure SQL Database Managed Instance. The assessment functionality and experience are similar to that of SQL Vulnerability Assessment for Azure SQL Database, while exposi …
Storage Configuration Guidelines for SQL Server on Azure VM
SQL Server on Azure Virtual Machines service offers the full control of VM and SQL Server and enables the simplest cloud migration path for SQL Server workloads. SQL IaaS Extension is installed on each SQL VM created through Azure Market Place by defau …
SQL Server 2019 preview containers now available
Starting in SQL Server 2017 with support for Linux and containers, Microsoft has been on a journey of platform and operating system choice. With SQL Server 2019 preview, we are making it easier to adopt SQL Server in containers by enabling new HA scena …
Introducing Microsoft SQL Server 2019 Big Data Clusters
Yesterday at the Microsoft Ignite conference, we announced that SQL Server 2019 is now in preview and that SQL Server 2019 will include Apache Spark and Hadoop Distributed File System (HDFS) for scalable compute and storage. This new architecture that …
Azure Data Studio for SQL Server
Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Previously released under the preview name SQL Operations Studio, Azure Data Stu …
Introducing Batch Mode on Rowstore
Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s run-time conditions. These improvements included: batch mode adaptive joins, batch m …
Always Encrypted with Secure Enclaves – Try It Now in SQL Server 2019 Preview!
Last year, we revealed our efforts to bring confidential computing capabilities of Always Encrypted to the next level, by leveraging secure enclave technologies. Over the last twelve months, the SQL team, alongside Microsoft Research, Windows and Devel …