A LIKE search on Query Store text is a good first step, but one search found four statements, including itself. I show how to narrow it down to the real history.
Linked Servers and What Goes Wrong With Them
Investigate linked server performance and failures by checking remote work, provider settings, security mappings, and the alternatives available.
SQL SERVER – Best Practices About SQL Server Service Account and Password Management
Should the SQL Server Service Account be a local or domain admin? No. Best practices from a client Q&A on service accounts, permissions and passwords.
In-Place Upgrade or Side by Side: Choosing Properly
Compare an in-place upgrade with a side-by-side SQL Server migration, including downtime, testing, dependencies, and recovery after cutover.
Creating and Running an SQL Server Unit Test – Best Ways to Test SQL Queries
Testing SQL code matters as much as writing it. I show how to create and run a SQL Server Unit Test with tSQLt, the free open source framework.
Why ’10’ + 5 Returns 15: Mixing Strings and Numbers
The plus sign adds or glues text depending on the types on each side. I show the surprise, the error 245 it can cause, and how text keys get hurt.
Writing a Disaster Recovery Runbook: RPO, RTO and a Restore Test
Build a disaster recovery runbook around agreed RPO and RTO, usable backup chains, instance dependencies, clear roles, and restore tests.







