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.

Memory Grant Feedback Persistence in SQL Server 2022

By using input from real memory consumption during query execution, Memory Grant input Persistence in SQL Server 2022 is a potent feature that helps optimize query performance. In order to improve the accuracy of memory grant calculations for subsequent executions of the same or comparable queries, SQL Server gathers and stores this information.

On Being an "Expert"

I had the opportunity last week to present a session at DataSaturdays Stockholm. I can't say enough nice things about the event and the organizers. I presented on Query Store in SQL Server. In my mind, it's an entry-level to middle tier presentation. Most of the room was already working with Query Store, some quite […]