Speaker

Tracy Boggiano

Tracy Boggiano

Database Superhero at Sound Physicians, Just someone trying to make a difference in the world

Raleigh, North Carolina, United States

Tracy Boggiano is currently a 3x Data Platform MVP, the PASSion 2020 Award winner for her outstanding volunteer work in the data community and works as a Database Architect for Sound Physicians. Tracy has worked on SQL Server since 6.5. She is currently a co-leader of the Triangle SQL Server User Group in Raleigh, NC, and the Diversity, Equity, and Inclusion Data Community Virtual Group.  She was featured in RedGate's inaugural 100 most influential data professional's list in the Community Heroes category in 2021.

When she is not doing things in the Data Platform community, she tries to make a difference somewhere.  Her number one 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 a Guardian ad Litem since 2003 and advocated for over 60 children. She won the Overall Outstanding Volunteer Award in her county from the United Way in 2021 for her volunteer work with the Guardian ad Litem program. 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). She also serves on the board of directors for Foster Family Alliance of NC, a charity dedicated to educating, advocating, supporting, and promoting partnerships that led to positive outcomes for children, youth and foster families of NC, and Youth Lead NC, a charity dedicated equipping youth with disabilities with the skills and support needed to reach their full potential and become independent, productive members of society. She also volunteers with her church. Don't ask how she has time to do these things, she will say it has something to do with "fairy dust".

Awards

Area of Expertise

  • Information & Communications Technology

Topics

  • SQL Server
  • Azure SQL Database
  • Azure SQL DB
  • Mental Health
  • Mental Wellbeing
  • Mental Health at Work
  • Wellbeing resilience and mental wellness

How Leaders Can Support Their Employee’s Mental Health

Ever had an employee under your leadership going through a trying time with their mental health and not know what do or what to say? Did an employee ever take time off to attend to their mental health and you weren’t sure how to handle their situation when they came back to work? Have you suspected an employee was having an issue and didn’t know how to approach the subject? Then come to this session for the answers to these questions and more so you as a leader can help support an employee’s mental health.

This session is intended for anybody in a leadership role. This session provides practical, straightforward strategies to be used to address a very difficult topic.

Using dbachecks to Validate Your SQL Server Estate

Checking that all your SQL server instances are in compliance with your standards can be a tedious task if you have to do it manually. Well, that is where dbachecks comes in. This open-source PowerShell community written module makes this task easy. It can be run across your entire estate to check your instances are meeting all your standards. It has several built-in tests for things such as how long ago was CHECKDB run, how long ago were backups run, are your SQL Agent operators correct, is Query Store configured properly, is DAC allowed, is the instance CIS compliant, are your autogrowth settings correct, do you have too many VLFs in your log file, and many more. You can even write your own if they don’t exist in the module. The results can be displayed in a PowerBI report that is easy for managers to understand and saved to a database for historical reporting.

Come to this session to learn how to leverage this PowerShell module to make sure your environment is meeting your standards everywhere without having to write your own solution.

How To Get the Auditors Off Your Butt with dbachecks

Auditors are no fun to deal with and proving your systems meet their standards can be a PITA. Do you really want to have to provide print screens or run queries on servers to provide them with data when you can just run PowerShell using dbachecks and produce a PowerBi report? Yeah, I didn’t think so, so let’s talk about how to use dbachecks then specifically how to use for CIS compliance. After that we will cover how to write your own custom checks so you can utilize this tool for your own security compliance requirements.

Mental Health and Wellness in IT: Safeguarding our most precious resource

One in four Americans suffers from a mental health challenge each year. In the tech community, this number rises to 42% and rises to 48% in the UK. Mental health challenges in IT is a worldwide problem. The stigma associated with discussions around mental health, as well as how it can negatively impact your work and home life, make people reluctant to discuss the topic. Now is the time to start discussing mental health in tech and how to take advantage of the opportunity to safeguard our most precious resource: people.

