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.

Monday Monitor Tips: Tracking The Cost of Instances

One of the things that I’ve been asked in every operations situation is what licenses do we need for our servers. This is a rare request, often once a...

Renaming a Database

A New Word: Mornden

mornden – n. the self-container pajama universe shared by two people on a long weekend morning, withdrawing from the world and letting the hours slow to a crawl, coming...

New SQL Server 2022 Functions

There were a number of T-SQL functions added in SQL Server 2022. Today Steve asks if you are using any of these in your work.

Running Steve's Code

A Strange Result

Boring or Scripting

There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.