Throwback Thursday: November 27, 2025

In today's edition of Throwback Thursday, we revisit my B-BEAR technique (Begin, Before, Execute, After, Rollback): the only way I make live changes to SQL Server production data.

Throwback Thursday: November 27, 2025

With over a million words scattered across more than 1,500 articles on this blog, you've probably missed a few things here.

That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.


Highlights from NoLongerSet.com

5 Tips for Making Changes on Live SQL Server Databases
Making database changes on production? These 5 tips will make one of the most dangerous programming activities a little bit safer.
B-BEAR: Quick and Dirty SQL Server Testing
Begin, Before, Execute, After, Rollback. This technique makes testing your SQL Server statements a snap.
Using PRINT to Improve Safety of Live SQL Server Updates
[Me]: Let’s DELETE 5 records. [SSMS]: (7,393,253 rows affected) [Me]: {Updates LinkedIn profile: ”#OPENTOWORK”} Avoid nasty SQL surprises with this easy technique.

Developer Humor

"Whatever Microsoft Is Doing"

Cover image generated by Ideogram

All original code samples by Mike Wolfe are licensed under CC BY 4.0