Instructor: Mitchell Pearson
Thank you everyone for attending my webinar on SSIS Performance Tuning.
Below are some of the questions that I received from the Webinar:
Your source for SQL Server and Business Intelligence expert insight and the latest Pragmatic Works' news.
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…
By: Devin Knight
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.