Deleted an offline database but the disk is still full, or you get an error creating a database with the same name? Here is why, and what to do.
Statement Terminators: Where T-SQL Requires a Semicolon
Most T-SQL statements run fine without a semicolon, but a pasted CTE, THROW or MERGE will not. Here is how to read the error and fix the line above it.
What a Junior DBA Should Learn First
Build junior DBA skills around restores, permissions, blocking, and safe investigation, with a practical learning order and useful SQL checks.
Partitioned Views: Splitting a Table Without Table Partitioning
A view over yearly tables only skips the years it does not need while the CHECK constraints are trusted. Here is how to see it, break it and fix it.
SSIS Project and Package Deployment Explained
Understand SSIS deployment models, catalog environments, parameter bindings, and the checks that keep package execution predictable after deployment.
Storing Email Addresses: Length, Case and Unique Keys
Two accounts for one customer usually means nobody wrote down the case rule. Build the table, break each rule, and see what the database can promise.
Handling the Row That Arrives Late
Handle late arriving data with explicit event dates, inferred dimension members, replay windows, and a clear policy for correcting published history.