I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this blog post. To provide a list of some posts that still have value that came out in previous years.
The posts for this past week in previous years are:
- Need To Escape Escape (26 Sep, 2006)
- Visual Studio 2005 Service Pack 1 Beta (26 Sep, 2006)
- SQL Server 2008 Cumulative Update 1 (26 Sep, 2008)
- Index Black Ops Part 4 – Index Overhead and Maintenance (26 Sep, 2010)
- To Be There Or Not To Be There (28 Sep, 2010)
- The SQL Server Experience (29 Sep, 2008)
- User Group Networking Bingo (29 Sep, 2009)
- SQL Server 2008 Service Pack 2 Released (30 Sep, 2010)
- SQL Server 2008 Books Online Update (1 Oct, 2008)
- Index Black Ops Part 5 – Page Splits (1 Oct, 2010)
- Create Empty Raw File (1 Oct, 2010)
- Restoring a Database with Symmetric Encryption (2 Oct, 2007)
- Don’t miss out! Oct 21 – IT Care – Painting by Numbers, Update Your SQL Skills with New Paintbrushes (2 Oct, 2009)
- Index Black Ops Part 6 – Fill Factor vs. Page Splits (2 Oct, 2010)
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.