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.
ArgumentNullException: Value Cannot Be Null in SQL Server Setup
Value cannot be null was the message when a client’s automated SQL Server installs failed at random. Detail.txt named the parameter instanceName. The generated configuration file had no InstanceName for a default instance, and that is what setup choked on.
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.
SQL SERVER – Reviewing Sleeping Sessions Before Terminating Any Session
An inactive or sleeping session may still be a useful pooled connection. A customer case prompted my earlier session-cleanup script.
Dirty Pages – How to List Dirty Pages From Memory in SQL Server? – Interview Question of the Week #223
Question: How to List Dirty Pages From Memory in SQL Server? Answer: I received question today during my SQL Server Performance Tuning Practical Workshop.