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.

27 June
2012
Author: PatrickLeBlanc

How to Create Reporting Services 2012 Report Templates

When I started writing this blog I realized it has been several months since my last post.  I guess that is what happens when you try to write two books at the same time.&

08 February
2012
Author: PatrickLeBlanc

AlwaysOn: Configuring Secondary Read-Only Access

Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary replicas.  The first step is to s

10 January
2012
Author: PatrickLeBlanc

PowerView: Coordinating Chart Colors

During a recent customer engagement I was asked if it was possible to ensure that the colors in a Line Graph for a particular value would be the same colo

01 November
2011
Author: PatrickLeBlanc

Free Business Intelligence Workshop

If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop.  The details are below:

24 October
2011
Author: PatrickLeBlanc

SSIS 2012: Project Reference

One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using the Execute Package task

13 October
2011
Author: PatrickLeBlanc

SQL Server 2012 SSIS – Why is my toolbox empty?

So recently I was doing a demonstration using the new SQL 2012 SSIS running in Visual Studio 2010. I needed to open my toolbox, of course I went to the menu bar selected

13 October
2011
Author: PatrickLeBlanc

SSRS 2008 R2: Implementing Row-level Security

When working at large organizations with several users, managing security using Windows or SQL authentication could be challenging. However, there are a couple of solutions tha

06 October
2011
Author: PatrickLeBlanc

SSRS 2008 R2: Show Column Meta-Data in ToolTip

First, I want to apologize to the three people that read my blog. Sorry for going dark for such a long period of time. I am not going to commit to writing on a regular basis ju

25 May
2011
Author: PatrickLeBlanc

SSRS 2008 R2: How to dynamically size your INDICATORS

The indicators that are available in SQL 2008R2 adds great visualizations to your reports. I was recently building an SSRS demonstration and I stumbled upon an additional

19 May
2011
Author: PatrickLeBlanc

WHERE HAVE YOU BEEN, patrick leblanc????

Ok, so what have I been up to?  Well a lot