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.

06 May
2016
Author: BradleyBall

SQL Saturday Jacksonville #552 Pre-Con: A Day of DBA Fundamentals- Install- Maintenance plans-and Security

Hello Dear Reader!  I'm here in beautiful Jacksonville FL for the SQL Saturday 552 events!  Today my friend Dan Taylor (@DbaBulldog | Blog) and I are presenting our Pre-con A Day of DBA Fundamentals, Install, Maintenance Plans, and Security.We are having a lot of fun so far, and I wanted to...
05 May
2016
Author: Robert Cain

Much TODO with Sapien PowerShell Studio 2016 and Pester

I’ve been working a lot with Peter lately, and as I’ve blogged about before I use Sapien’s PowerShell Studio tool. The new 2016 version has an interesting new capability that while it may seem small, works extremely well when developing Pester tests. When I create a Pester test, for example for...
02 May
2016
Author: AlanFaulkner

SQL Saturday Jacksonville 2016 – Long Travel for the Community

        Hello all!  Fueling up for the long haul!  I am contemplating fueling up the SQL Bug and doing a cross country run!  If I had the time, I probably would do it!  That would be quite the cross-country jaunt, over the hills, through the woods, and over the dunes, to the Atlantic coast of...
02 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 2, 2016

Gotta love Mondays.  At least the weather here in Minnesota is clearing up, the last two weeks have been cold and overcast.  To get things started for the week, I’ll start again with a recap of the links I’ve shared and activity on my blog.  Also, for this this week, Michael Fal will be...
29 April
2016
Author: Robert Cain

Arcane Training and Consulting, LLC

Well this has been an exciting last few months. I’m finally able to share what’s been happening with me. As some of you know, I’ve left Pragmatic Works. They went through a reorganization of sorts, and several of us either had our positions eliminated, or as people departed were not replaced. Let...
28 April
2016
Author: SteveHughes

Power BI Is Finally in the Azure Trust Center

With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review where we are today with Power BI security and compliance as it relates to various customer needs. I do a lot of work with financial, energy, and medical customers. These groups...
26 April
2016
Author: DustinRyan
DustinRyan

Power BI and the Bing Maps API

This week I was working on a project for a school up North. This customer wanted to use Power BI and map visualizations to view the locations of the various school buildings in the district. The problem for this very large school district was that they were missing the street address information...
25 April
2016
Author: JasonStrate

Monday Morning SQL Break – April 25, 2016

It’s Monday and if getting a start on the week is as exciting for you as it is for me, it’s time to take a quick break.  For the break, here’s a summary of the most popular links and content that I shared out in the past week through this blog and twitter.  If you haven’t already, follow me on...
24 April
2016
Author: MitchellPearson

MDX CALCULATION WIZARD – 12 Awesome MDX Calculations

12 MDX Calculations for your SSAS Cube: If you have suddenly found yourself in a situation of having to improve the functionality of your cube with MDX Calculations but you don’t know MDX then you have come to right place!  Learning MDX can be a difficult task and one that can take some time, and...
20 April
2016
Author: SteveHughes

JSON in SQL Server 2016 – The Good, The Bad, and The Ugly

Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see this functionality coming. As an early user of XML when it was introduced, my expectations were high. Microsoft has done some really good work with JSON support, but I find that is not...