Off to Live 360

I am off to Live 360 today, on my last trip of the year. I’m excited to deliver two presentations tomorrow (VSTH03 and VSTH12), but a little sad this...

PASS Data Community Summit 2024 Day 3 Keynote

It’s been an amazing week here, as well as a long week. I’m tired, as are many others. The blogging table is a little bare this am, but I...

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.