Query to Email….Well Formatted Email

When I get alerts from SQL Server I want it to do three things for me. Tell me what’s wrong, show me the data, then tell me how to...

Call a Fabric REST API from Azure Data Factory

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure Data Factory (or Synapse Pipelines). This can be done using a Web Activity, and most...

CHOOSE’ing a Beer: #SQLNewBlogger

We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use...

Why Your SQL Server Backups Aren’t Enough

SQL Server backups are database insurance – you don’t really appreciate them until disaster strikes. But here’s the kicker: having backups doesn’t mean your data is safe. If you’re...

T-SQL Tuesday #185–Being a Video Star

This month we have an interesting invite. Erik Darling is the host, and since he does a lot of video blogs, he’s asking for a video submission for T-SQL...

T-SQL Tuesday 185 - Produce a Video!

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Erik Darling
(blog) asks us to produce a video

You can talk about whatever...

Don’t Treat Your Data Catalog Like a Data Museum

Introduction Treating your data catalog like a “data museum”—a static collection where information quietly gathers dust—is a mistake many organizations still make. While a catalog should list what data...

Secret management using Pulumi ESC SDK and Azure Key Vault

This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What I BuiltI built an automated infrastructure provisioning solution using Pulumi and Azure. The project leverages Pulumi’s...

The trade-offs associated with low-code solutions

Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own code. But it’s important to remember that it’s a...

Can You Tell Why a Plan Didn’t Go Parallel?

Let’s face it, most of the time, you probably don’t want your SQL Server execution plans to go parallel. After all, that’s why, instead of adjusting the Cost Threshold...