Monthly Archives: April 2009

SQL Server 2008 x64 on Windows 7 RC

I was able to download Windows 7 RC x64 from TechNet Subscribers earlier today, and of course, I had to load it on an actual decent machine. I have a Dell Studio XPS 435, with an Intel Core i7 920, … Continue reading

Posted in SQL Server 2008 | 6 Comments

Lots of Microsoft Activity Today

Microsoft has released the RTM version of SP2 for both Windows Vista and Windows Server 2008. They have an iso file that includes the x86 and x64 versions for both operating systems in several languages. It is up on both … Continue reading

Posted in Microsoft | 4 Comments

SQL Server 2008 Diagnostic Queries

To go with my previous SQL Server 2005 Diagnostic Queries, here is the SQL Server 2008 version. The initial queries are instance or server specific, while the later ones are database specific (which means you have to switch to the … Continue reading

Posted in SQL Server 2008 | 5 Comments

Updated SQL Server 2005 Diagnostic Queries

This is a set of queries that I often have clients run to give me a pretty decent high level overview of how their SQL Server system is configured and how it is performing. The initial queries are instance or … Continue reading

Posted in SQL Server 2005 | 7 Comments

Windows 7 Release Candidate on MSDN Subscribers on April 30

Brandon LeBlanc has made the official public announcement that the RC Build of Windows 7 will be available for download on the MSDN and TechNet subscription sites on April 30, 2009, and to the general public on May 5, 2009. … Continue reading

Posted in Microsoft | 1 Comment

The Database Bookshelf For SQL Server 2008

Since SQL Server 2008 has been released since August 2008, there are now a growing number of quality books available. I like both APress and Microsoft Press. APress has their SQL Server 2008 Bookshelf that lists all of their available … Continue reading

Posted in SQL Server 2008 | 1 Comment

Microsoft Gives Us “Lock Pages In Memory” for SQL Server 2005 and 2008 Standard Edition

Microsoft’s Bob Ward has a post up announcing that Microsoft will be adding a new trace flag that allow you to enable “Lock Pages In Memory” as part of the next Cumulative Update for both SQL Server 2005 and SQL … Continue reading

Posted in SQL Server 2008 | 4 Comments