We'll discuss how mental health affects job quality, including sharing examples from my professional life. We'll discuss the four primary workplace factors which play a pivotal role in mental health challenges in the tech community. I'll provide tips on what is best to say and not say to people you know whose lives are being affected by their mental health. Lastly, we'll cover how to make your workplace a safe place where mental health can be talked about and how to encourage your company to offer resources to help maintain everyone's mental health.

Microsoft Data Professionals' Forum Upcoming

Using dbachecks to Validate your SQL Server Estate

June 2023 Charlotte, North Carolina, United States

SQLBits 2023 - General Sessions Upcoming

March 2023 Newport, United Kingdom

Southampton Data Platform and Cloud user group - in-person meetup User group

January 2023 Southampton, United Kingdom

Richmond SQL Server Users Group

SQL Server Configuration with dbatools and dbachecks

December 2022

PASS Data Community Summit 2022

Using dbachecks to Validate your SQL Server Estate

November 2022 Seattle, Washington, United States

Raleigh PowerShell User Group

Using dbachecks to Validate your SQL Server Estate

October 2022 Raleigh, North Carolina, United States

Capital Area SQL Server User Group

SQL Server Configuration with dbatools and dbachecks

July 2022

Los Angeles Data Platform User Group

SQL Server Configuration with dbatools and dbachecks

June 2022

Chicago Data Professionals User Group

SQL Server Configuration with dbatools and dbachecks

January 2022

SQL Trail

Mental Health and Wellness in IT: Safeguarding our most precious resource

October 2021

Glass SQL Server User Group

Intro to Query Store

October 2021

Calgary User Group

Mental Health and Wellness in IT: Safeguarding our most precious resource

September 2021

Azure Summit

September 2021

TGIF

Mental Health and Wellness in IT: Safeguarding our most precious resource

September 2021

Glass Local User Group

SQL Server Configuration with dbatools and dbachecks

September 2021

Dativerse #1

August 2021

Sacramento SQL Server Local User Group

SQL Server Configuration with dbatools and dbachecks

August 2021

SQLData Partners Podcast

Mental Health and Wellness in IT: Safeguarding our most precious resource

August 2021

Triad SQL Server User Group

SQL Server Configuration with dbatools and dbachecks

July 2021

Denver Local User Group

SQL Server Configuration with dbatools and dbachecks

May 2021

Data Saturday Southwest US

May 2021

Columbus User Group

Mental Health and Wellness in IT: Safeguarding our most precious resource

May 2021

Data Platform WIT - Mental Wellness Day

May 2021

Cork Local SQL Server User Group

SQL Server Configuration with dbatools and dbachecks

May 2021

PowerBI Days NL

Mental Health and Wellness in IT: Safeguarding our most precious resource

May 2021

Data Relay East Anglia,

Mental Health and Wellness in IT: Safeguarding our most precious resource

April 2021

PHP Midwest Conference 2021

Mental Health and Wellness in IT: Safeguarding our most precious resource

April 2021

Minnesota Local SQL Server User Group

SQL Server Configuration with dbatools and dbachecks

April 2021

HaitianSQLOneDayEvent

March 2021

Quad Cities Data Professional Group

SQL Server Configuration with dbatools and dbachecks

March 2021

Redmond Local User Group

SQL Server Configuration with dbatools and dbachecks

March 2021

Data Platform WIT Day

SQL Server Configuration with dbatools and dbachecks

March 2021

Adalaide Local SQL Server User Group

SQL Server Configuration with dbatools and dbachecks

February 2021

Pinellas Local User Group

Intro to Query Store

January 2021

Saturday #1015 Vienna 2021

Intro to Query Store

January 2021

Philadelphia Local User Group

SQL Server Configuration with dbatools and dbachecks

January 2021

Richmond SQL Server Local User Group

SQL Server Configuration with dbatools and dbachecks

December 2020

Greater Lansing SQL Server Local User Group

Mental Health and Wellness in IT: Safeguarding our most precious resource

