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/
-
47:07
Line Drive Podcast
4 hours agoRFK Jr.: Abortion up to BIRTH!
10.1K24 -
1:08:02
Edge of Wonder
7 hours agoTeleportation Experiments, AI Looks at Itself & Stallone’s Words of Wisdom
9.63K4 -
1:01:27
2 MIKES LIVE
9 hours ago#64 2ML Open Mike Friday live from Catch a Rising Star in Priceton NJ!
18.8K1 -
56:42
The Amber May Show
9 hours ago5 Reasons Why You Are Not Wealthy | Jim Tewalt
18K3 -
1:50:11
The Big Migâ„¢
1 day agoThe Getty Museum Exposed w/ EX NSA/CIA Contractor
20.4K18 -
1:59:53
Quite Frankly
10 hours ago"A Time We Never Knew, A New Barron, Reel Review" ft. Fleccas & Matt 5/10/24
18.9K10 -
5:06:55
Rebel News
1 day ago $0.22 earnedRumble LIVE: Defending your human right to freedom of expression
152K130 -
1:02:18
In The Litter Box w/ Jewels & Catturd
1 day agoNuts and Sluts | In the Litter Box w/ Jewels & Catturd - Ep. 565 - 5/10/2024
63.3K38 -
1:29:27
Twins Pod
7 hours agoTwins Pod - Episode 12 - Bryce Mitchell: Witches, Flat Earth & End Times?!
63.1K79 -
1:55:18
Revenge of the Cis
6 hours agoEpisode 1343: Headspace
54K45