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
16 reads
Blog Posts
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
132 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)
146 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
150 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)
499 reads
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
31 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)
528 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)
361 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
55 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
10 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...