November 2006 - Posts
PerformancePoint Server 2007 CTP1 is now available via the Connect website https://connect.microsoft.com/site/sitehome.aspx?SiteID=181 . The bits (x86 and x64) are available to download including documentation and sample data etc. I haven't had a change
Read More...
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
Read More...
Tony Rogerson (SQL Server MVP who runs the UK site sqlserverfaq.com) has two copies (invitations) of MSDN Team Subscription to give away! Go here to read the full competition details: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/11/1285.aspx
Read More...
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
Read More...
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
Read More...
The Service Pack 2 CTP 2 download will be available very soon from here: http://www.microsoft.com/sql/ctp.mspx . In the meantime, please take a look at the What's New readme document which is available here: http://go.microsoft.com/fwlink/?LinkId=71711
Read More...
We have just released a new whitepaper on MSDN which is worth a read: Architecting Service Broker Applications http://msdn2.microsoft.com/en-us/library/aa964144.aspx
Read More...