Black Friday prices end in 12d 08h 47m — See the sale

[Video] Office Hours on the Last Alaskan Cruise of the Season

It's a cold, gloomy day on the very last Alaskan cruise of the season. Yes, I picked this on purpose! While I talk about why this is a fun cruise to be on, let's take your top-voted questions from https://pollgab.com/room/brento.

Prefer listening to this via podcast? Good news! You can now subscribe to Office Hours on Spotify, Apple Podcasts, Podcast Index, Podcast Addict, Podchaser, and anywhere else fine podcasts are found.

Read more about [Video] Office Hours on the Last Alaskan Cruise of the Season 5 comments — Join the discussion
Production DBA

Fact-Checking Microsoft’s “PostgreSQL to SQL Field Notes: Connections”

Microsoft has started a series of blog posts helping Postgres developers who are "upgrading" to Microsoft SQL. (Microsoft's been using that generic "SQL" term to refer to its collection of database products: Azure SQL DB, Hyperscale, Managed Instances, and SQL Server.)

I let the first blog post slide, but the second post explained why Microsoft is so much better than Postgres at handling connections, and it's so egregiously misleading that I'm gonna have to step in.

Read more about Fact-Checking Microsoft’s “PostgreSQL to SQL Field Notes: Connections” 18 comments — Join the discussion

Free Webcast: How to Think Like the SQL Server & Postgres Engines

You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In my new totally free How to Think Like the Engines class, you’ll learn how the SQL Server and Postgres database engines look at your indexes and build your query results.

Read more about Free Webcast: How to Think Like the SQL Server & Postgres Engines Be the first to comment

[Video] A Very Special Episode of Office Hours

When we were kids, we knew we were in for something heavy whenever a TV series began an episode with a title card explaining, "This is a very special episode of ___." It meant they were gonna discuss something heavy, like cancer or drugs or loss.

Well, in this Very Special Episode of Office Hours, we're going to talk about what's happening to tech jobs in the wake of AI.

Read more about [Video] A Very Special Episode of Office Hours 3 comments — Join the discussion

I’m Just Gonna Leave This Here

Sometimes my value as a blogger is to make complex topics simple, or to deliver industry news to you, or to entertain you. Sometimes, it's just to keep you posted on things that are happening in the industry.

So with that in mind, at Microsoft FabCon Barcelona this week, there was a partner day for Microsoft partners. From there, Eelco Drost (shout out to the smart & fun folks at MasterMinds) shared a slide:

Read more about I’m Just Gonna Leave This Here 45 comments — Join the discussion
News & Opinion

Announcing a New Way to Reinforce Your Resume: My Alumni List.

I hope you never have to look for another job.

However, if you do, I wanna give you as much reinforcement as I can. If you're the kind of person who attends my live classes, pays attention, asks questions, and does the lab homework, you deserve to be able to brag about that. You deserve a public record of your work, something you can point to on my site that links directly to your LinkedIn, and a certificate you can put on your LinkedIn.

Read more about Announcing a New Way to Reinforce Your Resume: My Alumni List. 2 comments — Join the discussion
Performance Tuning

“But NOLOCK won’t hurt me if I’m using an index!”

Your queries won’t tune themselves. My 2027 Live Class Season Pass is $995 (normally $4,395), with live Fundamentals and Mastering classes plus recordings. Register by October 31 to join Fundamentals Week, November 2–6. See the pass.

NOLOCK is bad and you probably shouldn't use it, but every time I mention that publicly, the pushback just keeps coming. I don't know why people so firmly believe that their situation couldn't possibly be affected by bad/random data from NOLOCK.

Read more about “But NOLOCK won’t hurt me if I’m using an index!” 20 comments — Join the discussion
Performance Tuning

Database Animations: How SQL Server’s JSON Indexes Work

Your queries won’t tune themselves. My 2027 Live Class Season Pass is $995 (normally $4,395), with live Fundamentals and Mastering classes plus recordings. Register by October 31 to join Fundamentals Week, November 2–6. See the pass.

By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to store practically schema-less JSON blobs as part of each row, and have it too by querying specific values quickly.

Read more about Database Animations: How SQL Server’s JSON Indexes Work 12 comments — Join the discussion