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.

31 May
2016
Author: JasonStrate

“Tuesday Morning” SQL Break – May 31, 2016

Yesterday it was Monday, which is when I usually aim to post a weekly blog and twitter round-up.  But since I slept-in and went to Valleyfair yesterday, I got an excellent reason not to get this finished.  So instead of a Monday morning post, we’ve got a Tuesday evening.  But hey, let’s get this...
31 May
2016
Author: JasonStrate

“Tuesday Morning” SQL Break – May 31, 2016

Yesterday it was Monday, which is when I usually aim to post a weekly blog and twitter round-up.  But since I slept-in and went to Valleyfair yesterday, I got an excellent reason not to get this finished.  So instead of a Monday morning post, we’ve got a Tuesday evening.  But hey, let’s get this...
31 May
2016
Author: DustinRyan
DustinRyan

Power BI Desktop May 2016 Update Info: Conditional Formatting and Quick Calc

So it appears that the May 2016 update to Power BI Desktop has dropped without any notification from the Power BI team on their blog. So I figured I’d take a moment to point out a couple new enhancements to Power BI Desktop. New to Power BI Desktop? Get started here. 1. Conditional Formatting...
23 May
2016
Author: Joshua Luedeman

The Cloud: The Real Deal or the Next Big Fad

I am an unapologetic cloud enthusiast. When Amazon Web Services became publicly available, I signed up for the first roll out of developer credits to try the service out. I remember signing up for Azure credit when the free month Read More ...
23 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 23, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog. You may have...
23 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 23, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog. You may have...
23 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 16, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog. Most Popular...
23 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 16, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog. Most Popular...
20 May
2016
Author: BradleyBall

SQL Server Random Workload Generator

Hello Dear Reader!  Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog).  He’s an Microsoft Data Platform MVP, MCM,  part of the amazing crew over at SQLSkills, and a really nice guy.  About 4 years ago Jonathan created The AdventureWorks2008R2 BOL...
20 May
2016
Author: MitchellPearson

How to get Line Item Detail information with Totals in T-SQL (Percent of Parent).

Hi All, This blog post is a follow up to a question I received when I gave my Advanced TSQL Webinar for Pragmatic Works. If you haven’t seen that yet and would like to see it you can view the webinar here:  Question: How can we get SubTotals in TSQL using the CTE method you mentioned? In my...