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.

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