I talk about my foray into mentoring, and how you should mentor for a career, not just for a role.

In part 3, I show how to automate creating new tables, dropping old tables, and adjusting the view.

In part 2, I look at general strategies for partitioning an archive table (even without Enterprise!) to reduce long-term data movement.

For T-SQL Tuesday #156, I talk about the qualities I expect in T-SQL code before I consider it "production quality."

In this series, I look at strategies for archiving data and how it can impact your entire infrastructure.