I'm happy to hear the Microsoft.SqlServer.TransactSql.ScriptDom is now an open-source project. I submitted Microsoft feedback to make it open-source a few years ago and it's nice to see it was...

There are also many T-SQL language enhancements introduced in SQL Server 2022 (including Azure SQL Database) worthy of mentioning. Below are some from the SQL Server 2022 What's new...

There are no shortage of stories where someone delayed patching and then a vulnerability was exploited.

DBAs of a certain age will remember the SQL Slammer worm. The buffer overflow exploit...

Like you, Steve, I'd rather buy an off-the-shelf system than build one. I recently had to go down the build path, though, because I couldn't find a machine with my...

Maybe you shouldn't have thrown away the floppies. I sold my old Access 1.0 floppies (including box, manual, and 1.1 upgrade) for 50 USD at a garage sale a few...

Containers are your friend in facilitating a isolated database development. Our db devs can now stand up an isolated environment with the latest production schema consisting of multiple SQL instances...

I consider myself very fortunate as I can count the number of bad managers I’ve had in my long career on one finger. This isn’t to say my other managers...

We are in a profession, not a trade, so (re)learning is essential. Practices that may have been best at one time may no longer apply. This reminded me of my

I've had a home lab for decades and have found it invaluable for keeping up with the technologies I use and want to explore. This was quite expensive back when...

I was asked "want do you do for a living" a few years ago during jury selection. After seeing eyes gloss over when I responded with my "Database Solution Architect"...

My guess for the SQL Server 2019 release date is August 31, 2019.

Although not using semi-colon statement terminators has been deprecated for a decade, using statement terminators is still...

A true story I mention when teaching about proper NULL handling is the guy who received thousands of parking tickets because his personalized tag was "NO PLATE". This...

Absence of conflict is one of the key indicators of dysfunctional team, according to The Five Dysfunctions of a Team (https://en.wikipedia.org/wiki/The_Five_Dysfunctions_of_a_Team). In short, conflict is healthy when...

I always change the model recovery model to SIMPLE for development and QA instances since the recovery plan is to restore from the latest FULL and DIFFERENTIAL backup.