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

Year: 2012

  • Home
  • 2012
Automation

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 3

June 25, 2012September 8, 2022By Tracy Boggiano

In the final part of the process will be the process that creates all the reports and zips up the performance counter file on a central server.    The first part copies the PerfMon file from each server to a central location.  After the copy is complete and loops back

Automation Performance

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 2

April 4, 2012September 8, 2022By Tracy Boggiano

In this part of the process, we will set up a process to automatically stop the data collector or counter log on the remote server.  Then rename the file with a time stamp if it is an older version of Windows.  Finally, we will start the data collector or counter

Automation

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 1

March 29, 2012September 8, 2022By Tracy Boggiano

I recently was re-exposed to the PAL (Performance Analysis of Logs) Tool available on CodePlex at a wonderful SQLskills class.  I had played with the tool in the past, but at the time the server I had for setting things up and automating processes was Windows 2000, so I forgot

T-SQL Tuesday
Miscellaneous T-SQL Tuesday

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

March 13, 2012September 8, 2022By Tracy Boggiano

This month’s T-SQL Tuesday is brought to us by Argenis Fernandez (blog | @DBArgenis). Argenis is asking if we specialize or not, why we do (or don’t) specialize, and why we feel that’s a good thing. I started out my career as a Jack of All Trades mainly because my

Miscellaneous

A New Year Means New Resolutions – 2012

January 5, 2012February 13, 2018By Tracy Boggiano

I usually do not make resolutions because that seems like you are trying to give up something instead of gaining something.  I would prefer to call them goals that way they can be a list of possible accomplishments instead of potential failures.  For 2012, I decided to record my goals

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.