Monthly Archives: November 2009

Using Dedicated NICs to Segregate SQL Server 2008 Backup Traffic

Posted on November 14, 2009 by Glenn Berry

If you need to initialize a mirrored database for SQL Server 2008 Database Mirroring, one of the first things you have to do is take a full backup of the database that you want to mirror. You can either back … Continue reading →

Posted in SQL Server 2008 | 82 Comments

SQL Server 2008 Database Mirroring in Action

Posted on November 12, 2009 by Glenn Berry

I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800 and four Dell PowerEdge 1950 servers that were running a number of busy, large SQL Server 2008 databases. We had … Continue reading →

Posted in SQL Server 2008 | 33 Comments

Windows Virtual PC and Windows XP Mode on Windows 7

Posted on November 11, 2009 by Glenn Berry

One feature of Windows 7 that you may not have heard of is Windows XP Mode on Windows Virtual PC. These allow you to use hardware assisted virtualization (if your processor supports it, and you have it enabled in your … Continue reading →

Posted in Microsoft | 43 Comments

New HP Envy 15 Laptop

Posted on November 11, 2009 by Glenn Berry

After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This system has a 1.6GHz Core i7 Q720, 6GB of RAM, a 7200rpm 500GB drive and an ATI HD Radeon 4830 … Continue reading →

Posted in Computer Hardware | 2 Comments

SQL Server 2005 Diagnostic Information Queries

Posted on November 9, 2009 by Glenn Berry

Here is an updated version of my diagnostic information queries for SQL Server 2005. You can get the SQL Server 2008 version here. Most of the DMV queries require VIEW SERVER STATE permission. — SQL Server 2005 Diagnostic Information Queries … Continue reading →

Posted in SQL Server 2005 | 6 Comments

Temporary Post Used For Theme Detection (3d1489bf-65cc-47a0-b394-b28676998db9 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Posted on November 8, 2009 by Glenn Berry

This is a temporary post that was not deleted. Please delete this manually. (e29f86d1-0b33-4a68-adcd-77248245d9b5 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Posted in Uncategorized | 8 Comments

SQL Server Wait Type Repository

Posted on November 8, 2009 by Glenn Berry

Microsoft’s Bob Ward has a good post up on the CSS SQL Server Engineers blog about an upcoming web page that will completely document all of the wait types from the sys.dm_os_wait_stats DMV. There will be more detailed and practical … Continue reading →

Posted in SQL Server 2008 | 1 Comment

Worldwide Operating System Market Share for October 2009

Posted on November 7, 2009 by Glenn Berry

Ars Technica has a good post up showing that Windows 7, (which has been out for two weeks) has already passed Snow Leopard and Linux in market share.  Windows 7 is really a nice operating system that you quickly grow … Continue reading →

Posted in Microsoft | 34 Comments

SQL Server 2008 R2 Running on “Big Iron”

Posted on November 5, 2009 by Glenn Berry

During the opening keynote on Tuesday at the PASS Summit in Seattle, Microsoft’s Bob Muglia showed a demonstration of a pre-release build of SQL Server 2008 R2 Datacenter Edition on Windows Server 2008 R2. The demo started out with 64 … Continue reading →

Posted in SQL Server 2008 | 7 Comments

New Pricing and Editions For SQL Server 2008 R2

Posted on November 4, 2009 by Glenn Berry

Mary-Jo Foley recently posted about some announcements about SQL Server 2008 R2 out of the PASS Summit. There will be two new, high-end SKUs of SQL Server 2008 R2, and the prices of Standard and Enterprise Edition are going to … Continue reading →

Posted in SQL Server 2008 | 2 Comments