SQL PASS Detroit

We have meetings on the second Thursday of every month.

Each meeting start with a short introduction and Q & A session, where we'll have chapter news and may also have job announcements.  The normal schedule for each meeting is:

6:00 - 6:10		General Introduction, announcements and general Q & A
6:10 - 7:30		Main presentation (90-minute presentations will run until 8:00)
		Question and answer session to follow

Thanks to the help of some really amazing speakers, we have 2019 lined up with some great topics.  Special thanks go out to the wonderful folks at Pet Supplies Plus Corporate Headquarters in Livonia, Michigan.  They've given us a home since December 2017.

The January meeting is on 1/10/2018. Please make your FREE reservations for the meeting at EventBrite. The meeting location is included on the EventBrite reservation page.

DBAtools Powershell

Ever wanted automate restoring databases? Disaster recovery testing? Database instanace migrations? Using [DBATools](https://dbatools.io) and [DBAChecks](https://dbachecks.io) PowerShell modules, I will demo using these open sources tools taking a bare bones SQL installation, configure it using industry standard best practices and migrate all the users, advanced settings, databases and more. After the migration is complete, we will use dbachecks to validate the server is setup as expected.

DBAtools is a PowerShell module boasting 400+ commands to help you deploy, administer and migrate SQL server instances. DBACheck is a framework using Pester and Dbatools to validate your SQL server environment. Both of these tools are open source and free for you to use.

Expect less than 10 slides, back and forth discussions and lots of DEMOS! Additional demos include automating restore testing with DBCC checkdb, keeping user accounts in sync across instances and (time permitting) using Desired State Configuration to install and configure SQL server.

Speaker Bio: Scott Miller
Scott has worked in the IT industry since 1998 holding many roles from Network/Security admin to OS/DBA team lead. Currently he works as a platform engineer on the infrastructure team for Domino's Pizza at the World Resource Center in Ann Arbor. Scott, along with his team, manage application deployments and 3rd level support mostly using PowerShell to configure, administer and gather information on thousands of point of sale servers running SQL on Hyper-V throughout the US.

Prior to Dominos, Scott lead an OS/DBA team providing SaaS services as well as on-prem managed and DBA services for ERP software. This is where he started his passion for PowerShell which he used to automate redundant processes as well as his desire to teach others to automate the world!

Please send any questions, concerns, etc to sqlpassindetroit@gmail.com.
Please note that our old email address (detroit@pass.org) is no longer active because PASS is no longer providing Office 365 accounts to chapters.

If you have any questions about the group please drop us a line. If you're interested in speaking we're especially interested to hear from you.