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 using Active Directory accounts associated with the items that the user is allowed to see. 

If you decide that your security model is pretty basic… Read more

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 they seem to be nothing like SQL Server data types you love and know.  That's why I've provided below a conversion chart of SSIS data… Read more

Recently Adam Jorgenson wrote a blog post titled Come be your best at Pragmatic Works, which described the work environment at our company and how we have many positions are available now at varying experience levels.  One thing that I’ve noticed when talking to people about applying with us… Read more

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

Resolve Reference

Today I’m going to introduce you to the Source and Destination Assistants that has been added to the Data Flow.  The idea behind… Read more