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

Building Resilience: Leadership Insights from Sports

In the bustling world of sports, leadership appears as a beacon of hope and direction. Imagine a football team, standing on the brink of a crucial match. The players,...

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

Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger

There is a SET command in SQL Server that changes how much data is returned from some fields. This short post shows what I learned about the SET TEXTSIZE...

T-SQL Tuesday #185: Video

This month’s invite is from Erik Darling, who invites you to make a video on any topic of your choice. I liked his reasoning for this and appreciate his...

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