Category Archives: Uncategorized

Setting Parameters in SSIS at Run time

In SSIS when you are running a package with a parameter I find myself wanting to set the Project Parameters at run time. You can do this by creating an Enviroment Variable and then running the below script to set … Continue reading

Posted in Uncategorized | Leave a comment

Create Date Dimension with Fiscal and Time

Here are three scripts that create and Date and Time Dimension and can add the fiscal columns too. First run the Dim Date script first to create the DimDate table. Make sure you change the start date and end date … Continue reading

Posted in Uncategorized | 1 Comment

JAX SQL User Group – Speaker Idol 4/17/13

Last nights Speaker Idol at the Jacksonville SQL User Group was awesome. Had 4 great speakers. the winners took home some great prizes. But my favorite part of the night was a slide by Mitch (@SqlLittleFriend) . He paid tribute … Continue reading

Posted in Uncategorized | Leave a comment

SSRS Map Label Overlap Fixed

In Reporting Services 2008 r2 and above there is a great tool called the Map tool. It is great for visualizing data across a map. One of the issues I have run into is overlapping labels. For example I am … Continue reading

Posted in Syndication, Uncategorized | Leave a comment