About Arcane Code


Robert C. Cain is the owner of Arcane Training and Consulting, LLC.

Robert creates online courses for Pluralsight (see below) and has coauthored five books, in addition to his blogging and YouTube activity. He was also a Microsoft MVP from 2008-2018.

A popular speaker, Robert has presented at events such as the PASS Summit, IT/Dev Connections, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years’ experience in the IT industry, working in a variety of fields including manufacturing, insurance, telecommunications, and nuclear power.

PowerShell is a passion for Robert’s. He has created training content in the form of books, videos, and live sessions. In addition, he has created solutions for many clients, using PowerShell with SQL Server, Azure, Pester, and more. Since the beginning of 2019, Robert has been working with PowerShell on Linux and macOS, interacting with Azure as well as SQL Server in Docker containers.

Over the last few years Robert has created extensive training material, including videos, blog posts, and live presentations on the Kusto Query Language (KQL). Kusto is used for querying large data clusters on Azure, along with metrics around your Azure resources.

Robert has over 10 years of experience in the Business Intelligence arena, working with SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services (both Multidimensional and Tabular). Robert has used SQL Server Database Projects to create data warehouses for many clients, using the Kimball methodology.

Prior to his work in the BI world, Robert worked as a software developer using C# and VB.NET. Previously he worked as a developer in a variety of languages such as C++, C, COBOL, and BASIC.

You can see Robert’s full resume (in PDF format) at this link: Robert C. Cain Resume.

Social Media

Robert has a strong social media presence on multiple sites. Tune into his Twitter, Facebook, and LinkedIn accounts for multiple stories daily of interest to the technical community. You’ll also find his code samples on his github site.

You can jump to Robert’s full  catalog on Pluralsight, or click on the course links below to jump directly to individual courses.

If don’t have a Pluralsight subscription, just click on the Try for Free link at the top of the page and you can get a free two-week trial subscription, with which you can watch my courses, or any course on Pluralsight.

Kusto Query Language: Scalar Operators (KQL Course 3)

Kusto Query Language: Beginning Operators (KQL Course 2)

Kusto Query Language: Getting Started (KQL Course 1)

Introduction to the SQL Server Mobile Report Publisher

PowerShell 7 Quick Start for Developers on Linux, macOS and Windows

Everyday PowerShell for Developers on Linux, macOS, and Windows

Getting Started with PowerShell Core on Linux and macOS

Microsoft Azure Data Explorer – Advanced KQL

Managing SSIS Projects

Introduction to the Azure Data Migration Service

Building Your First SSRS Report

Kusto Query Language (KQL) from Scratch

Azure PowerShell Playbook: Azure SQL

Introduction to Data Warehousing and Business Intelligence

SQL Server Reporting Services Playbook

What’s New in SQL Server 2016 Reporting Services

Beginning PowerShell Scripting for Developers

SSIS Design Patterns for Data Warehousing

What’s New in PowerShell Version 3

PowerShell and SQL Server

Introduction to PowerShell

Managing PowerPivot in SharePoint 2010

PowerPivot for SharePoint 2010 – System Setup

Visual Studio 2010 Database Projects


Robert is a contributor to RedGate’s SimpleTalk site. You can find all of his articles at: http://arcanecode.red



Robert has co-authored five books, on a variety of technical subjects. Note that for some of these titles the e-book version is only available via the publisher’s site.

SQL Server 2016 Reporting Services Cookbook
Publishers SiteAmazon

PowerShell Deep Dives
Publisher’s SiteAmazon

SQL Server MVP Deep Dives Volume 2
Publisher’s SiteAmazon

SQL Server MVP Deep Dives Volume 1
Publisher’s SiteAmazon

Professional SQL Server 2014 Administration
Publisher’s SiteAmazon


Robert’s company channel, Arcane Training and Consulting, can be found at:


Robert also has a personal YouTube channel for a variety of fun topics such as Minecraft and Ham Radio, you’ll find it at: