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.

28 May
2014
Author: ChrisAlbrektson

Upsert Destination from Task Factory

 

 

23 June
2013
Author: ChrisAlbrektson

Myth: Can you return sub-reports from other report projects?

  Hey Folks, in this continuation of this blog series we will try to figure out another myth. Today we will investigate and try to determine if it’s possible to use a report from another project as a sub-report. In my current SSRS report project I have 2 reports. However, I...
10 December
2012
Author: ChrisAlbrektson

Taking my talents to ... Malibu Beach, kind of.

I have an exciting announcement to make. Since I have lived in the state of Florida for most of my life, I have decided to make a major change and take my talents to the west coast. Well, at least for a few days anyway. In late January on 1/29/13 – 1/30/13 I will be co-presenting an...
06 July
2012
Author: ChrisAlbrektson

Check out my SSRS 2012 Webinar

Pragmatic Works and Wrox have teamed up for a series of webinars that focus on the new release of SQL 2012 and the new SQL 2012 books from Wrox. On Tuesday July the 10th at 11 EST I will be giving a presentation titled, Getting Started with SSRS 2012. This will be an introduction type session and...
25 June
2012
Author: ChrisAlbrektson

Web Part Page Error When Adding Performance Point Content

Today I stumbled across a strange error while adding some new performance point content to a web part. My task was to take 2 reports and add them to a score card, easy enough huh? Well the first report was added without causing any problems. As you might have guessed already the second report...
18 June
2012
Author: ChrisAlbrektson

SQL Server 2012 TSQL Revised\Updated Function Part 5

  In this fifth and final blog post we will not be covering any new functions. Instead we will be covering an existing function which has been revised in SQL 2012. This is the last topic of this miniseries of blog posts covering the new TSQL function in SQL server 2012. The function we...
10 June
2012
Author: ChrisAlbrektson

SQL Server 2012 TSQL Conversion Functions Part 4

SQL Server 2012 TSQL Conversion Functions Part 4 In this forth blog post we will cover the new Conversion functions available in SQL 2012. This is the second to last topic of this miniseries of blog posts covering the new TSQL function in SQL server 2012. The first function we will be...
21 May
2012
Author: ChrisAlbrektson

SSRS Chart Scale Breaks

Do you want to make 4 thousand dollars a day? Well, I can’t help you with that but I can show you how to enable scale breaks in your SSRS reports. Below I will show you a lesser well known feature within SSRS that only takes 1 click to implement. As you can see from my sample report and...
27 March
2012
Author: ChrisAlbrektson

Book Review: Lincoln on Leadership

Lincoln on Leadership by Donald T. Phillips Hello BIDN, Before everyone starts to ask why I’m posting a blog about a book that has nothing to do with SQL or Business Intelligence, let me briefly explain. You’re correct. This book in theory has nothing to do with SQL, BI or IT in terms of...
25 March
2012
Author: ChrisAlbrektson

SQL Server 2012 TSQL DateTime Functions Part 3

In this third blog post we will cover the new DateTime functions available in SQL 2012. If you have read my previous 2 postings on this subject you probably have noticed only 2 -3 function per category. Well in this posting this changes where we will be covering 7 new DateTime functions. The...