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
Several SQL Server instances on one server
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:
29 minute read
Updating SQL Server: CUs, GDRs and servicing branches
The SQL Server servicing model since 2017: choosing between the CU branch and the GDR branch, reading a build number, finding the right update and applying it.
Categories:
12 minute read
SQL Server transaction log backups: why and how
Why a database in the FULL recovery model needs log backups, what VM backups do not replace, and how to restore to a precise point in time.
Categories:
11 minute read
SARGability of WHERE clauses
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