Cumulative Update #10 for SQL Server 2017 RTM
The 10th 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 m …
Cumulative Update #13 for SQL Server 2014 SP2
The 13th 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 …
Create linked server to readable secondary replica in Managed Instance Business Critical service tier
Azure SQL Database Managed Instance is a fully managed SQL Server Database Engine hosted in Azure cloud that provides most of the Azure SQL Pass and SQL Server functionalities, such as linked servers and built-in free secondary read-only replicas. In t …
Issue with security update for the Remote Code Execution vulnerability in SQL Server 2016 SP1 (GDR): 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 2016 SP1 GDR (KB4293801), an issue may occur after applying the update where the sqlceip.exe process exper …
Resolved: Issue with security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (CU): August 14, 2018
We have replaced KB4293807 with KB4458621 resolving the issue described below. Updated SQL Server 2016 SP2 CU packages are now available on the Microsoft Download Center and Microsoft Update as outlined in KB4458621. If you have previously installed KB …
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 …
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 …