DevOps has been around much longer than the current, cool, fashionable title has been used. The same can be said for SQL Server. The current wave of automation in IT that belongs to the DevOps movement has started to also take its hold in the SQL Server world too. Microsoft has a suite of their own tools to help achieve some of these goals, but as with many things, the community is much faster at moving forward.
Join André and William for a day of learning how to setup a SQL Server install with all the current best practices and maintenance without having to become the full time DBA of your team.
We will also show you how to make fast deployments of SQL Servers so you can use it in your test environments etc.
Topics that will be covered:
Create unattended installs, sysprep SQL Server and roll out Virtual Machines with SQL Server in no time
Use PowerShell to automatically keep an eye on your environment
Learn about PowerShell Desired State Configuration, automate installs by specifying what you want done, without having to know exactly how that is done
Azure Runbook automation, unlimited test and development environments at your fingertips
DBA Tips & Tricks
Create a solid setup, not just setup-next-next-finish
Configure the latest best practices and easy maintenance, we will explain why and how
Database Lifecycle Management, how do upgrades and migrations work?
Internals for managing and troubleshooting
We will make sure to include enough time for Q&A. Do you need to support SQL Server but you're not a DBA? Then this day is for you!
William Durkin is a DBA and SQL Server Solutions Architect for CloudDBA. He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects ranging from single server installations, up to environments spanning 5 continents using a range of high availablity solutions. William is a regular speaker at conferences around the globe and is a chapter leader for a German PASS chapter.
André Kamman is a SQL Server Solutions Architect at CloudDBA, based in The Netherlands. In previous roles he’s done a lot of DBA work on 100’s of servers where he discovered his love for Powershell and automating processes in general. Today the better part of his day he’s building and tuning Cloud migration scenarios, OLTP Systems, Data warehouses & ETL processes and even the occasional PDW. Enjoying automation so much, he's discovered BIML and is loving it. André is a SQL Server MPV, Dutch PASS Chapter Leader and organizer of SQL Rally Amsterdam and SQL Saturday Holland
The precons of the SQL Saturday #555 in Munich are done by community members for community members and they are free of charge. Just the lunch at the Microsoft cafetria has to be paid by yourself.
For more information about the SQL Saturday #555 Munich 2016 and the main conference on the 8th October 2016 visit http://www.sqlsaturday.com/555/EventHome.aspx.