Monthly Archives: February 2009

SQL Server 2005\2008 Benchmark Results

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

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