Reaching Azure disk storage limit on General Purpose Azure SQL Database Managed Instance
Azure SQL Database Managed Instance is SQL Server implementation on Azure cloud that keeps all database files on Azure storage. In this post you will see how Managed Instance allocates disks in the storage layer and why is this important. Azure SQL Dat …
Issue with security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (CU): August 14, 2018
On Tuesday August 14, we published a Security Update for six different releases of SQL Server 2016 and 2017. For one of those releases, SQL Server 16 SP2 CU (KB4293807), we inadvertently published additional undocumented trace flags that are normally n …
Database ownership chaining in Azure SQL Managed Instance
Azure SQL Managed Instance enables you to run cross-database queries the same way you do it in SQL Server. It also supports cross-database ownership chaining that will be explained in this post. Cross database ownership chaining enables logins to acces …
July 2018 Leaderboard of Database Systems contributors on MSDN
Congratulations to our July 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. The …
Cloud data and AI services training roundup August 2018
To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post. SQL Server Build modern applications using the language of your choice …
Azure SQL Vulnerability Assessment – now with PowerShell support!
You can now manage your SQL Vulnerability Assessments at scale using the new SQL VA PowerShell cmdlets. The cmdlets can be found in the Azure Resource Manager module, AzureRM 6.6.0, within the AzureRM.Sql package. Take a look at the AzureRM PowerShell …
July 10, 2018 Windows updates cause SQL startup issues due to “TCP port is already in use” errors
We have recently become aware of a regression in one of the TCP/IP functions that manages the TCP port pool which was introduced in the July 10, 2018 Windows updates for Windows 7/Server 2008 R2 and Windows 8.1/Server 2012 R2. This regression may cause …
Pearl Abyss: Massive Scale using Azure SQL Database
Pearl Abyss is a Korea based game development studio established in 2009. Black Desert Online, a PC-massively multiplayer online role-playing game (MMORPG), is their main title in production published across the globe. On February 28, 2018, Pearl …
Azure SQL Database team at Data Platform Summit 2018
Azure SQL Database Engineering Team (@azuresqldb) represented by (Ajay Jagannathan, and Sunil Agarwal) will be speaking at Data Platform Summit 2018 (#DPS10), Asia’s Premier Data & Analytics Conference taking place on August 9-11 in Bangalore …
Cumulative Update #9 for SQL Server 2017 RTM
The 9th cumulative update release for SQL Server 2017 RTM 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 …
The July release of SQL Operations Studio is now available
We are excited to announce the July release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started. SQL Operations Studio is a data management tool that enables you to work with SQL Server, …
Cumulative Update #10 for SQL Server 2016 SP1
The 10th 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 …
Cumulative Update #2 for SQL Server 2016 SP2
The 2nd 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 …
Approximate Count Distinct enters Public Preview in Azure SQL Database
Kevin Farlee Principal Program Manager, SQL Database We are pleased to announce the public preview of Approximate Count Distinct, the first of the Approximate Query Processing features. Approximate Query Processing is a new family of features whi …