October 14, 2021: “Intro to Query Store”

Join us on Thursday, October 14 (register HERE) for Tracy Boggiano presenting on “Intro to Query Store”!

In this session, we will look at how to configure your SQL Server Instances

In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.

Speaker Bio: Tracy Boggiano is currently a Data Platform MVP, PASSion 2020 Award winner, and works as a Senior Database Administrator for DocuSign. Tracy has worked on SQL Server since 6.5. She has spoken at numerous local user groups and SQLSaturdays, virtual groups, Data Relay, and Summit. She is currently a co-leader of the Triangle SQL Server User Group in Raleigh, NC. Tracy tinkered with databases in middle school to keep her sports card collection organized and got an early start on databases.

Her passion outside of SQL Server is volunteering by advocating for abused and neglected foster children in court through the North Carolina Guardian ad Litem program. This is her favorite and most important job. She has been an Guardian ad Litem for 18+ years and advocated for over 50+ children. As someone who experienced mental health issues she has for the past two years started being a mental health advocate by being a part of the PAIMI (Protection and Advocacy of Individuals with Mental Illnesses) Advisory Council with the DRNC (Disability Rights of North Carolina).

September 12, 2021: “SQL Server Configuration with dbatools and dbachecks”

Join us on Thursday, September 12 (register HERE) for Tracy Boggiano presenting on “SQL Server Configuration with dbatools and dbachecks”!

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.

Tracy Boggiano is currently a Data Platform MVP, PASSion 2020 Award winner, and works as a Senior Database Administrator for DocuSign. Tracy has worked on SQL Server since 6.5. She has spoken at numerous local user groups and SQLSaturdays, virtual groups, Data Relay, and Summit. She is currently a co-leader of the Triangle SQL Server User Group in Raleigh, NC. Tracy tinkered with databases in middle school to keep her sports card collection organized and got an early start on databases.

Her passion outside of SQL Server is volunteering by advocating for abused and neglected foster children in court through the North Carolina Guardian ad Litem program. This is her favorite and most important job. She has been an Guardian ad Litem for 18+ years and advocated for over 50+ children. As someone who experienced mental health issues she has for the past two years started being a mental health advocate by being a part of the PAIMI (Protection and Advocacy of Individuals with Mental Illnesses) Advisory Council with the DRNC (Disability Rights of North Carolina).

Find out more about Tracy on tracyboggiano.com!

Forgot to post: August 12 – “Shaving Off Microseconds”

I messed up and never got a post out on our blog for our August 12 meeting! We had Thomas Grohser here to speak on “Shaving Off Microseconds.” We should have a recording of this session, but we still have to do some coordination to get the video uploaded and available. I will update the Meetup and this page once we do!