Event link at our Meetup page.
5:30 pm Networking
6:00 pm Meeting
SQL Server Configuration with dbatools and dbachecks
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, Senior Database Administrator for DocuSign
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 Triangle SQL Server User Group in Raleigh, NC. Tracy tinkered with databases in middle school to keep her sports card collection organized and got an early start on databases.