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

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

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 Book of Redgate–Being Reasonable

As a part of the Book of Redgate, we have a series of (red, of course) pages with the title “What we believe”. These are our values, as set...

Azure Data Factory Pipeline Debugging Fails with BadRequest

I recently had a new pipeline fail. It was actually a copy of an old pipeline where I had made some adjustments into as part of a database migration....

Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric

Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data platform. This platform integrates various data sources into a single, cohesive system. This integration breaks...

Understanding Lakehouse Permissions in Microsoft Fabric

Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access to Lakehouses, SQL Endpoints, or Semantic Models.

The Cost of Not Having a DBA

Does skipping a DBA save money? Wait until your system grinds to a halt, your backups fail, or your cloud bill skyrockets. The “DBA? We Don’t Need No Stinkin’...

Who are you? Building an identity map.

I admit that until I read the article, Who are you as a Leader?, I had never heard of an identity map. It's a pretty simply thing: mapping all...

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