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.
SQL SERVER – Unable to See Tables (Objects) in SSMS
A client could query a table but was unable to see tables in SSMS Object Explorer. A DENY permission was the cause. Here is how I tracked it down.
SQL SERVER – Maintenance Plan failing with 0x80131904 – A network-related or instance-specific error occurred while establishing a connection to SQL Server.
After patching, a client found every Maintenance Plan failing with 0x80131904, a network-related or instance-specific error. Here is the cause and the fix.
How to do Pagination in SQL Server? – Interview Question of the Week #111
How do you do pagination in SQL Server? A popular interview question. Instead of pulling every row into the app, here is a method that returns just one page.
SQL SERVER – Event ID 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name)
A named instance would not start, and Event ID 26 said the install was corrupt or tampered with (Error Getting Instance Name). Here is what I found.
SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed Because the Following SET Options have Incorrect Settings: ‘QUOTED_IDENTIFIER’.
A query ran fine in SSMS but failed in an Agent job with error 1934: SET options have incorrect settings: ‘QUOTED_IDENTIFIER’. Here is the simple fix.