Links for the Week of 2009.04.24

SQL SERVER

Filtered Indexes: What You Need To Know Michelle Ufford dives into the wonders of filtered indexes and explains what they are, why you need them, and how you can go about using them. Makes me wish we were on SQL Server 2008 at work. Use SQL 2008 Express as a Central Management Server Wish you had a central management server in the office to help you manage your mountain of SQL 2005 machines? This functionality is even available if you’re using an express edition. Check out the link for more info.

DEVELOPMENT

Code Sample Taxonomy What is sample code? What is reference code? What’s the difference? Phil Haack goes into the details and examines why the .NET community is up in arms about an ASP.NET MVC sample app. Ditching the Micro Optimization Fetish Premature optimization is the bane of developers and, more appropriately, project managers everywhere. Don’t do it. Just don’t.

STUFF & THINGS

Linked Live IDs I have multiple Live IDs. I hate logging out and logging back in. Now I don’t have to. Seven Productive Things To Do When You’re Bored At Work Do you get bored at work? Of course you do. Rather than clicking refresh over and over and over again on Digg you could spend your time doing something productive! Embrace the Mundane, Appreciate the Simple Mike Walsh makes some excellent points about dealing with simple, mundane tasks. It all boils down to enjoying what you do. Take the time to appreciate it. Seriously, the next time you have to do something that makes you want to drag your feet, approach it with an open mind and embrace it. Periodic Table of Typefaces ’nuff said.