The PASS Summit on Tour in the Netherlands

The PASS Summit goes on tour this year, with the final date the first few days of October  in the Netherlands, Utrect to be exact. This is the first...

Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.

I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance ... Continue reading

Generative AI vs Predictive AI | Real-World Examples & Tools You Should Know

What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming how we live, work, and interact with technology. From personalized recommendations to AI-generated art, the...

IPv4 vs IPv6 Explained: Why IPv6 Still Hasn’t Replaced IPv4

The internet relies on IP (Internet Protocol) addresses to identify devices and route traffic. Two versions of IP exist today: IPv4 and IPv6. While IPv6 was introduced to overcome...

Monday Monitor Tips: Searching Permission Changes

During a demo of Redgate Monitor Enterprise to a customer, they asked about how to search for permission changes. This post examines how you can do that in Redgate...

Redefining Tech Leadership in the Age of Microsoft AI

AI is no longer a niche capability – it is a leadership catalyst. As Microsoft continues to push boundaries with tools like Azure and Fabric, the demands on today’s...

Sample Data with GenAI in Seconds

A friend was asking for help with some data analysis. This was in PowerBI, and the source data was PII. I asked them to mask the data for me...

TSQL Tuesday #188 Growing community

I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call is about various ways to grow young data community/speakers. I’m going to take a brief...

Communicate to the Individual

I may think I'm trying to reach the crowd, but I'm really trying to reach each person within the crowd. The "crowd" doesn't actually exist.

Measuring and Improving SQL Server Query Plan Cache Efficiency

Measuring and Improving SQL Server Query Plan Cache Efficiency

The query plan cache hit ratio in SQL Server indicates the percentage of queries that are executed...