The October release of Azure Data Studio is now available
We are excited to announce the October release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio and review the Release Notes to get started. Note: If you are currently using the preview version …
DBA essentials—SQL Server 2017 security, performance tuning, and more—inside out
Whether youre an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organizations data to work. To turn the next-to-impossible into the practical, you need a com …
Announcing Public Preview of Accelerated Database Recovery
Today we are excited to announce the public preview of Accelerated Database Recovery! Accelerated Database Recovery (ADR) is a new SQL Server Engine feature (available in Azure SQL, Azure SQL Data Warehouse, and SQL Server on-premises) that greatly imp …
Cumulative Update #14 for SQL Server 2014 SP2
The 14th cumulative update release for SQL Server 2014 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 m …
Modernize your SQL Server at the PASS Summit 2018
Each year thousands of data professionals make the annual visit to Seattle, Washington for the Professional Association for SQL Server Summit. This is a community driven organization and event but Microsoft has been a major contributor, sponsor, and pa …
Join us at PASS Summit 2018 – Nov 6-9, 2018!
Get inspired by our industry-leading keynote speakers on the Microsoft data platform at PASS Summit 2018! There has never been a more exciting time for data professionals and developers as more organizations turn to data-driven insights to stay ahead a …
September 2018 Leaderboard of Database Systems contributors on MSDN
Congratulations to our September 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 …
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 …