Links You Should’ve Clicked Last Week – November 2, 2009

Here’s a dump of last week’s links and then it’s back to recording my new 2008 Integration Services video tutorials! I had a ton of links this week and, since this past week featured the public launch of Windows 7, many of my links are related:

Database Related

• Scalable Shared Databases in SQL Server 2005/2008
• Using the Database Tuning Advisor with MS Dynamics
• Good DMV-based queries in SQL 2005/2008
• The “magic” about trustable relationships with NULL and NOT IN
• Don’t Forget to Clean out MSDB
• How many times has that Plan Guide been used?
• Enterprise Policy Management Framework

Programming Related

• jQuery and ASP.NET (no postback) – I love you, jQuery
• Visual Studio Documentary
• Yahoo! Developer Design Patterns – not for programmer developers but for UI developers!
• What exactly is a page fault?

Sysadmin Related

• How to Build a SharePoint 2010 Development Machine
• Bottlenecks and Bank Balances – a good article on tuning

Misc

• Get Visual Studio and SQL Server on the cheap with MSFT’s new program
• Google’s CEO: What the Web Will Look Like in 5 Years
• UI Design Trends
• The droids we’re looking for

Windows 7 and Windows Server 2008 R2

• Speed tweaks for folks with SSD drives
• More SSD speed tweaks
• Windows 7 Product Guide
• Support for SSDs in Windows 7 and Windows Server 2008 R2
• 18 Cool Things Windows 7 Does that Vista Doesn’t
• Windows 7 Review from Ars Technica

LearnItFirst Related

We just uploaded our latest course, course 158: SQL Server 2008 Integration Services training videos