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

Friday Flyway Tips: State-based deployment with Flyway Teams

I was asked about state-based deployments in Flyway Teams, so I decided to show how this can work with a quick demo. This post walks through the process. I’ve...

Can You See Table Valued Parameters in Extended Events?

I live for questions and this was an interesting one. Can you see Table Valued Parameters that have been passed in to Extended Events? I literally have no idea....

Marketing Analyst: The Data-Driven Superhero Your Company Needs

Want to blend your love of marketing with the power of data? Becoming a marketing analyst is the way to go. This job is all about measuring how well campaigns actually work, understanding...

Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....

Save Azure PostgreSQL Backup to Storage

This may or may not be helpful in the long term, but since I’m doing it to be super cautious, I figured I would blog about it. We migrated...