Author Archives: MikeDavisSQL

SSIS 2012 Copy or Duplicate Environments

Posted on May 2, 2012 by MikeDavisSQL

In SSIS 2012 there is a great new feature called environments. They can be thought of as a collection of parameters or variables. One of the questions I get asked when teaching SSIS 2012 is “Can I duplicate an environment?”. There … Continue reading →

Posted in SSIS, Syndication | Tagged , | 10 Comments

The IRS and SSRS

Posted on April 16, 2012 by MikeDavisSQL

Recently I did a webinar on the IRS and SSRS. In this webinar I covered creating reports with images and forms. I also covered how to manipulate data and showed you how to cheat on your taxes(not really).You can download … Continue reading →

Posted in SSRS | Leave a comment

How to use Report Builder 3.0

Posted on April 16, 2012 by MikeDavisSQL

I did a webinar during the 12 days of 2012 on how to use Report Builder 3.0. In this webinar I showed how to pull data from Stored Procedures and Shared Data sets. I also showed the issues that come … Continue reading →

Posted in SSRS, Syndication | Tagged | Leave a comment

Execute Multiple 2008/2005 SSIS Packages with a T-SQL

Posted on February 16, 2012 by MikeDavisSQL

If you want to execute a set of SSIS packages in SQL Server 2008 or 2005, you can do this using T-SQL. First you will  need a table with all of your package names on it. Then a While loop … Continue reading →

Posted in SSIS, Syndication, T-SQL | Tagged | 6 Comments

Sorting a String as a Number with T-SQL and SSIS

Posted on January 23, 2012 by MikeDavisSQL

I was working on a Cube in Analysis Services for a client recently and needed to sort on a field that was a varchar but contained numeric data. I wanted to sort as if it was numeric. I could not … Continue reading →

Posted in SSIS, Syndication, T-SQL | Tagged , | 2 Comments

Monitoring SQL Server with SSIS

Posted on December 8, 2011 by MikeDavisSQL

SQL Server can be monitoring with SSIS packages using the DMVs in SQL Server. I did a webinar on this and you can watch the video at PragmaticWorks.com under the webinars page. You can download the code for this webinar … Continue reading →

Posted in SSIS | Tagged , | 28 Comments

Pragmatic Works Win Software Awards

Posted on November 22, 2011 by MikeDavisSQL

Our Product BI xPress won two awards from SQL Server Magazine. Check it out! http://www.sqlmag.com/content1/topic/2011-sql-server-magazine-editors-community-choice-awards-140830/catpath/awards/showprivate/1/page/3

Posted in Pragmatic Works | Tagged | Leave a comment

Dimensional Modeling

Posted on November 17, 2011 by MikeDavisSQL

I did a webinar on dimensional modeling today at PragmaticWorks.com. You can watch the webinar there once they have the video uploaded. You can also download the slides from the video here. In this webinar I covered the ten rules … Continue reading →

Posted in Dim Model | Tagged , , | Leave a comment

How to hide Calculated Members in MDX SSAS

Posted on October 29, 2011 by MikeDavisSQL

With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used. For example: Aggregate(YTD([Date].[Calendar].CurrentMember),[Internet Sales Amount]) This calculation only works in the Date.Calendar Hierarchy. I wanted to show the end users … Continue reading →

Posted in mdx, SSAS, Syndication | Tagged , | 4 Comments

Setting up SSIS Auditing Part 2

Posted on October 21, 2011 by MikeDavisSQL

Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You … Continue reading →

Posted in SSIS, Syndication | Tagged | Leave a comment