Identify blocking problems
How to recognise a blocking problem, set up the collection of blocked process reports, and send the files for analysis.
Category: SQL Server
A complete guide to SHRINK in SQL Server
How to reduce the size of a SQL Server database file properly: good practice, sizing, an incremental strategy, and automation with dbatools.
Categories:
8 minute read
Why you should NOT multiply SQL Server instances
Consolidating SQL Server instances is better than installing several of them on the same server.
Categories:
Installing and configuring SQL Server 2025 on Windows Server
A complete step-by-step guide: installing SQL Server 2025 on Windows Server, then configuring the server properties and the Configuration Manager.
Categories:
19 minute read
SQL Server transaction log backups: why and how
In the FULL recovery model, transaction log backups are indispensable. They limit data loss, allow point-in-time restores, and stop the log from filling the disk.
Categories:
11 minute read
Do not break your indexes — SARGability and WHERE clause anti-patterns
Why functions in your WHERE clauses stop SQL Server from using your indexes, and how to rewrite your queries to get performance back.
Categories:
7 minute read