SQL Migrations to Azure, Where Do I Start? Part 1

I've blogged already on what SQL PaaS services are available on Azure.  Microsoft are investing heavily in this area with both new SQL PaaS services, and migration options. Why?  A couple of reasons.  First, there are many businesses and civil services out there with multiple SQL servers or clusters that have grown over the past …

Create an SQL 2016 AlwaysOn Availability Group – Lab

Server Configuration 2x Windows Server 2016 virtual servers; Server01, Server02 Disk Config: Apps Disk on SCSI Controller 0 SQL DB Disk on SCSI Controller 1 SQL Log Disk on SCSI Controller 1 SQL TempDB Disk on SCSI Controller 2 SQL 2016 with SP2 Installed using DEFAULT instance SQL Server service account and computer accounts granted …

Runbooks Missing from the Service Manager Console

Sometimes when you create a Runbook in Orchestrator and then synchronise the Orchestrator connector the Runbook doesn't appear in the Runbooks view in the Service Manager Console.  This is because the Orchestrator authorisation cache hasn't updated yet to allow the connector access to the folder / Runbook. Run the following SQL script against the Orchestrator …