Monthly Archives: December 2008

Microsoft SQL Server 2008 Learning Portal

Microsoft Learning has a handy portal site up that has lots of information about SQL Server 2008 training and certification. There are book discounts, training discounts, free E-Learning offers, and an improved Second Shot promotion. A particularly useful resource is … Continue reading

Posted in SQL Server 2008 | 2 Comments

Winter Teaching Schedule At University College

I am teaching three courses at the University of Denver, University College this quarter. These include MCIS 4423 – Introduction to SQL Server 2008, MCIS 4425 Database Design & Programming, and MCIS 4495 Database Recovery and Backup. All of these … Continue reading

Posted in Teaching | Leave a comment

Fun With Data Compression in SQL Server 2008

One of the new features in SQL Server 2008 that you can take advantage of (if you have Enterprise Edition) is data compression. Data compression allows you to save storage space and I/O at the cost of some extra CPU … Continue reading

Posted in SQL Server 2008 | 2 Comments

NewsGator Releases Social Sites 2.5 On December 16, 2008

NewsGator Technologies (my employer) has released version 2.5 of our Social Sites product. You can read the press release or visit the website for more details. Social Sites integrates very tightly with Microsoft Office SharePoint Server 2007, and it uses … Continue reading

Posted in NewsGator | Leave a comment

Microsoft Releases Service Pack 3 For SQL Server 2005

After a fairly long development and testing period, Microsoft has released Service Pack 3 for SQL Server 2005. Initially, Microsoft was considering not developing an SP3 release, since they are trying to convert more of their products to an incremental … Continue reading

Posted in SQL Server 2005 | Leave a comment

New Vertex Series Of SSD From OCZ

OCZ has introduced a new line of SATA II MLC 2.5” SSDs in 30GB, 60GB, 120GB and 250GB capacities. The prices range from $129 to $869, depending on the size, which is still a little pricey, considering that you can … Continue reading

Posted in Computer Hardware | Leave a comment

The Gallant Hours

I watched an interesting war movie on VUDU last night called The Gallant Hours, which was basically a partial biography of Admiral William F. “Bull” Halsey, who ended up being a Fleet Admiral in World War Two. The movie was … Continue reading

Posted in Entertainment | Leave a comment

Good Content From SQLCAT Team

Microsoft’s Burzin Patel has a Top 10 List called Top 10 SQL Server 2008 Features for ISV Applications, that lists what he believes are the ten most valuable new features in SQL Server 2008 for independent software vendors (ISV). It … Continue reading

Posted in SQL Server 2008 | Leave a comment

Excellent Results With SQL Server Native 2008 Backup Compression

I upgraded one of my remaining large databases from SQL Server 2005 (on Windows Server 2003 R2) to SQL Server 2008 CU2 (on Windows Server 2008) this past Friday, with no issues. This is a production database, so I could … Continue reading

Posted in SQL Server 2008 | 3 Comments

Tuning the Performance of Change Data Capture in SQL Server 2008

Microsoft’s Steffen Krause has a very detailed whitepaper up on on how to tune Change Data Capture (CDC) on SQL Server 2008 to minimize its performance impact. I also got the opportunity to be one of the technical reviewers … Continue reading

Posted in SQL Server 2008 | Leave a comment