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

Category: Scripts

  • Home
  • Scripts
  • Page 3
High Availability/Disaster Recovery Scripts

Monitoring Availability Groups Part 1 – Perfmon Counters

April 26, 2017May 28, 2017By Tracy Boggiano

Monitoring Availability Groups can be tricky.  The DMVs don’t update the log_send_rate and redo_rate all the time especially if nothing is happening so if you try to use those for calculations when monitoring you could false results worse yet pages in the middle of the night.  In order to calculate the log_send_rate

Scripts

Running SQL Scripts Against Multiple Servers Using PowerShell

April 11, 2017April 22, 2019By Tracy Boggiano

Update: From time to time I get questions on this blog post and since I have wrote it dbatools has come out with method do this and if you have not checked out dbatools you should.  Click here to get started with dbatools and here (Invoke-DbaQuery) to see the function

Scripts

Script to Setup SQL Server Database Mirroring for Multiple Databases

February 10, 2014February 13, 2018By Tracy Boggiano

Last year I had a project that involved using database mirroring between two servers that had 20+ user databases on them and setting those up one a time takes way too long.  I wrote this script to generate a script that could be run in SQLCMD mode and setup mirroring

Posts pagination

Previous 1 2 3

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.