PerformancePoint Server 2007 CTP1 now available

PerformancePoint Server 2007 CTP1 is now available via the Connect website  The bits (x86 and x64) are available to download including documentation and sample data etc.  I haven’t had a change to look at it yet but will do over the next few days.  On a slightly different note, my brother has decided to run in the London Marathon…


Tempdb on RAM disks, Solid State?

This is quite an interesting KB article detailing I/O requirements for tempdb, and amongst other things, the use of RAM disks and solid state media.  There are some important points to consider e.g. as the media is not durable, only tempdb can be located on it; it cannot be used for other database files.  It is also worth remembering that the…


Win a copy of MSDN Team Subscription

Tony Rogerson (SQL Server MVP who runs the UK site has two copies (invitations) of MSDN Team Subscription to give away!  Go here to read the full competition details: What do you need to do?  Simple really, just contribute technical information, hints and tips or advice to the SQL Server community via the UK SQL Server User Group…


Sysinternal Utilities on TechNet!

The sysinternal tools are now on TechNet.  I know this is not specifically related to SQL Server however, but they are very useful tools which can help diagnose performance problems.   I particularly like process explorer and process monitor (and they work on x64 & Vista too!).  Get them here:


Using vardecimal storage in SQL Server 2005 SP2 CTP2

As you probably know, Service Pack 2 for SQL Server 2005 introduces the vardecimal storage format.  Below is a step-by-step example using the AdventureWorks database.  There are a few incorrections in BOL SP2 CTP2 although these are not major problems and can be easily resolved; I imagine discussions are ongoing about naming conventions for the vardecimal options.  USE master…


SQL Server 2005 Service Pack 2 CTP 2

The Service Pack 2 CTP 2 download will be available very soon from here: In the meantime, please take a look at the What’s New readme document which is available here:   This provides a comprehensive review of the new and improved features.  I particularly like the fact that SSIS is no longer required for maintenance plans.  The…