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...
2024-11-15
17 reads
Blog Posts
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)
465 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)
372 reads
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for Microsoft Fabric (which includes Power BI). A what? Let me explain. When you have a...
2024-11-15 (first published: 2024-11-14)
244 reads
Building Effective Data Governance Framework: Top Areas to Focus On
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first on Joyful Craftsmen.
2024-11-14
26 reads
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major milestone for ARM-powered devices. This new release opens the door for users to install Windows...
2024-11-14
144 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)
185 reads
Master the Foundational Basics
It tells us to take the time to master the foundational basics of whatever technology we're working with. If we have mastered the basics in the past, it behooves...
2024-11-13
169 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,211 reads
Posting to Bluesky via PowerShell on macOS
The week of PASS Data Community Summit 2024 (November 4-8), Bluesky seemed to reach critical mass with the data community as well as the tech community writ large. Over...
2024-11-12
4 reads
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers