November 2007 - Posts

• Virtual PC - Making Life Easier

  When I became an MCT (Microsoft Certified Trainer) I started using Virtual PC's as part of the classroom demonstrations and labs. Until then I'd used them on occasion, but they never struck me as very useful. In preparing for the classes and presenting Read More... Posted Wednesday, November 28, 2007 2:45 PM by AllenMWhite | 2 Comments

• Very Large Database Maintenance

  I've got a third-party app that uses a SQL Server 2005 database. The database has grown to 190GB, with 150GB of that in one table (116M rows). I've been trying to get the greenlight to partition this table since June, and finally got it this weekend. Read More... Posted Monday, November 26, 2007 3:14 PM by AllenMWhite | 12 Comments Filed under: Database Administration

• SQL Server 2008 - Is It Time Yet?

  At the PASS Conference in Denver the question was frequently asked - is it time yet for another release of SQL Server? Microsoft execs have said repeatedly at TechEd and at PASS that they've "heard us loud and clear" that 5 years is too long between releases. Read More... Posted Thursday, November 8, 2007 11:37 AM by AllenMWhite | 4 Comments Filed under: SQL Server 2008