Monthly Archives: November 2009

More News About AMD’s 2010/2011 Server Roadmap

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

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)

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 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

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

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

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

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

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

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