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 March
2017
Author: Robert Cain

IT ops and news talk–Episode 3 Secure that Jump Server

I owe everyone an apology, I missed blogging about this at the time it occurred. Last December I was a guest on Don Box’s podcast, “IT ops and news talk”. I appeared on Episode 3, Secure that Jump Server. In the podcast we discuss the testing of PowerShell code with Pester. After that we got...
03 February
2017
Author: Robert Cain

Troy Hunt: A data breach investigation blow-by-blow

This is a fascinating read from security researcher Troy Hunt. In it he describes the process by which he investigates a data breach. Well worth the read. https://www.troyhunt.com/a-data-breach-investigation-blow-by-blow/
31 January
2017
Author: Robert Cain

SQL Server Reporting Services Playbook now live on Pluralsight!

My newest course, the SQL Server Reporting Services Playbook, is now live on Pluralsight! If you are looking to get up to speed fast writing reports in SQL Server Reporting Services, this is the course for you. In roughly two hours you will have enough information to start cranking out reports...
13 January
2017
Author: Robert Cain

What’s New in SQL Server 2016 Reporting Services–Now live at Pluralsight

So you want to see what’s new in SQL Server 2016 Reporting Services? Well I’ve got just the thing for you. My 12th course just went live on Pluralsight, named appropriately “What’s New in SQL Server 2016 Reporting Services”. This course is designed specifically for those who are already familiar...
03 December
2016
Author: Robert Cain

SQL Sever 2016 Reporting Services Cookbook has arrived!

  I’m proud to announce my latest book, the SQL Server 2016 Reporting Services Cookbook, has been released! This was a real labor of love, it consumed most of my summer and well into the fall. This book was published via Packt Press, and my coauthor was Dinesh Priyankara (blog | twitter). In...
12 October
2016
Author: Robert Cain

PowerShell Book Suggestions from IT/Dev Connections

In my session today at IT/Dev Connections in Las Vegas, several people asked me for book recommendations on PowerShell in general, and DSC (Desired State Configuration) in particular. The book I’ve used for a while is from APress, Windows PowerShell Desired State Configuration Revealed. I found...
07 October
2016
Author: Robert Cain

ArcaneCode–Headed your way!

I’ve not done much blogging, as I’ve been swamped with other activities. In addition I’ll be doing quite a bit of speaking, so let me catch you up. Recently I did a webinar for Pluralsight, “Why you should invest in PowerShell”. If you missed it the recording is now up, take a look, it’s free!...
08 July
2016
Author: Robert Cain

Zero to Hero with PowerShell and SQL Server–Precon at DevDataDay

Are you looking to learn about PowerShell? Do you use SQL Server? Then boy have I got a bargain for you! I’m doing a precon for our upcoming devdataday event. The precon will take place on Friday, August 19th, the day before devdataday. This is designed to be a course for the PowerShell novice....
03 July
2016
Author: Robert Cain

Updating and Sorting the Microsoft Word QuickStyle Gallery with PowerShell

  Introduction I’m currently working on my fifth book, this one is for the folks at PACKT Publishing. It’s still in the early stages so I can’t say too much, but if you like SQL Server Reporting Services, you’ll enjoy this book. All book publishers use their own set of styles in Microsoft Word...
03 July
2016
Author: Robert Cain

Temporary Post Used For Theme Detection (cc7e74de-438d-4ada-92b4-18832b45c4fc – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (a4a26c92-2a4e-421f-bfad-661c86bc1952 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)