Monthly Archives: September 2006

Interesting Microsoft SQL Server 2005 Resources

Posted on September 14, 2006 by Glenn Berry

Microsoft TechNet has a nice Script Repository for SQL Server 2005 with a collection of useful DMV scripts and queries, separated by function. Microsoft also released the Microsoft Office 2007 System Beta 2 Technical Refresh today, which is a patch on … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Deadlock Troubleshooting, Part 2

Posted on September 13, 2006 by Glenn Berry

Bart Duncan continues his series on deadlock troubleshooting, with scripts that allow you to reproduce a deadlock, along with instuctions on how to use trace flag 1222 and the Database Tuning Advisor to troubleshoot and resolve the deadlock situation. This … Continue reading →

Posted in SQL Server 2005 | 7 Comments

More detail about Windows ReadyBoost and USB 2.0 flash drives

Posted on September 13, 2006 by Glenn Berry

Windows ReadyBoost acts as a disk cache for small, random IO from the hard drive(s). The cache file is both compressed and encrypted on the USB flash drive, and it is completely backed up by the hard-drive, so yanking out the flash … Continue reading →

Posted in Windows Vista | Leave a comment

NewsGator and NBBC

Posted on September 12, 2006 by Glenn Berry

TechCrunch mentioned our partnership on the new NBBC service with NBC today. Since I am a Battlestar Galactica fan, I enjoyed the podcast linked here. I cannot wait for season three of BSG to start on Oct. 6.

Posted in NewsGator | Leave a comment

Deadlock Troubleshooting and Longhorn Server CTP

Posted on September 9, 2006 by Glenn Berry

Bart Duncan has a great blog entry on Deadlock Troubleshooting that I am sure will come in very handy at some point in the future. It explains the root causes of deadlock problems and goes through some useful steps on how … Continue reading →

Posted in SQL Server 2005 | 11 Comments

SQL Server 2005 Failover Clustering vs. Database Mirroring

Posted on September 8, 2006 by Glenn Berry

Microsoft has an excellent new white paper on SQL Server 2005 Failover Clustering. Failover clustering is a tried and true technology that uses shared storage (usually a SAN) between two or more SQL Server nodes (on different physical servers).  Two … Continue reading →

Posted in SQL Server 2005 | 2 Comments

SQL Server Best Practices Analyzer Tool

Posted on September 7, 2006 by Glenn Berry

Microsoft had a TechNet Webcast this morning about the SQL Server 2005 Upgrade Advisor and the new SQL Server 2005 version of the SQL Server Best Practices Analyzer Tool. The 1.0 version of the BPA (for SQL Server 2000) came … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Speaking at the SoCol Code Camp

Posted on September 5, 2006 by Glenn Berry

I’ll be giving a presentation and demonstration entitled "Advanced SQL Server 2005 Performance Tuning" at the Southern Colorado (SoCol) Code Camp in Colorado Springs on Saturday, October 7, 2006. These are free events, that are meant to be free of marketing … Continue reading →

Posted in SQL Server 2005 | 4 Comments

Recent Intel Mobile CPU’s Decoded

Posted on September 4, 2006 by Glenn Berry

I’ve come to the conclusion that its about time to retire the relatively ancient Dell Inspiron 8200 that I use for teaching. I bought it from the Dell Outlet back in mid-2003 for the princely sum of $1700. It had … Continue reading →

Posted in Windows Vista | Leave a comment

Windows Vista Build 5600 RC1 Available

Posted on September 1, 2006 by Glenn Berry

Argh! Just a few days after I installed Vista 5536 on a few test systems, Microsoft releases Vista 5600 on Microsoft Connect. Build 5600 has both 32-bit and 64-bit versions available (5536 was only released as 32-bit), so I am … Continue reading →

Posted in Windows Vista | Leave a comment