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...

Microsoft MVP 2025: Continuing the Data Platform Journey

I am honored to announce that I have been renewed as a Microsoft MVP for the ninth consecutive year, recognized in the Azure SQL and SQL Server technical areas...

Microsoft MVP 2025: Continuing the Data Platform Journey

I am honored to announce that I have been renewed as a Microsoft MVP for the ninth consecutive year, recognized in the Azure SQL and SQL Server technical areas...

Time to Revive our YouTube Channel

It’s been forgotten about and neglected for few years but I’ve decided to dust off the cobwebs and revive our YouTube channel. Keep an eye on it, every new...

What is KTLO? Keep The Lights On vs Project Work in Agile

🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT and Agile In the realm of IT operations and software development, not all tasks are...

Bad Request Error when Running PowerShell Command in Azure Devops

I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet in question was New-AzRoleAssignment, but the cmdlet itself isn’t important. What is important is that...

Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed

As data becomes the backbone of modern business, understanding how to manage and analyze it in the cloud is a must-have skill. The DP-900: Microsoft Azure Data Fundamentals certification...

SQL Server Auto-settings: The Good, the Bad, and the Ugly

Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL Server database and just left the default settings alone, you’re not alone. Microsoft provides a...

SQL Server Editions: What’s the Difference and Why It Matters

Understanding the Limits Before You Hit Them If you’re responsible for a SQL Server instance but don’t live and breathe licensing, you’re not alone. Many IT managers and sysadmins...