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.

12 November
2013
Author: RCharCox

Query Plans and what OPTION(RECOMPILE) does.

The other day I was tasked with creating a pretty intensive query (hey, I’m not an expert on T-SQL yet), and I came across a stored procedure that read something to the effect of:

&nb

21 July
2013
Author: RCharCox

Setting up a mirrored database using the Management Studio GUI

In my current position in Quality Assurance, I sometimes field some odd questions from our Support Team.  Recently, they had a client inquire about the feasibility of our product on a mirrored

10 July
2013
Author: RCharCox

Ternary Operators - C# basics

I learned a new word today.  Ternary.  Specifically speaking, ternary operators.  In programming languages, we all know that code comes down to basic conditions, right?  If a si

21 February
2013
Author: RCharCox

Using Messages to Navigate in an MVVM Structure

As a C# Noob, I've pretty much thrown myself in head first with my latest project.  However, to do it right, I wanted to use the MVVM structure that's all the rage these days (and for good rea

24 July
2012
Author: RCharCox

Creating new folders in Integration Services at the MSDB Level

As you work with Integration Services, you may encounter a situation where a little organization in your SQL deployed packages would be helpful.  One of the easiest problems to mitigate in the

22 June
2012
Author: RCharCox

What I learned while attempting to link my servers.

So you want to set up a linked server through Management Studios?  Great!  I’m sure you’ve got your steps down, too:

Step 1:  Open Management Studios

04 June
2012
Author: RCharCox

Nested Blocked Layout to Stepped: SSRS Hint

The tablix feature provides a level of flexibility that can be very powerful to the knowledgeable SSRS user.  It combines all of the aspects of a table, a list, and a matrix into one easy to m

24 May
2012
Author: RCharCox

Commenting Best Practices and How to Improve Your Code's Readability

When writing T-SQL, like most code, there’s a good way, a bad way, and a short way to do things.  Sometimes, the short way and the bad way are synonymous.  To assist in being able t

22 May
2012
Author: RCharCox

Deployment using Integration Services Catalog in SQL 2012

When SQL 2012 came out earlier this year, one of the biggest changes to its functionality was how the user deploys his or her Integration Services packages.  You still have the option to, from

22 May
2012
Author: RCharCox

Misadventures with SSRS Shared Datasets.

I had an "interesting" problem yesterday.  When creating a shared dataset, I made a "noob" error and added a filter so that it would only select rows that had "null" in one of the columns (not