Forget which data types your SQL Server version supports? I run sp_datatype_info, which lists every supported type with precision, nullability and searchability.
SQL SERVER – Automatic Seeding of Availability Database ‘DB’ in Availability Group ‘AG’ Failed With an Unrecoverable Error
Automatic seeding of availability database failed with an unrecoverable error: it showed on the secondary, then vanished. Here is what ERRORLOG said.
SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback
Killing a long transaction used to mean a rollback that took forever. SQL Server 2019 fixes that with Accelerated Database Recovery and its instant rollback.
How to Execute Query Without Using F5 or Query Toolbar in SSMS? – Interview Question of the Week #224
How do you execute a query in SSMS without F5 or the Query Toolbar? An attendee in a private training asked for a unique way, and here is a less known method.
SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group
While recovering a cluster in ForceQuorum mode, dropping an availability group failed: Failed to destroy the WSFC group. Here is how I got past this error.
SQL SERVER – Installation Error: System.ArgumentNullException – Value Cannot be Null
A client automating SQL Server installs saw random failures: System.ArgumentNullException, Value cannot be null. Here is what Detail.txt showed and the cause.
SQL SERVER – How Do I Evaluate Monitoring Tools?
I evaluate monitoring tools by collection cost, historical context and usefulness in choosing a correction. Customer discussions shaped those three criteria.