Archive Every Day

There are challenges with the large scale archiving of data. Steve Jones talks about rethinking this as a daily process rather than a periodic one.

When Should We Be Cleaning Data?

Part of our job as a data professional often deals with the movement and cleaning of data. However, should we be trying to reduce the work we do? Move the burden to the application? Steve Jones has a few comments.

Disabling Indexes

Filtered Indexes 2

Architecture for Auditing

The way in which auditing is build into our systems isn't the best way to implement the practice.

What Not To Say

Steve Jones has some advice for data professionals today. These are a few things that your boss doesn't want to hear, and you probably don't want to say.

Finding Production Drift

The changes made to production can be problematic at times. Steve Jones notes we can't prevent them, but we can look for them.

Your Job

Steve Jones has a few comments on what your job is as a technologist.

Refactoring Mistakes Are Why We Write Tests

I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s...

Statistical Analysis

This week Steve Jones asks the questions about advanced data analysis and statistics you might be using in your applications.