Using the DAC with SSMS

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...

Unexpected Windows 10

This was strange. I noticed a new icon in the taskbar today. When I hovered over it, I saw this:

I...

Insert without a PK

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.