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
156 reads
Blog Posts
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)
752 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
Simple Talks Episode 9–Data masking and subsetting
The episode on data masking and subetting is out. You can see it here: Youtube Spotify Watch and check this out. This is especially close to my heart as...
2024-11-12
35 reads
It is Work to Live not Live to Work
In the United States, we have our Thanksgiving this month. This is a time where families come together for a huge meal. For many, it is a time to...
2024-11-11
3 reads
Mastering the ORDER BY Clause in SQL Window Functions
This article provides a comprehensive overview of the ORDER BY clause within SQL window functions. We'll explore how it interacts with PARTITION BY and the standard ORDER BY clause,...
2024-11-11 (first published: 2024-10-24)
590 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)
440 reads
Social Anxiety and Events Like the PASS Summit
If you are an introvert like me, events like the PASS Summit can call forth your social anxiety. I know this past week, I definitely felt it, even though...
2024-11-11
57 reads
A New Word: Skidding
skidding – v. intr. the practice of making offhand comments that sound sarcastic but are actually sincere and deeply felt. I used to make lots of sarcastic comments. Some...
2024-11-08
12 reads
PASS Summit – Thursday
Let’s start with the keynote. The biggest take away was how having to support multiple data platforms is growing and becoming the norm. This has been my experience and...
2024-11-08
16 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers