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
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
Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in measure data of a fact
There are many posts available that describe how to test Analysis Services security from inside the development environment. Today I would like to share a
Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is often forgotten. Basically what discretization
In a previous article I showed how you can create dynamic security in SSAS. This is a great way to make all security table based
I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS data types. At first glance
In several previous posts I have described some of the usability changes that will come with the next release of SSIS. Annotations Data Flow Grouping
I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali. In previous posts I wrote about
There have been several usability features that have been added to SSIS in the latest CTP. One of these features is Grouping in the Data
One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z) is the new resolve reference
The end has come! We’ve been told for several years the vNext of SQL Server will no longer support DTS and it appear that that
Picked up this nice script from a client last week. Use this script below to create a Date Dimension for a data warehouse that is
Devin Knight 