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

698 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,531 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

627 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,202 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

562 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

570 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,079 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

760 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,003 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

821 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

Programmatically Retrieving MLV Lineage and Refresh Times

SWAG Saves the Day

Upgrading SQL Server Containers on the Laptop

Forums

BCA KCP Semanggi Telpon/WA:08137887595

BCA KCP GAMA Telpon/WA:08137887595

BCA KCP Palmerah Telpon/WA:08137887595

Question of the Day

Increase Deadlock Detection