Robert C. Cain (http://arcanecode.me/) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting LLC. He is also a course author for Pluralsight, Simple Talk author, and co-author of 5 books.
A popular speaker, Robert has presented at events such as the SQL 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.
Running SQL Server in a container may seem daunting at first, but it’s easy once you understand the handful of commands needed. In this article, Robert Cain demonstrates how to run SQL Server in a Docker container on Ubuntu.… Read more
Since SQL Server now runs in Linux, more database professionals will begin to learn this operating system. In this article, Robert Cain demonstrates how to set up an Ubuntu virtual machine for learning.… Read more
I’ve been speaking a lot on the topic of DevOps lately, and there’s a question I like to ask. What is the purpose of your organization? I get all kinds of answers. “We make software that delights our customers and makes their jobs easier.” “Our company makes low-cost widgets. “ “We make the best gizmos … Read more
Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.… Read more
Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.… Read more
The ability to quickly spin up a virtual machine is one of the great things about Azure. In this article, Robert Cain describes the steps to set up a VM using PowerShell using his PSAzure module. … Read more
Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather information needed and set up a resource group, storage and networking needed for the VM. … Read more
The new feature, Mobile Reports, was added to SSRS in 2016. It provides the ability to create attractive and useful dashboards that can run on devices and most browsers. Robert Cain shows you how to get started building Mobile Reports with the Mobile Report Publisher.… Read more
SQL Server Management Studio has been the default tool for working with SQL Server for over a decade. It’s not, however, compatible with any operating system outside of Microsoft Windows. SQL Operations Studio (SQLOPS), the open source program originally called ‘Project Carbon’, is now available for users of Linux and macOS as well as Windows. Robert Cain demonstrates the features of SQLOPS.… Read more
The key to efficient development is reusability. When developing scripts for administration, being able to restart a script where it left off is also important. Robert Cain shows you how to write functions in PowerShell that have these two qualities for administering Azure.… Read more