December 2020

PASS Virtual Summit 2020

Mental Health in IT: Safeguarding our most precious resource

November 2020

SQLSaturday Oregon #1000

Mental Health in IT: Safeguarding our most precious resource

October 2020

Mixed Extents Podcast

Query Store

October 2020

SQLSaturday Puerto Rico Virtual #1005

SQL Server Configuration with dbatools and dbachecks

October 2020

Idera Geek Sync

Intro to Query Store

September 2020

Edmonton PASS Local User

Mental Health and Wellness in IT: Safeguarding our most precious resource

September 2020

SQLSaturday Salt Lake City Virtual #997

SQL Server Configuration with dbatools and dbachecks

August 2020

SQLSaturday #991 Iowa City

Mental Health and Wellness in IT: Safeguarding our most precious resource
Intro to Query Store

August 2020

Data Ceili Dublin 2020

July 2020 Dublin, Ireland

PASS Virtual Professional Development

Mental Health and Wellness in IT: Safeguarding our most precious resource

May 2020

Dataweekender 2020

Mental Health and Wellness in IT: Safeguarding our most precious resource

May 2020

SQLSaturday #935 Rochester

Intro to Query Store
More Common Than You Think: Mental Illness in Tech

February 2020 Rochester, New York, United States

SQLSaturday #939 – Austin – BI Edition

More Common Than You Think: Mental Illness in Tech

February 2020 Austin, Texas, United States

SQLSaturday #933 Nashville

Using Open Source Products to Collect Performance Metrics

January 2020 Nashville, Tennessee, United States

SQLSaturday #923 Washington, DC

Intro to Query Store

December 2019 Washington, Washington, D.C., United States

Richmond SQL Server Local SQL User Group

Intro to Query Store

December 2019 Richmond, Virginia, United States

SQLSaturday #918 Charlotte

More Common Than You Think: Mental Illness in Tech

December 2019 Charlotte, North Carolina, United States

PASS Summit 2019

Using Open Source Products to Collect Performance Metrics

November 2019 Seattle, Washington, United States

Albany SQL Server User Group

Intro to Query Store

October 2019

SQLSaturday #867 Baton Rouge

Using Open Source Products to Collect Performance Metrics
Intro to Query Store

August 2019 Baton Rouge, Louisiana, United States

SQLSaturday #883 Louisville

Using Open Source Products to Collect Performance Metrics

August 2019 Louisville, Kentucky, United States

Richmond SQL Server Local SQL User Group

Using Open Source Products to Collect Performance Metrics

July 2019 Richmond, Virginia, United States

SQLSaturday #845 Atlanta

Intro to Query Store

May 2019 Atlanta, Georgia, United States

DBA Fundamentals Down Under Virtual Group

Using Open Source Products to Collect Performance Metrics

May 2019

SQLSaturday #863 Raleigh

Using Open Source Products to Collect Performance Metrics

April 2019 Raleigh, North Carolina, United States

SQLSaturday #846 Richmond

Intro to Query Store
Using Open Source Products to Collect Performance Metrics

March 2019 Richmond, Virginia, United States

Triad SQL Server Local SQL User Group

Collecting Performance Metrics

March 2019 Greensboro, North Carolina, United States

Louisville SQL Server Local User Group

Intro to Query Store

March 2019 Louisville, Kentucky, United States

Baton Rouge SQL Server Local SQL User Group

Using Open Source Products to Collect Performance Metrics

March 2019

Lexington SQL Server Local User Group

Using Open Source Products to Collect Performance Metrics

March 2019 Lexington, Kentucky, United States

Glasgow SQL Server Local User Group

Using Open Source Products to Collect Performance Metrics

February 2019

GroupBy.org

Using Open Source Products to Collect Performance Metrics

December 2018

PASS Summit 2018

Let Them Finish: Stories from the Trenches
Azure SQL Database Maintenance and Automation

November 2018 Seattle, Washington, United States

SQLSaturday #806 Charlotte

Collecting Performance Metrics

October 2018 Charlotte, North Carolina, United States

SQLSaturday #790 Holland

Monitoring Availability Groups

October 2018 Utrecht, Netherlands

Data Relay

Intro to Query Store

October 2018 Bristol, United Kingdom

Data Relay

Intro to Query Store

October 2018 Reading, United Kingdom

SQL Data Partners Podcast

Managing a Lot of Database

October 2018

Data Relay

Intro to Query Store

October 2018 Birmingham, United Kingdom

Data Relay

Intro to Query Store

October 2018 Leeds, United Kingdom

Data Relay

Intro to Query Store

October 2018 Newcastle under Lyme, United Kingdom

SQLSaturday #765 Denmark

Collecting Performance Metrics

October 2018 Copenhagen, Denmark

SQLSaturday #770 Pittsburgh

Intro to Query Store
Tips on Managing Lots of SQL Servers

September 2018 Pittsburgh, Pennsylvania, United States

SQLSaturday #744 Denver

Monitoring Availability Groups

September 2018 Denver, Colorado, United States

PASS Database Administration Virtual Group

Collecting Performance Metrics

August 2018

SQLSaturday #736 Columbus

Monitoring Availability Groups

July 2018 Columbus, Ohio, United States

PASS Performance Virtual Group

Collecting Performance Metrics

July 2018

SQLSaturday #729 Louisville

Tips on Managing Lots of SQL Servers
Intro to Query Store

July 2018 Louisville, Kentucky, United States

Hampton Roads SQL Server Local User Group

Collecting Performance Metrics

July 2018 Virginia Beach, Virginia, United States

WIT PASS Virtual Group

Intro to Query Store

July 2018

SQLSaturday #766 Houston

Monitoring Availability Groups

June 2018 Houston, Texas, United States

SQLSaturday #773 Los Angeles

Collecting Performance Metrics
Women in Technology Panel

June 2018 Los Angeles, California, United States

Michiana PASS Local User Group

Query Store Primer

May 2018

SQLSaturday #734 Dallas

Intro to Query Store

May 2018 Dallas, Texas, United States

IDERA Live

Defend Your Database Against Disasters

May 2018

SQL Server Innovators Guild Greenville/Spartanburg, SC

Collecting Performance Metrics

May 2018

SQLSaturday #717 Wheeling

Monitoring Availability Groups

April 2018 Wheeling, West Virginia, United States

Lincoln SQL Server Local User Group

Monitoring Availability Groups

April 2018

SQLSaturday #714 Philadelphia

Collecting Performance Metrics
Tips on Managing Lots of SQL Servers

April 2018 Philadelphia, Pennsylvania, United States

SQLSaturday #721 Raleigh

Query Store Primer

April 2018 Raleigh, North Carolina, United States

SQLSaturday #723 Rochester

Query Store Primer

March 2018 Rochester, New York, United States

Malibu PASS Local User Group

Query Store Primer

March 2018

SQLSaturday #719 Chicago

Collecting Performance Metrics
Monitoring Availability Groups

March 2018 Chicago, Illinois, United States

SQLSaturday #699 Tampa

Collecting Performance Metrics

February 2018 Tampa, Florida, United States

SQLSaturday #708 Cleveland

Tips on Managing Lots of SQL Servers

February 2018 Cleveland, Ohio, United States

SQLSaturday #698 Nashville

Query Store Primer
SQL Server Remote Management Best Practices

January 2018 Nashville, Tennessee, United States

SQLSaturday #693 Washington, DC

Monitoring Availability Groups

December 2017 Washington, Washington, D.C., United States

Washington, DC SQL Server Local User Group

SQL Server Performance Metrics: How do you collect them and why should you care?

November 2017 Washington, Washington, D.C., United States

PASS Database Administration Virtual Group

Query Store Primer

November 2017

PASS Summit 2017

