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/
-
LIVE
Right Side Broadcasting Network
5 days agoLIVE REPLAY: President Trump Holds a Rally in Uniondale, New York - 9/18/24
9,177 watching -
2:12:03
Benny Johnson
6 hours ago🚨Trump Speaking LIVE Right NOW At FIRST RALLY Since Assassination Attempt | THOUSANDS in New York!
87.3K72 -
2:14:03
Fresh and Fit
5 hours agoThe Game Has Changed: How Modern Dating is Different & Why Men Struggle
66.6K37 -
1:19:00
Glenn Greenwald
9 hours agoIsrael's War on Terror; Fighting Campus and Government Censorship with FIRE's Nico Perrino | SYSTEM UPDATE #336
83.3K46 -
1:15:23
Dr. Drew
12 hours agoLara Trump LIVE: Election Integrity, Immigration & The Aftermath Of 2 Assassin Attempts Against Her Father-In-Law Donald Trump – Ask Dr. Drew
85.9K17 -
5:10:45
Drew Hernandez
15 hours agoTRUMP RALLY UNIONDALE NEW YORK
81.1K38 -
1:15:06
Michael Franzese
8 hours agoTrump assassination attempt & fact checking Harris | Michael Franzese LIVE! Ep. 18
80.5K38 -
1:55:58
Melonie Mac
8 hours agoGo Boom Live Ep 21!
65.7K18 -
1:40:08
Redacted News
9 hours agoSHOCK! Secret Service admits it CAN'T stop more Trump Assassination Attempts | Redacted Live
186K296 -
50:56
Candace Show Podcast
9 hours agoExploding Pagers In Lebanon! Is This Terrorism? | Candace Ep 67
219K912