Monthly Archives: February 2009

SQL Server 2005\2008 Benchmark Results

Posted on February 27, 2009 by Glenn Berry

Joe Chang has a good post up on SQLBlog.com 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

Posted on February 27, 2009 by Glenn Berry

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

Posted on February 25, 2009 by Glenn Berry

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

Posted on February 24, 2009 by Glenn Berry

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

Posted on February 24, 2009 by Glenn Berry

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

Posted on February 21, 2009 by Glenn Berry

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!

Posted on February 20, 2009 by Glenn Berry

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

Posted on February 17, 2009 by Glenn Berry

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

Posted on February 17, 2009 by Glenn Berry

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

Posted on February 16, 2009 by Glenn Berry

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