Source: http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!2952.entry   Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some sort of a scary warning about how you should not use it on a production system, or … Continue reading →

A colleague pointed me to a nice cheat sheet for SQL Server developers. It contains: – A checklist for writing fast queries – Sargability of queries – A checklist for creating indexes – A legend of the ‘Execution Plan Icons’, … Continue reading →

I took me a couple of hours of research, waiting and clicking, but I have successfully been able to install the public beta of Sharepoint 2010 with the SQL Server 2008 R2 November CTP with PowerPivot for Sharepoint Server 2010 … Continue reading →

I just purchased this book to have something to read during my 44 hours in airplanes for a 4 week Christmas holiday in New Zealand. The book –written for charity – contains content from 53 MVPs with Paul Nielsen, Kalen … Continue reading →

I saw someone from Microsoft demonstrate a very cool feature included in Windows 7 and Windows Server 2008 R2. It is called the Problem Steps Recorder. You can launch it by running psr.exe. I find it very useful not for … Continue reading →