Prashanth Jayaram

Technology enthusiast with 7+ years of experience in Database Technology. I am Microsoft Certified Professional with certificates of OCA, MCP, MCTS, MCITP developer, MCITP administration and backed with a degree in Master of Computer Application. My expertise lies in T-SQL programming, Replication, PowerShell and Performance Tuning. Hobbies are Drawing, playing soccer and listening to Melodies songs.

All authors

PowerShell- Monitoring Group Of Services on Group of Servers with Alternate Credential

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This post explains how to monitor a multiple services on a group of servers with alternate credentials.
This script will allow...

2014-07-03

709 reads

PowerShell – Perfmon Counters into CSV File – Multiple remote servers

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Introduction
This script can be used for exporting specified performance counter values from multiple remote target servers to CSV file. The...

2014-06-10

1,544 reads

PowerShell – Perfmon Counters into CSV File – Multiple remote servers

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Introduction
This script can be used for exporting specified performance counter values from multiple remote target servers to CSV file. The...

2014-06-10

638 reads

PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This script is used to discover all the server information and captures disk drive utilization details. The drive details are...

2014-05-21

1,208 reads

PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This script is used to discover all the server information and captures disk drive utilization details. The drive details are...

2014-05-21

572 reads

SQL – List All Tables, Space Usage Info & Other Details

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

One of the OP requested in the forum to find all table details of any database. The details which includes Number...

2014-05-01

578 reads

SQL – List All Tables, Space Usage Info & Other Details

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

One of the OP requested in the forum to find all table details of any database. The details which includes Number...

2014-05-01

1,092 reads

PowerShell-Input-Validation Scripts

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell...

2014-04-28

771 reads

PowerShell-Input-Validation Scripts

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell...

2014-04-28

2,017 reads

SQL – Find encrypted objects using sql_modules or Powershell

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

sys.sql_modules catalog view which got introduced from SQL 2005 onwards. The sql_modules which includes the objects of type P, RF, V, TR, FN, IF, TF,...

2014-04-14

848 reads

All authors

Prashanth Jayaram

PowerShell- Monitoring Group Of Services on Group of Servers with Alternate Credential

PowerShell – Perfmon Counters into CSV File – Multiple remote servers

PowerShell – Perfmon Counters into CSV File – Multiple remote servers

PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL

PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL

SQL – List All Tables, Space Usage Info & Other Details

SQL – List All Tables, Space Usage Info & Other Details

PowerShell-Input-Validation Scripts

PowerShell-Input-Validation Scripts

SQL – Find encrypted objects using sql_modules or Powershell

Blogs

Installing and Configuring containerd as a Kubernetes Container Runtime

It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11

Car Update October 2026

Forums

Alamat Telp BCA KCP Citra 2 Ext +62 838-4945-0961

Alamat BCA KCP Duta Gardenia +62 838-4945-0961

Layanan Resmi BCA KCU A. YANI Telp:0821°8200°203

Question of the Day

SQL Server Vector Support II