PASS Data Community Summit will return to Seattle next year! Save the date for this incredible in-person event for global data professionals, which will take place at Summit, Seattle Convention Center, from November 17-21, 2025!
2024-12-18
I was asked recently why Halloween Protection was needed for data modification statements that include a self-join of the target table. This gives me a chance to explain, while also covering some interesting product bug history from the SQL Server 7 and 2000 days.
2024-12-18
Keeping track of all the security related logs can be hard. Using your security team to shoulder some of the load can help. Learn how in this article.
2024-12-16
3,671 reads
In this article, we look at how to use Apache Kafka and Zookeeper to process and load streaming data.
2024-12-16
Earlier this year I had a PM at Microsoft reach out and ask me what I thought about the Data API Builder. I hadn't looked at it, so I made a note to check it out. I hadn't done that by the time SQL Saturday Denver 2024 occurred, where I saw Jerry Nixon from Microsoft […]
2024-12-13
6,629 reads
In this article, I will discuss hiring and motivating technical polyglots. A polyglot is a person who speaks multiple languages
2024-12-13
Announced during Redgate's Keynote at PASS Summit in Seattle, PASS Summit On Tour will see smaller scale events hosted in New York, Dallas and the Netherlands in 2025. To be the first to know when tickets and dates are released, sign up to our mailing list.
2024-12-13
In the next installment of this series, learn how you can read data from the Google Cloud Platform (GCP) and virtualize it into your Azure Data Lake Storage.
2024-12-11
2,626 reads
This article explains how to aggregate data for Power BI reports and provides examples of running totals, running averages, min, max, and more.
2024-12-11
Every SQL Server developer has heard it: "Don't use NOLOCK in production!" But this common rule isn't as simple as it seems. Sometimes, what seems like a bad practice can actually be the right choice. Let's explain what NOLOCK really does in simple terms. When you use NOLOCK, you're telling SQL Server "just show me […]
2024-12-09
4,978 reads
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Apologies if this is posted in the wrong forum, but I am trying to...
Hello all, I have a linked server created on an instance which only has...
Hi, I want to find all the tables name under a database where tables...
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers