Monthly Archives: January 2010

Teaching Two SQL Server 2008 Classes at University of Denver, University College in Spring Quarter

Posted on January 31, 2010 by Glenn Berry

I’ll be teaching two SQL Server 2008 classes this spring at University of Denver, University College. The first one, which will be on campus on Monday nights will be ICT 4415 Database Backup and Recovery. The class won’t just cover … Continue reading →

Posted in Teaching | 1 Comment

Paul Randal’s Benchmarking Series

Posted on January 29, 2010 by Glenn Berry

Fellow SQL MVP Paul Randal of SQLSkills, (who is also Kimberly Tripp’s husband, and a former long-time Microsoft employee) has been working hard on a great benchmarking series with some actual Dell server hardware that he has setup in his … Continue reading →

Posted in SQL Server 2008 | 3 Comments

Are You Running the x86 Version of SQL Server 2005/2008?

Posted on January 28, 2010 by Glenn Berry

If so why?  Honestly, I am curious why people may still be running 32-bit versions of SQL Server 2005, 2008, or 2008 R2 in a production environment.  I have been advocating that people use 64-bit versions of SQL Server 2005 … Continue reading →

Posted in SQL Server 2008 | 4 Comments

Living with TED 5000

Posted on January 24, 2010 by Glenn Berry

Since I installed my TED 5000 home energy monitor about a week ago, I have learned quite a bit about my electricity usage patterns in a pretty short time. I have been averaging between 14-17 KwH per day (which would … Continue reading →

Posted in Computer Hardware | 2 Comments

Are You on Twitter?

Posted on January 24, 2010 by Glenn Berry

Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time. After all, who cares what I am doing at any given time? Did I really care that someone was reading … Continue reading →

Posted in SQL Server 2008 | 2 Comments

Setting a Dedicated Login To Run DMV Queries in SQL Server 2005\2008

Posted on January 20, 2010 by Glenn Berry

In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are using. Many DBAs just logon with an account that has system administrator rights, so they have no problems running DMV … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Three Big Things That Got Me Here

Posted on January 19, 2010 by Glenn Berry

I was tagged by Steve Jones in the meme that Paul Randal started a few days ago, so I need to tell my story to keep it going. It is interesting,but not terribly surprising that many SQL Server DBAs are … Continue reading →

Posted in SQL Server 2008 | 3 Comments

SQL Server 2008 SP1 Cumulative Update 6 Released

Posted on January 19, 2010 by Glenn Berry

Microsoft has released Cumulative Update 6 (CU6) for SQL Server 2008 SP1, which you can request here. This is Build 2757, and it has 33 listed fixes, which mainly seem to be focused on replication, SSRS, and SSAS. They have … Continue reading →

Posted in SQL Server 2008 | 10 Comments

A Few Useful Queries for SQL Server 2008 Integrated Full Text Search (iFTS)

Posted on January 18, 2010 by Glenn Berry

I had a hardware issue this past weekend on one of my database servers where I am running SQL Server 2008 Integrated Full Text Search (iFTS). After the issue was resolved, I noticed a problem with iFTS, where changed items … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Intel Nehalem-EX and Database Performance

Posted on January 17, 2010 by Glenn Berry

Intel is talking about the upcoming launch of the next generation Intel Xeon processor (Nehalem-EX) being bigger than the Xeon 5500 (Nehalem-EP). They are claiming greater than nine times the memory bandwidth compared to the six-core Xeon 7400 Dunnington series, … Continue reading →

Posted in Computer Hardware | 1 Comment