To check autogrowth settings for every database file, read sys.master_files and turn its raw page counts into sizes you can judge. This post builds a demo database with three differently set files, reports the current size, the next growth step and the room left, and fixes the weak settings. It also explains why the same query can return no rows.
UTF-8 Collations in SQL Server 2019: When They Save Space
Compare UTF-8 collations with NVARCHAR storage for English, European, and Asian text before converting indexes or clients.
PAGELATCH_UP Waits and Suspended Sessions: Find the Hot Page
PAGELATCH_UP waits mean that sessions queue for the same page in memory, and that page can be named. This post reads the waiting sessions, turns the resource into a database, a file and a page, and tells an allocation page from an ordinary one. It then lists the fixes for tempdb and for a user database.
TempDB Performance: Five Settings to Check in SQL Server
TempDB performance depends on five settings that you can read in a few minutes: how big it is, how many data files it has, whether they match, how it grows and where it lives. Three read-only queries check each one. The post also explains what to do with the answers.
SQL SERVER – Error: 5173 – One or More Files do Not Match the Primary File of the Database
In this blog, we would discuss error: Error: 5173 – One or more files do not match the primary file of the database and its solution.
Docker Volume for SQL Server: Keep Your Data Across Upgrades
A Docker volume keeps SQL Server data outside the container, so you can replace the container and keep every database. This post creates a named volume, copies a backup into it and upgrades by starting a newer image on the same volume. It also covers the cautions that protect your data.
Masking Test Data With REGEXP_REPLACE in SQL Server 2025
Before a production copy reaches a developer, replace the real emails and phone numbers. Here is a small, checked way to do it with REGEXP_REPLACE.