Released: Public Preview for SQL Server Management Packs (7.0.33.0)
Updates to Management Packs for SQL Server, Reporting Services, Analysis Services, and Azure SQL Managed Instance (7.0.33.0) are available for public preview. Please install this public preview version and provide us feedback. We appreciate t …
Microsoft Drivers 5.10.0 Beta 2 for PHP for SQL Server Released
We recently released the next beta of the Microsoft Drivers for PHP for SQL Server, version 5.10.0-beta2. This beta release has been built with PHP 7.3+ and tested on all supported platforms. Notable items about this release over beta 1 include: …
Cumulative Update #14 for SQL Server 2019 RTM
The 14th cumulative update release for SQL Server 2019 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 …
Released: General Availability of Microsoft.Data.SqlClient 4.0
We have released for general availability Microsoft.Data.SqlClient 4.0. This .NET Data Provider for SQL Server provides general connectivity to the database and supports all the latest SQL Server features for applications targeting .NET Framework, .NET …
Recover TDE Databases in Disaster : Recover Steps for 3 Common Scenarios
Summary: This article discusses 3 common scenarios where you can and cannot recover your TDE-enabled database that using native SQL certificate stored on master database to encrypt the TDE (not using AKV or 3rd-party EKM/HSM). In unexpecte …
Prevent SQL Server Dump Generation in Hot Cases: Common Ways & Scenarios
Summary: This article discusses common way to prevent SQL dump from being generated in different exception scenarios. This workaround serves for hot scenario where you need to immediately stop the PRODUCTION outage caused by dump generation. You should …
Prevent SQL Server Dump Generation in Hot Cases: Common Ways & Scenarios
Summary: This article discusses common way to prevent SQL dump from being generated in different exception scenarios. This workaround serves for hot scenario where you need to immediately stop the PRODUCTION outage caused by dump generation. You should …
Use Trace Flag 902 (TF902) to Bring Up Your SQL Service in Failed Post Upgrade Script
Summary: This article discusses using TF902 as a quick workaround to bring up your SQL Server service if it fails to be started due to post upgrade script failure after installing SQL Server patch. Further troubleshooting steps to address the post upgr …
Use Orca.exe Tool to Verify Corrupted MSI/MSP file in Failed SQL Patching
DISCLAIMER : THIS CODE AND INFORMATION IS PROVIDED « AS IS » WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Multiple reasons c …
Common Causes and Troubleshooting Solutions for SQL AG Data Synchronization Latency
This article summarizes the common causes , solutions and troubleshooting mechanism for SQL Availability Group (AG) data synchronization latency between primary and secondary for both synchronous-commit and asynchronous-commit mode. The latency …
Early technical preview of JDBC Driver 9.5.0 for SQL Server released
We have released a new early technical preview of the JDBC Driver for SQL Server which contains a few additions and changes. Precompiled binaries are available on GitHub and also on Maven Central.Below is a summary of the new addi …
PASS Data Community Summit keynote: a bridge to a new universe
It is almost time for PASS Data Community Summit 2021, a free online conference for the Microsoft data platform professional. The conference, hosted by Redgate, will include the latest SQL Server and Azure data innovations, practical training, and netw …