Monthly Archives: February 2009

SQL Server 2005\2008 Benchmark Results

Joe Chang has a good post up on about some new SAP benchmark results that show two socket Nehalem EP systems (with 16 cores – 2 sockets, quad-core plus hyper-threading) having the same score as a four socket X7460 … Continue reading

Posted in Computer Hardware | 4 Comments

Spring 2009 Teaching Schedule For University of Denver, University College

For the Spring 2009 Quarter, I will be teaching MCIS 4423 SQL Server With Lab, MCIS 4428 Advanced Database Design, and MCIS 4440 T-SQL Programming. MCIS 4423 will be Online, while MCIS 4428 and MCIS 4440 will be on campus. … Continue reading

Posted in Teaching | Leave a comment

Study Guide For Microsoft 70-432 Exam

Buck Woody (who is a Program Manager on the SQL Server Dev Team) has a blog post up where he has gathered some resources that he is using to get ready for the Microsoft 70-432 Exam. I passed this exam … Continue reading

Posted in SQL Server 2008 | 8 Comments

Microsoft Releases CTP For SQL Server 2008 SP1

Microsoft has released a Community Technology Preview (CTP) for SQL Server 2008 SP1. This is build 2520. My understanding is that SP1 includes all of the fixes that are in CU3 for SQL Server 2008. Microsoft does more regression testing … Continue reading

Posted in SQL Server 2008 | Leave a comment

Microsoft Certification Exam Discounts

Microsoft and Prometric are running several different discount promotions for certification exams right now. Some of these are pretty short time frame, so you should take advantage of them before they expire. You can get 40% off any Microsoft Certification … Continue reading

Posted in Microsoft Training | 1 Comment

How To Avoid Orphaned Users With SQL Server Authentication

One common issue that database administrators often run into is the old, familiar “orphaned” user problem. This happens when you use SQL Server Authentication to create a server login. When you do this, SQL Server generates a SID for that … Continue reading

Posted in SQL Server 2008 | 1 Comment

Using SQL Server 2008 Database Mirroring to Become a Super Hero!

That is the title of a presentation and demo that I am scheduled to give at the Rocky Mountain Tech Trifecta, which will be held on February 21, 2009 at Metro State University in Denver. I was a very late … Continue reading

Posted in SQL Server 2008 | Leave a comment

Custom Connection Colors in SQL Server 2008 Management Studio

SQL Server 2008 Management Studio has a new, little known feature that lets you set custom colors for your saved connection properties for different SQL Server instances. This allows you to save a specific color for different types of servers; … Continue reading

Posted in SQL Server 2008 | 4 Comments

Cumulative Update 2 for SQL Server 2005 SP3 Released

Microsoft has released Cumulative Update 2 for SQL Server 2005 Service Pack 3, which you can request here. It is Build 4211. The fix list for this CU is fairly short. They have also released Cumulative Update 12 for SQL … Continue reading

Posted in SQL Server 2005 | 2 Comments

More Information About Tuning Backup Compression

Sanjay Mishra and Mike Ruthruff from Microsoft’s SQLCAT team have published Part Two of their Technical Note about how to tune SQL Server 2008 Backup Compression for maximum performance. The main two things that you can adjust are the BUFFERCOUNT … Continue reading

Posted in SQL Server 2008 | Leave a comment