Where's the Printer Friendly Option?

Steve reminisces about the older technology of putting words on paper, often from the web.

Cleaning Up Your Database

How many of us clean up our databases and is it worth it? Steve has a few thoughts.

Enabling an Index: #SQLNewBlogger

I don’t do a lot of work with disabled index, but I learned how to re-enable one today, which was a surprise to me. This short post covers how...

Memory-Optimized Tables Memory

Back to Boston for SQL Saturday

I’m leaving again tomorrow for a trip. This time I head back to Boston for a Redgate DevOps in a Day on Thursday and SQL Saturday Boston 2024 on...

Back to Boston for SQL Saturday

I’m leaving again tomorrow for a trip. This time I head back to Boston for a Redgate DevOps in a Day on Thursday and SQL Saturday Boston 2024 on...

Comparing an Old Running Total to Window Functions

Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...

Comparing an Old Running Total to Window Functions

Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...

Converting Old Running Total Code to Window Functions

This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.

Effective Engineering

Platform engineering is a new area of focus for some, but it's already being seen as passé by some. Steve notes that there isn't a magic bullet for building better software. It comes about by us working together.