<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Pragmatic Works Blog

Your source for SQL Server and Business Intelligence expert insight and the latest Pragmatic Works' news.

Webinar Follow-Up: SSIS Performance Tuning Techniques

Posted Aug 22, 2014 by Liz Hamilton

Instructor: Mitchell Pearson

Click here to watch the entire webinar.

Click here to view Mitchell's blog.

Thank you everyone for attending my webinar on SSIS Performance Tuning.

Below are some of the questions that I received from the Webinar:

Big Data Needs to Mean Big Insights

Posted Aug 21, 2014 by Adam Jorgensen


Recently the focus on increased insights and data driven decisions has become paramount from the board room to marketing, and even to the production floor. Those insights and decisions were promised by the world of “Big Data”. The hype around big data is unmistakable. You can’t miss it. I think Big Data will perform at the super bowl halftime show. Well maybe not, but you can bet that the stadium, advertisers, teams and vendors are all using big data technologies to be their best for that big game.

I speak with customers that are driven to implement a big data solution, and yet I’ve never seen more people working to learn and implement a technology with so little definition on how they plan to leverage it for their business. They know a few things…

  1. Big Data might allow them to increase the value and variety of decisions they make.
  2. These technologies might provide a way to get around the limitations of traditional BI systems.
  3. They believe it to be a cost effective and rapid time-to-value option
  4. They believe their team can adapt and learn the tools quickly
  5. Their superiors are counting on it to provide insight into business growth and efficiency opportunities

Writing Parametrized MDX for Reporting Services

Posted Aug 15, 2014 by Devin Knight

By: Devin Knight

Click here to view Devin's blog.

Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long.  If all you need is the Query Designer to create a drag and drop datasets then it’s a piece of cake, but have you ever wondered what’s going on with all the MDX that the Query Designer creates.  Or how about how do the parameters work that it creates inside MDX.  I’ve heard many report writers that use Analysis Services as a data source (including myself) say it is too difficult to create parameters and that’s why they use the Query Designer.

Webinar Follow-Up: Create a Tactical Plan Using Hadoop & Cloud Tech

Posted Aug 06, 2014 by Liz Hamilton

Presenter: Rowland Gosling

Click here to view the entire webinar.

Click here to view Rowland's blog.

Thank you to all who attended my online workshop this morning! I had two questions I’d like to address:

Subscribe to Blog Updates