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: Automation

  • Home
  • Automation
  • Page 3
Automation Scripts

Uploading New R Library Packages

May 23, 2017June 14, 2017By Tracy Boggiano

Somehow I have become the R DBA at my job which I don’t mind, I plan on taking Microsoft’s Professional Program on Data Science to be familiar with it.  But recently I’ve had to upload files to our R servers which the first time wasn’t too bad.  Copy these files

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

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.