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 …

Deploy System Center Service Manager (SCSM)

Part 1 - First Management Server Prerequisites SQL 2016 already configured Windows Server 2016 VMs created to host SCSM Domain account for the SCSM Service Domain account for the Workflow Service Domain Group for SCSM administrators SCSM service and workflow accounts added to local administrators group on the server that will become the first management …

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 …