Cisco UCS Monitoring Solution (PowerShell/WinForms/REST API) DESCRIPTION: Monitors UCS infrastructure by polling multiple UCS Domains and creating JSON report of the domain inventory, configuration, and overall performance. JSON example: Dashboard view: Monitors Faults and potential future problems, provides deeper insight on root cause contributing to faults. JSON example: Front-end view: UCS Inventory Tool The data … Continue reading Cisco Unified Computing System (UCS) Cloud Monitoring Solution →

Performance Monitoring Solution Sending Alerts to CRM System via REST API (C++/PowerShell/WinForms/REST) DESCRIPTION: PowerShell scripts permanently registered as Windows services to monitor various activities and send alerts to Salesforce (Cloud CRM system). DOCUMENTATION: 1. XML Settings File Creator Tool Description: The PowerShell/WinForms tool is designed to create an XML file based on a user input. … Continue reading Windows Server 2012R2 (Amazon EC2) Monitoring Solution + Salesforce REST API Integration →

Remote Desktop Manager (.NET/PowerShell/WinForms) DESCRIPTION: Leveraging Remote Desktop Services ActiveX controls via the AxInterop.MSTSCLib (an ActiveX COM Component) the tool allows access and monitoring multiple remote computers simultaneously. It automatically runs test automation software when selected user logs on.

Dynamics AX Missing Index Recommender Tool (Excel\PowerShell\Winforms) DESCRIPTION: Runs Dynamics AX database indexes check and provides hints and recommendations based on SQL Server Data Tuning Advisor Engine. EXAMPLE OUTPUT: Missing_Indexes

SQL Statement Creator (PowerShell/WinForms/Regex)  

XML Splitter GUI Tool (PowerShell/WinForms) DESCRIPTION: Splits XML file based of number of lines preserving the XML structure for each segmented file.

Database Documenter for SQL Server Tool (SQL/PowerShell/WinForms) DESCRIPTION: Automatically generates documentation of an entire SQL Server database. Exports in HTML format every SQL object including tables, views, stored procedures, columns, indexes, foreign keys, etc. Additionally with MS_Description properties supported Extended Properties Editor can add annotations to tables and columns. Example of SQL database table output file: … Continue reading Database Documenter for SQL Server + Extended Properties Editor →

Requirements: Audit script that upon a recognized event, sends notifications to given email address with the relevant alert. The script is run thru an interface using the continuum portal (https://www.continuum.net/) , to a series of customers who have Windows computers.  Access to this portal will be provided. The script will leave a text file (xml … Continue reading PowerShell Audit Script Managed by Continuum Portal →

1.    Overview The SQL/PowerShell automation procedure is designed to perform off-site archiving of local SQL Server full and log backups in the form of compressed and encrypted files (7zip) which are being uploaded to Amazon Simple Storage Service (Amazon S3). 2.    Native Backup SQL Agent Jobs The SQL native backup process consists of the following … Continue reading Secure SQL Database Backups and Logs Synchronization with Amazon Simple Storage Service (S3) →

Variable for a list of servers. #Server array $Serverlist = “WORK01”, “WORK02”, “WORK06”  The script will perform a check if the listed servers accept WinRM connections (used for the remoting). The ones which fail will be reported and excluded from the further action. 3.  Clear the full Windows Eventlog of the servers. 4. Force Restart … Continue reading PowerShell script to clear Event Log on remote machines in parallel (WinRM) →

DiskSPD GUI Tool (PowerShell/Winforms/Microsoft DiskSPD) DESCRIPTION: DiskSpd is a highly customizable I/O load generator tool that can be used to run storage performance tests against files, partitions, or physical disks. DiskSpd can generate a wide variety of disk request patterns for use in analyzing and diagnosing storage performance issues, without running a full end-to-end workload. … Continue reading DiskSPD GUI – Storage Performance Tool →

GeekBench GUI Tool (PowerShell/Winforms/CMD Utility) DESCRIPTION: Geekbench GUI Tool compares system performance across devices, processor architectures, and operating systems. 1. Deploys the Geekbench ZIP file to the remote computers using PowerShell remoting (instead of traditional file copying,  it copies files over a PSSession to multiple computers simultaneously). 2. Unzips the archive on the remote machine … Continue reading GeekBench GUI Tool – Cross-Platform Benchmark →

NetIO GUI Tool (PowerShell/Winforms/CMD Utility) DESCRIPTION: NetIOGUI measures the throughput of a network via TCP and UDP protocols using various different packet sizes. It uses PowerShell Remoting to deploy a command line instance on multiple target machines and run it as a server process, where another instance is running on the source machine to perform the … Continue reading NetIOGUI – Network Benchmark Tool →

SQL/Dynamics AX/Windows discovery GUI Tool (Windows PowerShell/WinForms) Server Discovery Wizard Collects detailed information on a SQL instance such as SQL Server configuration, memory utilization, database settings, service accounts, network protocols, log size, etc. Inspects the configuration settings of the hosted server hardware such as OS version, storage, network, virtual machine provider, etc. Discovers other instances … Continue reading SQL/Dynamics AX/Windows discovery GUI Tool (Windows PowerShell/WinForms) →