Skip to content
Tracy Boggiano's Blog

Tracy Boggiano's Blog

Musing on more than data, trying to make a difference somewhere…

  • Home
  • About Me
  • Presentations
  • Events
  • DEI Virtual Group
  • Speaking Mentors
  • TriPass
  • WITspiration
  • Mental Health Resources
  • DBA Resources

Month: July 2017

  • Home
  • 2017
  • July
Automation Scripts

Setting Custom Fill Factors Based on Page Splits

July 25, 2017December 31, 2017By Tracy Boggiano

Introduction There is a lot of talk about what fill factor should be set for an index.  We know for indexes that are ever increasing the fill factor should be set to 100% but for those indexes that are on things like last name or birthday it gets a bit

High Availability/Disaster Recovery Scripts

Monitoring Availability Groups Part 3 – Extended Events

July 11, 2017July 1, 2017By Tracy Boggiano

In last part of the series, we will touch on how to monitor availability groups using extended events.  I prefer this method over using SQL Agent alerts just because I don’t like relying on the individual servers to send me emails.  I like to have our central monitoring server send

Miscellaneous Training

First Time Advise for Attendees of SQLSaturday or Other Pass Events

July 2, 2017September 8, 2022By Tracy Boggiano

Recently I came across on Twitter a question from Chad Smith asking for advise on attending his first SQLSaturday.  The fact is asking means he is already ahead of the game and he is on Twitter.  I got him to follow me on Twitter and offered him the following the

Recent Posts

  • Looking Back at 2025: Volunteering Is My Way of Life January 9, 2026
  • Living with Chronic Suicidal Thoughts: A Personal Reflection November 20, 2024
  • MVP No more, But It’s OK July 12, 2024
  • Presenting at PASS Summit 2023 – Atomic Habits July 26, 2023
  • Twenty Years as a Guardian ad Litem June 26, 2023

Categories

  • Automation (24)
  • Exam Prep (9)
  • High Availability/Disaster Recovery (5)
  • Mental Health (14)
  • Miscellaneous (51)
  • Performance (14)
  • PowerShell (7)
  • Scripts (23)
  • Security (8)
  • SQLskills (1)
  • T-SQL Tuesday (32)
  • Training (4)
All Rights Reserved 2022.
Proudly powered by WordPress | Theme: Saya by Candid Themes.