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
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
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)
184 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,125 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
3 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
43 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
12 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)
629 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)
445 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers