Exploring the SSIS MQ Task

Posted on 11 December 2012 by Rob Pellicaan

I’ve been exploring the Message Queue Task in SSIS and in this blog I will share some experiences, because the BOL is not really clear on these points. Quote from the Books Online: The Message Queue task allows you to Continue reading →

SQL: Removing a specific plan from the procedure cache

Posted on 27 January 2010 by Rob Pellicaan

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 →

SQL Server developers factsheet

Posted on 26 January 2010 by Rob Pellicaan

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 →

Installation of SharePoint 2010 with PowerPivot on a single server.

Posted on 24 November 2009 by Rob Pellicaan

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 →

SQL Server MVP Deep Dives – Something for your Christmas wish list ?

Posted on 24 November 2009 by Rob Pellicaan

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 →