Beyond The Install: Monitoring Availability Groups

November 2017 Seattle, Washington, United States

SQLSaturday #683 Charlotte

Query Store Primer

October 2017 Charlotte, North Carolina, United States

SQLSaturday #678 Orlando

Query Store Primer
Tips on Managing Lots of SQL Servers

October 2017 Orlando, Florida, United States

Companero Conference

4 Ways You Should Collect Performances

October 2017 Norfolk, Virginia, United States

SQLSaturday #636 Pittsburgh

Does This Look Weird? The Importance ff Baselining

September 2017 Pittsburgh, Pennsylvania, United States

SQLSaturday #681 Spartanburg

Does This Look Weird? The Importance of Baselining
Query Store Primer

September 2017 Spartanburg, South Carolina, United States

TriPass SQL Server User Group

Monitoring Availability Groups

September 2017 Raleigh, North Carolina, United States

GroupBy

Monitoring Availability Groups

September 2017

PASS Database Administration Virtual Group

Tips on Managing a Lot of SQL Servers

August 2017

SQLSaturday #629 Indianapolis

Query Store Primer

August 2017 Indianapolis, Indiana, United States

SQLSaturday #643 Louisville

Query Store Primer

August 2017 Louisville, Kentucky, United States

SQLSaturday #653 Columbus

Collecting Baseline Metrics

July 2017 Columbus, Ohio, United States

SQLSaturday #652 Atlanta

Collecting Baseline Metrics

July 2017 Atlanta, Georgia, United States

SQL Data Partners Podcast

Monitoring Availability Groups

June 2017

SQLSaturday #624 Chattanooga

Monitoring Availability Groups

June 2017 Chattanooga, Tennessee, United States

SQLSaturday #627 South Florida

Query Store Primer
How to Manage Many Instances of SQL

June 2017 Davie, Florida, United States

SQLSaturday #638 Philadelphia

Query Store Primer

June 2017 Philadelphia, Pennsylvania, United States

SQL Data Partners Podcast

The first change you would make

June 2017

SQLSaturday #615 Baltimore aka My 40th Birthday Party

Monitoring Availability Groups

May 2017 Baltimore, Maryland, United States

Triad SQL Server User Group

Query Store Primer

March 2017

SQLSaturday #584 Colorado Spings

Disaster Where to Begin

March 2017 Colorado Springs, Colorado, United States

SQLSaturday #610 Richmond

Monitoring Availability Groups

March 2017 Richmond, Virginia, United States

SQLSaturday #592 Raleigh

Monitoring Availability Groups

March 2017 Raleigh, North Carolina, United States

SQLSaturday #581 Nashville

Query Store Primer
Disaster Where to Begin

January 2017 Nashville, Tennessee, United States

SQLSaturday #476 Salt Lake City

Disaster Where to Begin
Query Store Primer

November 2016 Salt Lake City, Utah, United States

SQLSaturday #560 Charlotte

Query Store Primer

September 2016 Charlotte, North Carolina, United States

SQLSaturday #544 Spartanburg

Query Store Primer
Disaster Where to Begin

August 2016 Spartanburg, South Carolina, United States

SQLSaturday #531 Louisville

Query Store Primer

August 2016 Louisville, Kentucky, United States

Triangle SQL Server User Group

Query Store Primer

July 2016 Raleigh, North Carolina, United States

SQLSaturday #486 Richmond

Disaster Where to Begin

March 2016 Richmond, Virginia, United States

SQLSaturday #470 Washington DC

Disaster Recovery 101

December 2015 Washington, Washington, D.C., United States

SQLSaturday #452 Charlotte

Disaster Where to Begin

October 2015 Charlotte, North Carolina, United States

SQLSaturday #445 Raleigh

Disaster Recovery 101

October 2015 Raleigh, North Carolina, United States

Tracy Boggiano

Database Superhero at Sound Physicians, Just someone trying to make a difference in the world

Raleigh, North Carolina, United States