3 things you must do to start data quality management right

As a data & AI strategist who’s seen countless projects succeed and fail, I have learned that data quality management really comes down to building the right foundation from...

Local LLM Models at SQL Saturday Boston 2025

I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking, two sessions I think. At least one. I’m excited for this session as I’ve had...

Set Theory vs. Batch Mode in SQL Server

Set Theory vs. Batch Mode in SQL Server

Not long ago, a colleague of mine was completely shocked when he first heard about SQL Server’s Batch Mode feature. His immediate...

Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation

Artificial intelligence is no longer a distant concept. It is here, embedded in the way we work, create, and make decisions. From generative assistants to predictive analytics, AI is...

Automating SQL Maintenance: How DevOps Principles Reduce Downtime

In the world of modern data infrastructure, SQL databases remain the backbone of enterprise applications. They power everything from e-commerce platforms to financial systems, and their reliability is non-negotiable....

Azure Networking: Designing for Change

Failing to plan is planning to fail. When organizations first begin implementing Azure networking, the focus is often on the immediate requirements: connectivity, security, and performance for your databases...

From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly efficient, OLTP systems were the workhorses of enterprise data. They handled the daily grind: purchases,...

Installing Old Versions of PowerShell Modules with Their Dependencies

I don’t recall where this came up (probably in SQLSlack), but I had a need to install an older version of dbatools to test something related to loading the...

Modify Power BI page visibility and active status with Semantic Link Labs

Setting page visibility and the active page are often overlooked last steps when publishing a Power BI report. It’s easy to forget the active page since it’s just set...

Monday Monitor Tips: The Jobs Report

A customer wanted a report they could email to their boss about jobs, something that showed failures. This isn’t hard to get in Redgate Monitor, though it is manual...