ed elliott - practical dsc in azure
TRANSCRIPT
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Practical DSC in Azure
Ed Elliott
“Lift n’ Shift” SQL, App & Web
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
2007 Doc
2017MOF Doc
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Part 1:
Azure Automation Account
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Azure Automation Account
• Do Stuff
•DSC Stuff
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
ConfigurationPull Server
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Pull Server Output
Compiled EncryptedAwesome
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
ReportServer
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Report Server
https://blogs.technet.microsoft.com/ashleymcglone/2017/01/12/pro-tip-powershell-dsc-events-to-monitor/
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
LCM
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
AZURE virtual machine DSC extension
meet
AZURE automation account
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Github Sample
https://github.com/Azure/azure-quickstart-templates/tree/master/dsc-extension-azure-automation-pullserver
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
2 Servers – ARM Deploy Successful / Arm Deploy
Fail
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Part 2:Troubleshooting
• Compilation
• Output logs of compilation process in portal
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
DSC Extension
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
APPLY THIS NOW!
• Start-DscConfiguration –UseExisting
WOW
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Applying DSC ConfigurationReports or c:\windows\system32\Configuration\ConfigurationStatus
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
C:\Windows\system32\Configuration
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Register-PSRepository -Name xDscDiagnosticsDev -SourceLocation https://ci.appveyor.com/nuget/xdscdiagnostics -InstallationPolicy Trusted -Verboseinstall-module xdscdiagnostics -Repository 'xDscDiagnosticsDev'
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Part 3: Lift n’ Shift Case Study
• SQL Server
• App Server
• Web Server
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Raw (AzureRM) Powershell…
• Resource Group
• Azure Automation Account
• MOF’s / Resources
• Remove Failed VM Extensions
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
ARM
• Virtual Machines (and disks, nic’s, nsg’s, etc)
• VM Image SQLServer + SQLIaasExtension
• Domain Join Extension
• DSC Extension
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
VM Image
• SQL Installed
• SQL
• SSIS
• SSRS
• SSAS
• SSMS
• Images patched / updated behind scenes…
• SQLIaasExtension
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
DSC
• Regional Settings
• Disk Configuration
• Windows Features (IIS, .Net, Clustering Support)
• Administrators
• Service Credentials
• Download / Install Application
• Debug Logger
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Installing APPS Easily
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
CATTLE NOT PETS
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog
Raw(er) Powershell (SQL Server)
• New-Cluster
• Enable-SqlAlwaysOn
• New-SqlHadrEndpoint
T-SQL• CREATE AVAILABILITY GROUP
• WITH SEEDING_MODE = AUTOMATIC and other A Words
• ALTER AG ADD LISTENER
@EdDebug |
@DataDevOps
https://the.agilesql.club | https://sabin.io/blog