Archives: July 2012
One annoying thing about SSIS (2008) and some of the other project types in Visual Studio is the lack of an "Open Project Directory..." option on the project right-click menu. Visual Studio's "Tools" menu can provide a work-around this.
Go to Tools... External Tools... and add a new entry… Read more
Use of the PIVOT operator in T-SQL has always been tantalizing yet confounding to me. It offers the promise of more concise and expressive code compared to a subselect pattern, yet I've always found it difficult to get the code just right so that I could apply it in a… Read more