Monthly Archives: December 2009

How to Copy Query Results From SQL Server 2005/2008 into Excel

Posted on December 17, 2009 by Glenn Berry

I often work with DBAs who need to copy the results of a T-SQL query from SQL Server Management Studio (SSMS) into some portable format that is easy to save and comprehend. The easiest way that I have found is … Continue reading →

Posted in SQL Server 2008 | 1 Comment

Updated SQL Server 2008 Diagnostic Queries

Posted on December 16, 2009 by Glenn Berry

Here is the mid-December version of my diagnostic queries for SQL Server 2008. The idea here is to be able to easily and quickly gather quite a bit of information about your database server instance and individual databases on that … Continue reading →

Posted in Teaching | 3 Comments

More Information about Intel Desktop CPU Roadmap

Posted on December 15, 2009 by Glenn Berry

Endgadget has a post up about an upcoming 32nm Westmere family CPU called the Core i7-980X, which will have six cores (12 with hyper-threading), 12MB of shared L3 cache, clocked at 3.33GHz. It will be an “Extreme Edition” processor, which … Continue reading →

Posted in Computer Hardware | 8 Comments

Some SQL Server 2005/2008 Monitoring Stored Procedures

Posted on December 11, 2009 by Glenn Berry

Here is a collection of five stored procedures that are very useful for monitoring the overall health of a SQL Server 2005/2008 instance. These are instance level queries, not database level queries. They are very easy to periodically call from … Continue reading →

Posted in SQL Server 2008 | 6 Comments

Old DBA Trick To Confirm SQL Server Connectivity

Posted on December 9, 2009 by Glenn Berry

“What’s wrong with the database?" or “I can’t connect to SQL Server”  How many times have you heard phrases like that from your developers and QA people? Remember, DBA means “default blame acceptor”, or guilty until proven innocent. I am … Continue reading →

Posted in SQL Server 2008 | 12 Comments

Microsoft Creates Server and Cloud Division

Posted on December 8, 2009 by Glenn Berry

Microsoft announced today that they are reorganizing and combining the existing Windows Server and Solutions Group and the Windows Azure Group into a new Server & Cloud Division (SCD) that will all be in the Servers and Tools Division, led … Continue reading →

Posted in Microsoft | 8 Comments

Microsoft Certified Master: SQL Server 2008 Pre-reading List

Posted on December 7, 2009 by Glenn Berry

Via Twitter, I stumbled upon a link to this newly updated pdf from Joseph Sack and David Ikeda who are instructors for the Microsoft Certified Master: SQL Server 2008 program at Microsoft. I have previously written about the program here. … Continue reading →

Posted in SQL Server 2008 | 43 Comments

Microsoft Student Career Portal

Posted on December 7, 2009 by Glenn Berry

Microsoft Learning has put up a new Microsoft Student Career Portal that gives advice and links to resources on how students can prepare themselves for careers as Database Administrators, Server Administrators, Consumer Support Technicians, Web Developers and Windows Developers. Each … Continue reading →

Posted in Teaching | 57 Comments

Micron Real SSD C300

Posted on December 4, 2009 by Glenn Berry

Endgadget recently had a post up about the Micron Real SSD C300 family of SATA 6Gbps SSDs that will be available in 128GB and 256GB sizes early next year. Micron has several videos up on their blog that show how … Continue reading →

Posted in Computer Hardware | 7 Comments

Fun With SQL Azure

Posted on December 2, 2009 by Glenn Berry

Pinal Dave had a helpful post a few days ago about how to setup and configure SQL Azure. You will need a Windows Live ID, and an Invitation Code before you can configure SQL Azure. Once you have configured SQL … Continue reading →

Posted in Microsoft | 10 Comments