February 2016 TechNet Guru Competition

Every month I judge entries in the TechNet Wiki Guru competition SQL Server Business Intelligence category.  Over the years, we have seen excellent contributions and insightful articles about advanced techniques and product tips.  The next time you need to solve a particularly vexing BI problem, go to the TechNet Wiki and do a focused search.  You’re likely to find useful solutions. 

This month, there are three particularly good entries that I would like to showcase.  These are all great entries and valuable contributions.  The winners we will announced here: http://social.technet.microsoft.com/wiki/contents/articles/33351.technet-guru-contributions-february-2016.aspx

SSIS – Transfer data from Multiple tables using a single DFT
A framework for importing multiple tables and adapting to different column data types.  This is a common challenge in large-scale ETL projects that often requires third-party products or deep programming.  This approach solves the problem with out-of-the-box SSIS.

DAX: Dates Prior to 1900
A common issue when working with historical dates.   These techniques work-around the native data type and DAX function limits with dates earlier than 1/1/1900.

SSRS Tips : Implementing OR Based Logic for Dataset Filters
SSRS report filters are powerful but not always intuitive.  This technique applies OR logic to compound Boolean filters to work-around limitations of the designer.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s