We Stink!

You know I have to say something about Crowdstrike. How could I not? Recovery for most people seems to be well in hand, but there are still places dealing with it. I was personally impacted because I was trying to fly home last Friday. While my airline and the airports I was flying through were […]

Internal Checkpoints

Thinking About Technology

Steve is thinking about technology today, inspired by a developer/architect that asks some philosophical and moral questions of software.

Add Indexes to Improve SQL DELETE Performance

This article examines whether creating indexes can help when deleting data from a SQL Server table.

Which is a table?

Shout Your Successes

I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]

How I Used PostgreSQL RLS To Avoid Code Changes During a Migration

This article discusses how one person implemented Row Level Security in PostgreSQL to help with a data migration from a single tenant to a multi-tenant database structure.

Unzipping Word Documents in T-SQL

Learn how you can use T-SQL to uncompress Word files.

Fine-grained Access Control for Stored Procedures

Fine-grained access control for stored procedures using a programmable database proxy

Power BI Treemap Chart Step-by-Step Tutorial

Microsoft Power BI Desktop provides a wide variety of visuals to its users. Sometimes, one wants to conduct a comparative analysis, a simple way to explore the relationship between the data categories within a set hierarchy. Hence, when a decision revolves around understanding the relationship of each element, this visual can provide an insightful analysis. This article will highlight all the steps to create a treemap chart in Power BI Desktop.