Improving concurrency of asynchronous statistics update
Executive summary In Azure SQL Database and Azure SQL Managed Instance, the background process that updates statistics asynchronously can now wait for the schema modification lock on a low priority queue. This improves concurrency for workloads …
How to troubleshooting “SQL Server is terminating because of fatal exception c06d007e”
Case 1, with Dump generated Issue definition: ======== Customer have SQL 2008/2012/2014 running on the same server, and then applied the SP4 for SQL Server 2012 in Windows update. But after this customer saw some issue from application side, then you r …
How to troubleshoot “SQL Server is terminating because of fatal exception c06d007e”
Case 1, with Dump generated Issue definition: ======== Customer have SQL 2008/2012/2014 running on the same server, and then applied the SP4 for SQL Server 2012 in Windows update. But after this customer saw some issue from application side, then you r …
Schema change getting applied repeatedly every time Merge agent runs
Recently worked on an interesting case. Customer had an existing Merge Replication and it was working fine. They added a new article to the existing Publication and ran the Snapshot Agent. Now Every time Merge agent runs we see that Schema changes were …
Rowgoal impacts the estimated row
The engineer asked me a question, how does the optimizer estimate the row for index scan(range scan). he observed 100-109 estimated row for index scan but he wants to know the reason. As my understanding, if there is no predicated, the es …
How to manually reuse the identity range under the merge replication
when you choose the auto manage the identity range on the merge replication, and some subscriptions dropped, that identity range could not reuse. see this sample: this sample used too large range for auto managed identity range. after some subsc …
REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT and error 988 –SQL 2017 AlwaysOn
Recently we got the issue from customer, they failed to add the database into the existing AG with error 988: Msg 988, Level 14, State 1, Line 17 Unable to access database ‘ag_03’ because it lacks a quorum of nodes for high availability. Try the operat …
Released: Update to Microsoft OLE DB Driver 18 for SQL Server
OLE DB Driver 18.4 for SQL Server is released today, bringing support for Transparent Network IP Resolution and UTF-8 client-side support to the driver along with a number of fixes. The driver can be downloaded directly from Microsoft. Change …
Azure SQL Sessions Recap at Microsoft Build 2020
This year, Microsoft Build was delivered as a virtual, global event for participates over 48 continuous hours. The Azure SQL team had the opportunity to show off what they’re working on – covering everything from Azure SQL Edge to Cloud. Y …
Cumulative Update #13 for SQL Server 2016 SP2
The 13th 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 m …
SQL CLR .NET Framework runtime fatal error due to Uneven Number of CPUs Across Processor Groups
Problem If you’re using SQL CLR, you may have encountered an unexpected SQL Server service termination issue on SQL Servers with a large number of CPUs. Symptoms SQL Server service terminates unexpectedly. In the ERRORLOG, you’ll see the followi …
Public preview: TDE with customer managed keys on Azure SQL Hyperscale
Azure SQL Transparent Data Encryption (TDE) with customer-managed keys enables customers to control the key lifecycle management, permissions and operations of keys stored in their own Azure Key Vault. We are announcing the public preview of …
Early technical preview of JDBC Driver 8.3.1 for SQL Server released
We have released a new early technical preview of the JDBC Driver for SQL Server which contains numerous additions and changes. Precompiled binaries are available on GitHub and also on Maven Central.Below is a summary of the new add …
Azure SQL Zone Redundant Configuration for High Availability | Data Exposed
In this video, Emily Lisa and Anna Hoffman discuss how to make a database zone redundant in Azure SQL, and the High Availability benefits of the zone redundant configuration. Watch on Data Exposed Additional Resources: High-availability a …
Data Exposed | Azure SQL Zone Redundant Configuration for High Availability
In this video, Emily Lisa and Anna Hoffman discuss how to make a database zone redundant in Azure SQL, and the High Availability benefits of the zone redundant configuration. Watch on Data Exposed Additional Resources: High-availability a …