SQL Server Configuration with dbatools & dbachecks by Tracy Boggiano | SQL Server Virtual Conference

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. About Speaker: Tracy is the Database Superhero for DocuSign. She has spent over 20 years in IT and has used SQL Server since 1999. Tracy covers all aspects of administration and deals heavily with performance tuning and high availability and disaster recovery. Tracy is a co-organizer of her local user group, TriPass, in Raleigh, NC. Before she worked full-time as a DBA she was formally a developer and network administrator. She also tinkered with databases in middle/high school to keep her sports card collection organized. Conference Website: https://www.2020twenty.net/sql-server-virtual-conference/ C# Corner - Community of Software and Data Developers https://www.c-sharpcorner.com #SQL #dbatools #dbachecks #conference #sqlserver