Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

17 July
2015
Author: DustinRyan
DustinRyan

3 SSAS Dimension Design Best Practices to Live By

After spending the last five years or so designing and performance tuning SSAS cubes and dimensions for the clients of Pragmatic Works, I’ve noticed there seems to be a recurring pattern with poorly designed dimensions. Because of this I wanted to take a few minutes to point out three easy...
06 July
2015
Author: DustinRyan
DustinRyan

Three SSAS Best Practices to Follow

There is a lot of work that goes into performance tuning a SQL Server Analysis Services solution for a client. And even though there may be many steps involved in identifying performance and management issues with a large SSAS solution, there are a few things that we can quickly check and...
24 November
2013
Author: okeofs

Setting your predicate arguments at run time

This article shows how one may set your query predicate parameters at run time, by setting the arguments dynamically.

26 September
2013
Author: BradleyBall

Performance Tuning In LA!

Hello Dear Reader!  This year Pragmatic Works has brought our Performance Tuning Workshop to Chicago, Boston, and Atlanta.  Due to the success we've added one more stop before the end of the year, Los Angeles! That's right Pragmatic Works is headed to the City of Angels...
24 September
2013
Author: BradleyBall

Can You Compress a Temp Table?

 Hello Dear Reader!  We are finishing up the final day of the Performance Tuning Workshop here in Atlanta and I got an interesting question on Compression from Tim Radney (@tradney | Blog).   The question: Can you compress a temp table? Just a quick blog to get the...
02 August
2013
Author: Roger Wolter

File Format Versioning

        File versioning is another thing that I assume most people understand but I still run into a lot of confusion about.  This came up in one of the 24 Hours of PASS sessions I watched,  The question was something like “does the format of...
24 June
2013
Author: Steve Simon

Dynamic calculations of running totals

Dynamic calculations of running totals

11 April
2012
Author: bryan_cafferky

SQL Performance Tuning Tips For Developers Who Don't Like Performance Tuning

Ok, you've clicked on the run button twenty minutes ago and the query is still running. You really don''t want to stop and do serious performance tuning but you're getting that sinking feeling that you may celebrate your next birthday before this query comes back. You start to...
04 January
2010
Author: DevinKnight
DevinKnight

Creating a Reporting Services Data Driven Subscription

In this article you will learn how to create a Data Driven Subscription so your reports will run unattended on a schedule dynamically.

18 December
2009
Author: DustinRyan
DustinRyan

Building a Report from the Ground Up - Part 3: Displaying the Data in a Table

In Part 3 of Building a Report From the Ground Up, Dustin covers how to add a table to your report and display data. Dustin also briefly covers formatting your header and text boxes.