JUN 2022 - SQL Server Config with dbatools and dbachecks by Tracy Boggiano (@TracyBoggiano)
Abstract
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.
Speaker Bio
Tracy is the Database Superhero for DocuSign. Tracy does things in the Microsoft Data Platform Community and is Microsoft Data Platform MVP. Tracy has volunteered through the NC Guardian ad Litem program since 2003 being the voice for abused and neglected foster children in the court system. This is her passion outside of SQL Server and her favorite, most important job. When Tracy isn't volunteering in the Microsoft Data Platform community, she likes to be making a difference somewhere.
Slide deck and code
https://tracyboggiano.com/presentations/
-
58:33
The Body Language Guy
2 hours agoTrump BREAKS the internet, Kamala DROPS, Newsom BANS MEMES and MOAR!
18.2K7 -
49:15
VIVA TV
4 hours agoHank and Chaps Tee It Up in a Dartboard Rematch Presented by Fireball
15.7K -
46:18
Kimberly Guilfoyle
7 hours agoFed up: it’s time for answers, live with Pat Brosnan, Steve Moore & Karoline Leavitt | Ep. 159
31.4K30 -
1:03:41
Redacted News
3 hours agoDeep State PREPARING You For Election Night Turmoil, Fed just admitted the truth | Redacted News
87.2K180 -
46:17
Candace Show Podcast
3 hours agoGuess Who’s Back? I’m Out of YouTube Jail. | Candace Ep 68
76.6K289 -
1:59:23
Revenge of the Cis
4 hours agoEpisode 1377: Bad Boys
41.2K6 -
16:14:11
Right Side Broadcasting Network
6 days agoLIVE REPLAY: President Trump Holds a Rally in Uniondale, New York - 9/18/24
610K384 -
3:46
Cooking with Gruel
1 day agoHow to Make Your Own Doritos
40.3K13 -
1:04:03
In The Litter Box w/ Jewels & Catturd
22 hours agoTeamsters for Trump! | In the Litter Box w/ Jewels & Catturd – Ep. 650 – 9/19/2024
57.7K47 -
1:07:28
Dr. Drew
7 hours agoMatt Walsh: What Is A Racist? Am I A Woman? And Other Important Questions – Ask Dr. Drew
49.3K3