How do I know if I am DBOWNER or not in SQL Server? A DBA worried about permissions before my changes, so we ran this simple script to check db_owner membership.
The Handful of Counters That Actually Matter
Make SQL Server monitoring useful by relating waits, batch activity, memory indicators, and file latency to the same workload and observation window.
Pulling Values Out of Text With REGEXP_SUBSTR and REGEXP_INSTR
Extract codes with REGEXP_SUBSTR in SQL Server 2025, locate matches, select occurrences and capture groups, and validate text boundaries.
How to check the ANSI Compatibility of SQL Server Queries? – Interview Question of the Week #221
How do you check the ANSI compatibility of SQL Server queries? A client asked me this unique question, and the FIPS standard helps keep your code portable.
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.
Spotting Unusually Small Backups Against Each Database’s Average
Flag unusually small backups against database-specific history, use aggregate filtering, and investigate alerts without assuming data loss.
Splitting an Amount Across Rows Without Losing a Cent
Make splitting an amount preserve every cent by checking rounded shares, allocating weighted remainders, and documenting deterministic ties.