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...
2025-07-15
39 reads
Blog Posts
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
2025-07-14
248 reads
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...
2025-07-14 (first published: 2025-06-23)
390 reads
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...
2025-07-14
30 reads
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...
2025-07-14 (first published: 2025-06-23)
283 reads
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...
2025-07-14
15 reads
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...
2025-07-14
30 reads
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...
2025-07-13
9 reads
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.
2025-07-11 (first published: 2025-06-24)
102 reads
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...
2025-07-11 (first published: 2025-06-24)
514 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
The New Database CheckDB
Comments posted to this topic are about the item The New Database CheckDB
MySQL’s BLACKHOLE Storage Engine: The Odd Feature I Wish SQL Server Shipped With
Comments posted to this topic are about the item MySQL’s BLACKHOLE Storage Engine: The...
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers