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.

02 January
2018
Author: Robert Cain

Opening Port 80 in Windows Firewall to Support Calling SSRS From Another Computer

Recently I was working on another article for RedGate’s SimpleTalk site. As part of it, I had SSRS installed on a Windows 10 computer, and needed to connect to it from another computer. I was having a lot of issues connecting, until I remembered SSRS connects using Port 80, and by default Windows...
22 December
2017
Author: Robert Cain

Introduction to DW/BI–My Newest Old Course at Pluralsight

Way back in November of 2010, I published my second course with Pluralsight, Introduction to Data Warehousing and Business Intelligence. Over that time a lot has transpired. While the basic fundamentals haven’t changed, a lot of technology has. In addition, Microsoft’s WideWorldImporters sample...
19 December
2017
Author: Robert Cain

iTunes 12.7.2.60 Won’t Recognize iPad/iPhone after upgrade on Windows 10

I recently installed iTunes 12.7.2.60 on Windows 10; after the installation it would no longer recognize my iPad Pros (either one of them). The iPad would ask if I wanted to grant access to photos, etc., but iTunes itself would never show the iPad as being connected. Prior to the upgrade I had no...
18 December
2017
Author: Robert Cain

Adults Only Minecraft for Suicide Prevention

For some time now I’ve been working with a group of Minecrafters to raise money for the American Foundation for Suicide Prevention. So far we’ve raised over $3,400 dollars toward our year end goal of $3,650, so I’m writing to ask your help toward our goal. Anything you could give at ...
18 December
2017
Author: Robert Cain

SQL Server 2016 Reporting Services Cookbook–On Sale Until 2018!

Happy  Holidays! As a gift to everyone, PACKT Publishing has put the e-book version of my SQL Server 2016 Reporting Services Cookbook on sale for just $5. Yes, that’s right, for the same price as a pumpkin spice chai tea latte with extra whip cream, and a quick trip to http://bit.ly/ssrscook, you...
18 December
2017
Author: Robert Cain

A Walk Around SQL Operations Studio

In my latest article on RedGate’s Simple Talk site, I take you on a walk around the brand new SQL Operations Studio, or SQLOPS for short. If you haven’t heard about it, SQLOPS is the new open source, multiplatform tool for using SQL Server, think of it as SQL Server Management Studio for the PC....
11 December
2017
Author: Robert Cain

Creating Azure Resource Groups Safely With PowerShell

A few posts back I mentioned that I had become a SimpleTalk author, and that my first post for them was PowerShell Functions For Reusability and Restartability in Azure (read it at http://bit.ly/acred01) I’ve created a companion video for it, which focuses on creating Resource Groups. You can see...
10 December
2017
Author: Robert Cain

Fixed! PowerPoint 2016 Presenter View Not Showing

I purchased a new laptop earlier this year, a pretty sweet Lenovo ThinkPad. The only thing that annoyed me was PowerPoint 2016 wouldn’t show the presenter view. Well I finally got around to tracking down the issue. I found a post in an MSDN forum that was close, but not quite right in the...
30 November
2017
Author: Robert Cain

I’m Now a SimpleTalk Author!

Adding to my other activities, I’m now writing for SimpleTalk, RedGate’s community hub. My first article just went live. PowerShell Functions for Reusability and Restartability in Azure is the title, in it I describe how to implement the concepts of reusability and restartability in PowerShell....
06 October
2017
Author: Robert Cain

Making Videos for Fun and Profit

As I author this post, I’m at a Microsoft conference. Today’s focus is on the creation of video content to help promote your brand. As I have some experience with this from my Pluralsight videos, I had some suggestions as to technology. The first tool I use is from TechSmith, it is Camtasia. It...