For the 4th year SQL Saturday comes to Jacksonville, FL this year on April 30, 2011. Many of you already know about these events but just to remind you it is a totally FREE all day event that brings top speakers to you.

I hope everyone already realizes this, but… Read more

I had a client recently show me a neat little tip that I thought I would share.  In the cube he was designing he had the need for measures to show under multiple display folders.  For example, he had a Sales Amount measure and he wanted it to be in… Read more

SSIS provide several methods for passing values into your packages at runtime.  The benefit of doing so allows you to change the results of the package without having to even open the package in the development environment (BIDS). 

The typical way of doing this is to create variables inside your… Read more

All Analysis Services dimensions have a default All member that represents all the members for a particular attribute.  For example, let’s say you have a product dimension with an attribute for the product name.  This attribute will be given an All member that represents every product.  The All member has… Read more