March 2021 Meeting

Automating the configuration of SQL Server instances and being able to check the configuration for standard configuration is an important role for any DBA when you have lots of instances. But how can we automate the configuration easily? How can we check to make sure the proper configuration is in place and hasn’t changed?

In this session, we will look at how to configure your SQL Server Instances using PowerShell and the dbatools module. Then we will look at how to use dbachecks to confirm the configuration of our instances and how to check for changes in the future of the configuration. Attendees will see how easy it is to use PowerShell via dbatools to configure their SQL Server instances. Attendees will see how easy it is to use PowerShell via dbachecks and PowerBI to see if their servers are configured properly. Attendees will be given a set of scripts that take back to use to configure and test the configuration of their SQL Server instances.

Tracy Boggiano is currently a Data Platform MVP, PASSion 2020 Award winner, and works as a Senior Database Administrator for DocuSign. Tracy has worked on SQL Server since 6.5. She has spoken at numerous local user groups and SQLSaturdays, virtual groups, Data Relay, and Summit.

She is currently a co-leader of the TriPASS Local SQL Server User Group in Raleigh, NC and co-leader of the PASS DEI Virtual Group. Tracy tinkered with databases in middle school to keep her sports card collection organized and got an early start on databases.

Her passion outside of SQL Server is volunteering by advocating for abused and neglected foster children in court through the North Carolina Guardian ad Litem program. This is her favorite and most important job. She has been an Guardian ad Litem for 18+ years and advocated for over 50+ children. As someone who experience mental health issues she has for the past two years started being a mental health advocate by being a part of the PAIMI (Protection and Advocacy of Individuals with Mental Illnesses) Advisory Council with the DRNC (Disability Rights of North Carolina).

5:30 PM – 5:45 PM Networking & User Group updates
5:45 PM – 6:00 PM Sponsor Spotlight and Speaker Introduction
6:00 PM – 7:00 PM Featured presentation
7:00 PM – 7:30 PM Q&A and continued networking