Photo credit – Jenn and Tony Bot

Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s blog posts that came out in the past week. Maybe just one of them may make you as excited as our little stone statue friend here.

The posts for this past week in previous years are:

• 2011 SQL Server MVP Award (4 Jul, 2011)
• Lost in Translation – Deprecated System Tables – syscomments (4 Jul, 2012)
• What Would You Build? MSDN Subscription Giveaway (5 Jul, 2010)
• July Monthly SQL Server Checklist (5 Jul, 2011)
• Lost in Translation – Deprecated System Tables – sysconfigures (5 Jul, 2012)
• Try out SQL Server 2014 CTP1 on Windows Azure (5 Jul, 2013)
• 5 Reasons Why I Need To Go To SQLskills Immersion Training (6 Jul, 2012)
• Lost in Translation – Deprecated System Tables – sysconstraints (6 Jul, 2012)
• What Happened to My Fabulous Beverage! (7 Jul, 2009)
• Using SSMS to Script Out Data (7 Jul, 2009)
• Lost in Translation – Deprecated System Tables – syscurconfigs (7 Jul, 2012)
• 5 Common Mistakes with Tempdb (8 Jul, 2009)
• Lost in Translation – Deprecated System Tables – sysdatabases (8 Jul, 2012)
• Security Questions: Prioritizing Security (9 Jul, 2013)
• Security Questions: Logins Not In Use (9 Jul, 2013)
• Index Size and Usage (10 Jul, 2008)
• Book: Expert Performance Indexing for SQL Server 2012 (10 Jul, 2012)
• Security Questions: Logins, Credentials, and Proxies (10 Jul, 2013)

Do you have something from years gone by that was posted during this week?  If so, leave a comment below and we’ll give some new life to good knowledge.

Find all you need to know about indexes in one book. Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.