Recover a Database from Suspect Mode Step by Step

Learn how you can recover a database that is in suspect mode.

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