This book was making its rounds on social media, and the concept seems interesting enough to make me want to read it. It’s a very short book (only 106...
2024-11-13 (first published: 2024-11-12)
20 reads
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)
136 reads
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
138 reads
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)
469 reads
Many customers ask me about the advantages of moving from Azure Synapse Analytics to Microsoft Fabric. Here’s a breakdown of the standout features that make Fabric an appealing choice:...
2024-11-12 (first published: 2024-11-06)
8 reads
One of the things that I’ve been asked in every operations situation is what licenses do we need for our servers. This is a rare request, often once a...
2024-11-12 (first published: 2024-11-11)
146 reads
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
28 reads
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He points out that often times, a quest for perfection means we don't move forward. We...
2024-11-12
39 reads
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)
477 reads
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)
312 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers