Explain database risk to managers by turning backups, patching, and capacity into clear impact, likelihood, cost, and action choices.
SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction
Temp table versus table variable, part two: a transaction rollback undoes changes to a temp table, but a table variable keeps its values.
Which Features You Lose When You Drop an Edition
Review SQL Server edition features before moving down an edition, check persisted dependencies, and test maintenance and availability behavior.
SQL SERVER – 2008 Star Join Query Optimization
Star Join Query Optimization in SQL Server 2008 Enterprise Edition uses bitmap filtering to speed up data warehouse queries that join fact tables.
SQL SERVER – Comma Separated Values (CSV) from Table Column
The script I use most often to build Comma Separated Values (CSV) from a table column with FOR XML PATH. I think XML is the best option for code and speed.
TDE, Column Encryption and Always Encrypted Compared
Compare SQL Server encryption options by the threat they address, where keys live, what applications must change, and how recovery is tested.
Validating JSON Parameters Before a Procedure Uses Them
Learn validating JSON parameters before changing data with ISJSON, JSON_PATH_EXISTS, TRY_CAST, and a single clear list of input errors.