2024 PASS Data Community Summit Prep
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
44 reads
A New Word: Bye-over
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
117 reads
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
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)
388 reads
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...
2024-11-15 (first published: 2024-10-30)
497 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.
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,958 reads
Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)
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)
227 reads
Heading to 2024 PASS Summit
I am able to head back to Seattle for the PASS Summit this year. I would love to meet up with friends and colleagues. I shouldn’t be too hard...
2024-10-29
26 reads
Tell me the positives of your solution
I still have a tendency to talk about all the cons of a proposed solution I don’t believe is the optimal one. There’s an old saying that “no one...
2024-11-08 (first published: 2024-10-29)
181 reads
Monday Monitor Tips: Projecting Disk Space
One of the things that many DBAs struggle with is managing space across an estate. There might be one or two servers that you watch closely, or that are...
2024-11-11 (first published: 2024-10-28)
471 reads
SQL from A to Z: Your Path to SQL Mastery this Fall
I'm excited to tell you about the "SQL from A to Z" learning track. This comprehensive program will take you from SQL newbie to pro in no time. It's...
2024-10-28
55 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat Telp BCA KCP Purwosari +62 838-4945-0961
Wa:083849450961 Solo Center Point, Ruko No. A11 & A12, Sondakan, Kec. Laweyan, Kota Surakarta,...
Telp BCA KCU SOLO SLAMET RIYADI +62 838-4945-0961
Wa:083849450961 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta, Jawa...
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers