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.

12 July
2017
Author: Robert Cain

Eric Ligman’s FREE Microsoft eBook Giveaway–Revising the download script

Every year, Eric Ligman, director of Sales Excellence for Microsoft, creates a blogpost in which he gives away tons of FREE Microsoft eBooks. This year has 361 in the list. You name it, it’s in the list. SQL Server, Azure, PowerShell, .NET, BizTalk, SharePoint, Windows Server, and more. You can...
12 July
2017
Author: Robert Cain

Temporary Post Used For Theme Detection (7a7ae270-2d45-4bc4-8cd2-e809986daa9c – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (5591406e-a24c-4553-aada-6c4b4f18a8de – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
02 July
2017
Author: Robert Cain

VidCon 2017 – Day 3

My third and final video for my VidCon 2017 coverage. In the video I mention two products I found on the floor I would be making videos of. These are: The 10 Foot Mighty Selfie Stick LumaFusion iOS Video Editor
25 June
2017
Author: Robert Cain

VidCon 2017 – Day 2

Below is my update from Day 2 of VidCon 2017. As you’ll see, while I have experience with recording screen presentations I’m still learning the ins and outs of recording myself as video, especially in the audio department. Bear with me, I’ve already ordered some new equipment to help in the audio...
24 June
2017
Author: Robert Cain

VidCon 2017 – Day 1

My thoughts on the first day at VidCon 2017, the video creators conference. In keeping with the event I did this as a video blog. More to come!
14 June
2017
Author: Robert Cain

PowerShell and XML

In this, my first video from my YouTube channel, I give a brief overview of reading, changing, and updating XML files from within PowerShell.   If you enjoy it, please be sure to visit my YouTube page and subscribe for more content.  
12 June
2017
Author: Robert Cain

What’s Old Is New Again: Updating Arcanecode

I realized it has been far too long since I updated the look and feel of the blog. If you’re reading this, you can obviously now see the new look and feel. Over to the right you can now see my Twitter feed. I post multiple stories daily of interest to the tech community. I’ve also generated a...
29 May
2017
Author: Robert Cain

Optimizing SQL Server Database Performance and Overcoming Unpredictable Challenges

This is a guest post from Tony Branson at ScaleArc. With the explosion of digital data, achieving optimum database performance has become the primary concern of every database professional. For improving efficiency when managing a complex IT environment, DBAs must stay one step ahead...
19 April
2017
Author: Robert Cain

What happened to Save-AzureRmProfile?

I’ve been working a lot in the Azure PowerShell area of late. One thing I wanted to be able to do is have my scripts login automatically to Azure. In many examples the cmdlet Save-AzureRmProfile was used to save your Azure credentials, then later you could use Import-AzureRmProfile to import...
28 March
2017
Author: Robert Cain

Converting (Remapping) Caps Lock to CTRL

I’ve always been a fan of the Lenovo Thinkpad keyboards. The have a good feel, and I especially love the Trackpoint. The Trackpoint is that little red nub between G and H, and acts as a mouse. With it I can do many mouse activities without removing my hands from the keyboard. With most it is a...