Day 2 at PASS Data Community Summit 2024

I missed blogging yesterday as I was on stage/backstage for quite a bit of the keynote. Live updates, so keep refreshing. Today I’m blogging and noting the interesting things...

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.

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