As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and flying to Seattle for the PASS Data Community Summit 2024. I’m very lucky that I...

2024-11-04

17 reads

Implement a RAG Solution Using Azure SQL Database

by John

John Morehouse | Sqlrus.com

AI and ChatGPT are all the rage these days. Seems like around every corner is another break-through in how we interact with data, regardless of if that data is...

2025-01-20 (first published: 2024-11-01)

875 reads

2024 PASS Data Community Summit Prep

by Steve Jones

The Voice of the DBA

Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling Monday to the event to see a few thousand fellow data professionals, developers, managers, and...

2024-11-01

37 reads

A New Word: Bye-over

by Steve Jones

The Voice of the DBA

bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional farewell but then unexpectedly have a little extra time together, wordlessly agreeing to pretend that...

2024-11-01

109 reads

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

by Koen Verbeeck

Koen Verbeeck

I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC. The topic is about window functions, something that really interests me and that should...

2024-11-15 (first published: 2024-10-31)

378 reads

Counting Groups with Window Functions: #SQLNewBlogger

by Steve Jones

The Voice of the DBA

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...

2024-11-15 (first published: 2024-10-30)

481 reads

The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.

by davidfowler-42596

SQL Undercover

Recently I received a cry for help over Teams. The issue was that an application was throwing up the following SQL error, The query processor ran out of internal...

2024-11-13 (first published: 2024-10-30)

1,669 reads

Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)

by davebem

Clustering for Mere Mortals

I was the principal author of this SIOS whitepaper, which describes how to build a 2-node SQL Server cluster in Google Cloud Platform (GCP) spanning multiple zones. Today, I’ll...

2024-11-13 (first published: 2024-10-29)

191 reads