Bruce Stump
Everwise Credit Union, Systems Administrator
South Bend, Indiana, United States
Actions
I worked at Notre Dame for over 15 years administrating various Linux and Windows based applications. I currently have been with Everwise Credit Union for over 7 years as a Systems Administrator. I graduated with a bachelor's degree in Computer Science from Indiana University of South Bend and I have over 15 years' experience with PowerShell.
Links
Area of Expertise
Topics
Improve PowerShell Code Efficiency with .NET RunSpaces
Efficient PowerShell Scripting is important when working with large sets of data. PowerShell users have many options at their disposal to increase the power of the code, including parallel processing, avoiding the pipeline, memory utilization, etc. PowerShell 7.x has additional features for Parallel Processing that PowerShell 5.1 does not have. I will briefly explain these various code enhancements and then go into a deep dive on .NET RunSpaces. I had to create a script that processed large quantities of data and the script was taking over 2 hours. With the help of .NET RunSpaces, I was able to get my script to around 10-15 minutes. The script runs on a Windows Server and is only used on PowerShell 5.1. I'll go into a detailed explanation on how .NET RunSpaces is used in the script along with a demonstration.
PowerShell with SQL Statement Data Gathering
Sometimes service monitoring is not straight forward, it is not as simple as checking whether a service or process is running on a server. What if you need to monitor for a service, but whether a service is successful is determined by the data in a database. I have created a PowerShell Module that will connect to a SQL database, retrieve the appropriate data, and determine whether the service is successful by the data retrieve from the SQL query. The module will then send an email to specific users on the status of a service. I automated the module to run once a day on a scheduled task, but it can be run more frequently if needed. I will explain the code in the PowerShell Module, including the SQL that is used to retrieve the data. The module can be expanded on if needed or it can be used as an example for your own SQL Query PowerShell Scripts.
PowerShell + DevOps Global Summit 2024 Sessionize Event
PowerShell + DevOps Global Summit 2023 Sessionize Event
Bruce Stump
Everwise Credit Union, Systems Administrator
South Bend, Indiana, United States
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top