Monthly Archives: November 2009

More News About AMD’s 2010/2011 Server Roadmap

Posted on November 29, 2009 by Glenn Berry

AnandTech IT has an interesting post up that looks at the roadmap for AMD in the server arena for 2010/2011. The gist of it is that AMD may be competitive with Intel in some parts of the market (two-socket servers), … Continue reading →

Posted in Computer Hardware | Leave a comment

Teaching SQL Server 2008 Class at University of Denver – University College

Posted on November 29, 2009 by Glenn Berry

I will be teaching ICT 4461 SQL Server with Lab starting Tuesday, January 5, 2010. This will be an on-campus class, held in the Josephine Computer Lab. The textbook is Beginning SQL Server 2008 for Developers by Robin Dewson. The … Continue reading →

Posted in Teaching | 6 Comments

SQL Server 2008 Diagnostic Information Queries (Late November 2009)

Posted on November 24, 2009 by Glenn Berry

Here is the latest version of my Diagnostic Information Queries for SQL Server 2008.  Running these queries will give you a pretty good idea about the configuration and health of your server and about any particular databases on the server. … Continue reading →

Posted in SQL Server 2008 | 3 Comments

Some Intel Westmere Benchmarks

Posted on November 23, 2009 by Glenn Berry

PCLab.pl has an interesting review and benchmarks of a 3.07GHz Westmere-EP processor (which is the six-core, 32nm successor to the Xeon 5500 series, Nehalem-EP processor).  This unit has six cores, and hyper-threading for a total of 12 cores per physical … Continue reading →

Posted in Computer Hardware | 4 Comments

Some Ways To Look For Things in SQL Server Modules

Posted on November 23, 2009 by Glenn Berry

If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it can sometimes be difficult to keep track of whether you have used certain options (such as RECOMPILE).  The queries below … Continue reading →

Posted in SQL Server 2008 | 3 Comments

PDC 2009 Laptop Giveaway

Posted on November 18, 2009 by Glenn Berry

During Steven Sinofsky’s keynote address at PDC09 today, he started telling a story about how some of the engineers in the Windows Division partnered with Acer to learn what a hardware manufacturer goes through when they design and configure a … Continue reading →

Posted in Microsoft | 39 Comments

Impressions of PDC09 Day One

Posted on November 18, 2009 by Glenn Berry

Back before I grew up and became a DBA, I used to be a developer.  This seems to be a fairly common career path for many DBAs that I have met. At any rate, I can relate to and understand … Continue reading →

Posted in Microsoft | 9 Comments

Cumulative Update 5 For SQL Server 2008 Service Pack 1

Posted on November 17, 2009 by Glenn Berry

Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 1.  You can go here to request the hotfix from Microsoft. It typically takes just a few minutes for them to send you the download link and password, … Continue reading →

Posted in SQL Server 2008 | 76 Comments

SQL Server 2008 iFTS Lessons Learned

Posted on November 17, 2009 by Glenn Berry

We have been using SQL Server 2008 Integrated Full Text Search (iFTS) in Production at NewsGator for a little over a year, with very good results. We were able to replace a 3rd party solution that required a lot of … Continue reading →

Posted in SQL Server 2008 | 11 Comments

SQL Server MVP Deep Dives Book Signing At PASS Summit

Posted on November 16, 2009 by Glenn Berry

Kimberly Tripp posted today about the SQL Server MVP Deep Dives book signing event at PASS on November 4. The PASS bookstore sold out of all of their copies of the book (150 in all), and many people who bought … Continue reading →

Posted in SQL Server 2008 | 34 Comments