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.
How to Compile Queries and Not Execute Them? – Interview Question of the Week #219
How do you compile queries and not execute them? SET NOEXEC ON validates the syntax without running the statement, as this simple SSMS example shows.







