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/
-
31:49
MichaelBisping
1 day agoBISPING & ANIK: Is Conor McGregor INJURED?! | Who Could Replace Him? | What's next for Poirier?
5.84K5 -
16:00
Space Ice
18 hours ago'Resident Evil: Retribution' Is So Bad It's Like Looking Into A Mirror - Worst Movie Ever
6.88K13 -
23:59
Degenerate Plays
14 hours agoThe Denny's Dictator Impresses Women - Call Of Duty Modern Warfare Remastered : Part 5
7K -
1:13:51
Blue Siesta ASMR
23 hours agoASMR Sims 4 Gameplay | New Roommates Move in Tiny House | already dating? 😱 Soft Spoken
8.56K2 -
46:53
Chrissy Clark
16 hours agoAn Anti-Boomer, Anti-Cringey Podcast w/ Allie Cluff
12.8K33 -
9:07
shaneyyricch
14 hours agoAddressing my beef with Harry Sisson
25K29 -
20:40
The Nima Yamini Show
13 hours agoAlpha King Nima Exposes Anti-Masculinity Agenda
30.7K45 -
7:02
TENET Media
16 hours agoNYC Hotels TAKEN OVER By Migrants | Lauren Southern
44.4K95 -
47:35
Alexis Wilkins
17 hours agoBetween the Headlines with Alexis Wilkins: NYPD Officers, Mexicos Leader, Fauci Hearing, DDay Salute
50.1K29 -
1:24:49
Glenn Greenwald
16 hours agoBriahna Joy Gray on her Firing from The Hill and Free Speech Double Standards; Leighton Woodhouse on his Reporting About Dr. Fauci’s Dog Experiments | SYSTEM UPDATE #279
109K340