How Do You Patch 100 Database Servers?

The challenges of managing lots of system are significant and there aren't easy solutions, but Steve has a few thoughts on what you can do.

What's the Ceiling?

A New Word: Ochisia

ochisia – n. the fear that the role you once occupied in someone’s life could be refilled without a second thought, which makes you wish that every breakup would...

Counting Groups with Window Functions: #SQLNewBlogger

I looked at row_number() in a previous post. Now I want to build on that and do some counting of rows with COUNT() and the OVER clause. I’ll show...

Do You Want a Microsoft Solution?

Today Steve wonders if official solutions from a vendor are that important.

SQL Server 2022 Build List

This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]

The Density Vector

Separate Reads

Today Steve wonders how many software developers use separate connections for reads and writes in their application.

The Hash Join I

Comparing Images