Category Archives: Uncategorized

Setting Parameters in SSIS at Run time

Posted on August 26, 2019 by MikeDavisSQL

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

Posted on October 2, 2015 by MikeDavisSQL

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

Posted on April 18, 2013 by MikeDavisSQL

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

Posted on April 10, 2013 by MikeDavisSQL

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