Being a Technical Mentor for a Career, not a Role
I talk about my foray into mentoring, and how you should mentor for a career, not just for a role.
Monthly Archive: November 2022
SQL Server at Scale – Using an Archive Table, Part 3
In part 3, I show how to automate creating new tables, dropping old tables, and adjusting the view.
SQL Server at Scale – Using an Archive Table, Part 2
In part 2, I look at general strategies for partitioning an archive table (even without Enterprise!) to reduce long-term data movement.
T-SQL Tuesday #156 : Production Code
For T-SQL Tuesday #156, I talk about the qualities I expect in T-SQL code before I consider it "production quality."
Bad Habits and Best Practices
Over a decade of posts and videos involving bad habits and best practices in SQL Server.
SQL Server at Scale – Using an Archive Table, Part 1
In this series, I look at strategies for archiving data and how it can impact your entire infrastructure.