During load testing, a log backup on a secondary replica failed with Msg 35295 because the last backup LSN was ahead of the redo LSN. Here is why.
SQL SERVER – Queries are in KILLED/ROLLBACK State with Wait PREEMPTIVE_OLEDB_RELEASE
After a network outage, queries stayed in KILLED/ROLLBACK with the undocumented wait PREEMPTIVE_OLEDB_RELEASE. What I saw and how to clear them.
Specified Driver Is Invalid in SQL Server Setup: Error 0x84BB0001
The specified driver is invalid error stopped a SQL Server 2012 installation with code 0x84BB0001. The real clue sat in Detail.txt, in the performance counter files, and a fresh copy of the media fixed it. This post shows how to read the logs, check the counter files and confirm the media.
SQL SERVER – SQL Browser not Starting. Error – The SQL Configuration for SQL is Inaccessible or Invalid
After server hardening, SQL Browser would not start and the event log said the SQL configuration for SQL is inaccessible or invalid. Here is the fix.
Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? – Interview Question of the Week #112
Why use SQL Server Configuration Manager Over Services applet (services.msc) to change a service account? The reasons, from permissions to passwords.
SQL SERVER – How to Apply Patch in AlwaysOn Availability Group Configuration?
A Patch in AlwaysOn Availability Group needs a sequence matched to the topology. I start this two-replica example with the secondary.
Number of Cluster Nodes Error: Add Node Fails on Enterprise Edition
The number of cluster nodes error stopped a client from adding a second node, even on Enterprise edition. Detail.txt showed the edition as Invalid. The file setup uses to read the edition was missing from the Shared folder.