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 – Script to Monitor Disk Space of a Group of servers – HTML Formatted Email Output

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This post explains how to monitor DiskSpace of a group of listed servers in a text file.
The function Get-DiskSpaceReport comprises...

2013-10-01

4,399 reads

PowerShell – Restart Service – Local or Remote Machines

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This post is to start the services of local or remote computers. It also check for all its dependent services....

2013-09-23

1,583 reads

PowerShell – Script to Monitor a Service on a Group of servers – HTML Formatted Email Output

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This post explains how to monitor a given service on a group of servers. The function Get-ServiceStatusReport comprises of various cmdLets...

2013-09-19 (first published: 2013-09-17)

3,249 reads

PowerShell – List Local or Remote Programs with an Exclusion List of Programs

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This post is to list all the software installed on your local or remote machines. The exclusion list is an...

2013-09-16

1,269 reads

PowerShell – Uptime of Multiple Machines – Example for Custom Formatting and Grid View

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This post is to help you out in finding UpTime of one or more computers also you can pass file...

2013-09-09

917 reads

PowerShell – Delete Registry Entries – Remote Machines – Example Profile Deletion

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

#The following SID registry entry to be deleted across all mutiple Machines, SID is a user #who owns this user...

2013-09-06

2,659 reads

SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Find CPU, Memory, No Of Connections/databases and VLF’s and I/O details in one single script.
You just need to run the...

2013-09-03

1,640 reads

SQL – Identify & Drop Duplicate Index

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This post explains the simple steps to identify a duplicate indexes in all the databases. The duplicate index are more than...

2013-08-26

889 reads

SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of...

2013-08-19

4,440 reads

PowerShell – Invoke Commands,Batch files & Executable file – Dynamically passing Parameters

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

I’ve recently got a request to invoke an executable file from Powershell. Different ways of executing a executable file is given...

2013-08-14

1,141 reads

All authors

Prashanth Jayaram

PowerShell – Script to Monitor Disk Space of a Group of servers – HTML Formatted Email Output

PowerShell – Restart Service – Local or Remote Machines

PowerShell – Script to Monitor a Service on a Group of servers – HTML Formatted Email Output

PowerShell – List Local or Remote Programs with an Exclusion List of Programs

PowerShell – Uptime of Multiple Machines – Example for Custom Formatting and Grid View

PowerShell – Delete Registry Entries – Remote Machines – Example Profile Deletion

SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases

SQL – Identify & Drop Duplicate Index

SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method

PowerShell – Invoke Commands,Batch files & Executable file – Dynamically passing Parameters

Blogs

The Book of Redgate: SQL Server Central

Git forked

Setting FK Constraints in Data Modeler

Forums

Inspection And Auditing | FARE Labs Pvt. Ltd.

Microsoft Security Changes and SQL Server

Expanding into Print

Question of the Day

The String Distance I