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)
210 reads
I am able to head back to Seattle for the PASS Summit this year. I would love to meet up with friends and colleagues. I shouldn’t be too hard...
2024-10-29
23 reads
I still have a tendency to talk about all the cons of a proposed solution I don’t believe is the optimal one. There’s an old saying that “no one...
2024-11-08 (first published: 2024-10-29)
175 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)
464 reads
I'm excited to tell you about the "SQL from A to Z" learning track. This comprehensive program will take you from SQL newbie to pro in no time. It's...
2024-10-28
48 reads
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
2024-11-06 (first published: 2024-10-27)
437 reads
feresy – n. the fear that your partner is changing in ways you don’t understand, even though they might be changes for the better, because it forces you to...
2024-10-25
36 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)
668 reads
Want to build a data analytics foundation that transforms raw data into valuable business insights? Look no further than SQL! It's the perfect tool for creating powerful data pipelines...
2024-11-04 (first published: 2024-10-21)
733 reads
Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some...
2024-11-08 (first published: 2024-10-21)
191 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers