Use WITH CHECKSUM for backups, inspect checksum history, verify backup media, and understand why restored CHECKDB tests are still needed.
Point-in-Time Restore: Getting Back Rows Deleted by Accident
Plan a point-in-time restore after an accidental DELETE, preserve the log chain, recover a separate copy, and return reviewed rows.
Column Aliases: Where You Can Use Them and Where You Cannot
Why does WHERE say the alias does not exist? Here is the order SQL Server follows, two clean fixes and one quiet trap to avoid.
MySQL – Introduction to CONCAT and CONCAT_WS functions
MySQL has two concatenation functions, CONCAT and CONCAT_WS. I show how each one works and why CONCAT_WS makes adding a separator easier.
SQL SERVER – What are Actions in SSAS and How to Make a Reporting Action
SSAS actions let users open a report, a web page or drill through from cube data. Here is what actions are and how to build a Reporting Action step by step.
SQL SERVER – Planned and Unplanned Availability Group Failovers – Notes from the Field #031
In Notes from the Field #031, John Sterrett explains Planned and Unplanned Availability Group failovers in AlwaysOn, a topic that confuses many DBAs.
Explain a SQL Server Index in Sixty Seconds, Then Prove It
How to explain a SQL Server index in an interview in about a minute, then prove every word with one table. On SQL Server 2025, the same query read 5,737 pages with no index, 133 with a plain index and 3 with a covering index. Three extra indexes doubled the log of 20,000 inserts.