We’ve all been waiting a long time for SQL Server 20005 and not everyone has been able to get the betas to get an early look. Well now anyone can get their hands on the beta 2 of SQL Server 2005 Express edition. The Express edition, what’s that? We never...

People often ask me, “When Microsoft is going to get into the type of clustering as defined by Oracle’s RAC (Real Application Clusters)?” Generally, I find these are people who believe the technical concepts behind RAC are the way of the future, so naturally...

For those attending my TechNet SQL 2000 performance tuning session at TVP Reading on Tuesday 25th Jan, here is the code for the track_waitstats and get_waitstats stored procedures I refer to during the presentation. CREATE proc track_waitstats ...

Sometimes I hear the comment that someone can’t get their application to scale above 50 – 100 users; above a certain number of users there is a sudden ceiling in scalability. So often I have found this to be a problem with nothing more than SQL Server...

Hitchhiker’s Guide to SQL Server Reporting Services is an excellent book in the Hitchhiker’s series of excellent books. The book is co written by Peter Blackburn (UK MVP) and William Vaughn (massive reputation). I think it is excellent for three reasons;...

Please follow the link below to the MS KB article containing the above SP. Note the 'fast' parameter to improve performance by reducing the amount of extra diagnostic info returned. http://support.microsoft.com/default.aspx?scid=kb;en-us;271509...

This tool has been available for a couple of months but I only found out about it yesterday; I was reading some stuff about SQL Server 2005 and found a reference to say this tool will be supported in SQL 2k5. Realising such downloads have sometimes escaped...