The Funny SELECTs

Doing a Little Research

I've been very pleased with the direction of SSMS the last few years. As it's been separated from SQL Server releases and gets updated more often, I think the changes from v17 though v20 have been improvements. There are still issues, but it's been better. Now we finally have SSMS moving to a modern shell […]

A New Word: Nachlophobia

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty shallow, that although your relationships feel congenial in the moment, an audit of your life...

A Strange Query

Over-Engineering

Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.

Using SQL Compare with Read-only Access

Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some...

Have Grace

A few thoughts on dealing with others this holiday season.

The Hash Join II

A First Look at SSMS 21

This isn't really a first look, per se. I've seen Erin Stellato present on this a few times in MVP sessions and at the PASS Data Community Summit. However, this is a look on my machine, where I'm in control. The new version preview was announced recently, and this looks at the new process to […]

Computer Algebra

Doing math, even complex math, is possible in SQL Server.