SQL101: Application data consistency checking
It’s quite common for a company that experiences a corruption-causing disaster, but has no valid backups to restore […]
SQL101
SQL101: Phishing attacks
I thought it was bad previously, but in 2026 I’ve noticed a big rise in emails trying to […]
SQL101: Top Ten SQL Server Performance Tuning Best Practices
There are a huge number of best practices around SQL Server performance tuning – I could easily write […]
SQL101: Indexing Strategies for SQL Server Performance
One of the easiest ways to increase query performance in SQL Server is to make sure that it […]
SQL101: Introduction to SQL Server Transactions
(The original version of this post first appeared on the now-deleted SentryOne blog at the start of 2022.) […]