About Show #427
Desired State Configuration and SQL Server? Richard talks to Patrick Curran about using DSC for more than just setting up a web farm. In fact, Patrick uses DSC to set up an entire SharePoint infrastructure - including SQL Server! And that is the tricky bit, since SQL Server isn't quite as PowerShell friendly as IIS. Patrick talks about battling the SQL PowerShell bits which sometime install, sometimes not so much - ultimately you're better off using SQL internal scripting for a reliable install. Lots of interesting thoughts about taking DSC to the max!
Patrick Curran is currently the Director for the Federal Group and a SharePoint Architect for Planet Technologies. He has been building solutions with SharePoint since 2003, specializing mostly in complex architecture, administration, branding, and custom development in addition to advanced troubleshooting. Patrick works with clients all over the world to help integrate their organization into SharePoint.
He has a very diverse background, and brings a lot of experience and insight into infrastructure and troubleshooting. Patrick has designed and deployed many farms of varying complexity over the years, especially within the Federal realm where nothing is small or simple.
Patrick was also fortunate enough to co-author Microsoft® SharePoint® 2013: Designing and Architecting Solutions for Microsoft Press, along with Shannon Bray and Miguel Wood.
He also does a lot of hybrid cloud work, mostly between Azure and O365 and most recently has been working with Desired State Configuration (DSC) for SharePoint installations.