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.

26 January
2014
Author: okeofs

Master Data Services for the Beginner Part 01

About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with the product in SQL Server 2008 R2 but (like others did) found it very awkward to work with and difficult to understand. Microsoft has done a super job with this version and this sparked me into...
25 January
2014
Author: okeofs

Master Data Services Disaster Recovery Challenges

While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative data, disaster recovery from the failure of a model or the MDS database itself can be a challenge to say the least.

23 December
2013
Author: okeofs

Master Data Services 2014: Creating nightly load processes

A few days ago, I ran into an interesting issue when creating a stored procedure to load new data into a 2012 Master Data Services entity via a staging table and a SQL Server stored procedure. This article shows how I created and assembled the necessary fields and data in the format necessary to...
26 November
2013
Author: okeofs

Setting your predicate arguments at run time Part: 2 MultiSelect

This article is part two of an earlier article. It shows the method that I use (as a standard), to multi-select items from SSRS drop down boxes. This technique is used to filter the returned dataset (which is eventually used by the SSRS matrix)

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.

19 November
2013
Author: TyroneBrown

Webinar: Controlling Your SSIS Control Flow Using Containers

The Control Flow of SSIS provides numerous ways to control the processing of your ETL tasks. Fortunately, programming is no longer required to control looping and processing logic as they were in DTS due to the introduction of SSIS containers. In this beginner-level session we’ll learn how...
26 September
2013
Author: Abhisheck

Understanding "Set Based"approache and "Procedural Based" approach.

I will present some simple techniques to convert "Procedural SQL" into "Set based SQL" that might help you write better SQL :).

24 June
2013
Author: Steve Simon

Dynamic calculations of running totals

Dynamic calculations of running totals

30 November
2012
Author: MitchellPearson

How to flatten data using the Pivot Transform in SSIS.

The Pivot Transform is a very powerful tool but often overlooked and isn't the first thing to come to mind when you need it most. Imagine you have a table that has an employee listing for each type of phone number. For example, you have one row for business phone, personal phone,...
21 November
2012
Author: MitchellPearson

Error Code 0xC020907F - The Conversion returned status value 2 - error code 0xC0209029

I finally finished creating my flat file test data for a series of SSIS practice exercises. While trying to create the finished project to break it down into smaller problems I ran into this error message: [Data Conversion [212]] Error: Data conversion failed while converting column...