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

SQL – One Query to fetch SQL Jobs Details of All SQL Version – 2000/05/08/R2

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Single Query to fetch complete details of sql jobs and you can run it across different version of SQL [2000/2005/2008...

2013-08-12

8,162 reads

SQL – Find Database File Usage Details – 2000/05/08/R2

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This post is to find the database file usage details of all databases of an instance. The query runs on...

2013-08-06

1,921 reads

SQL – Query to find data,log,Total Size and other Useful information of all databases – SQL 2000/2005/2008/R2

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

I’ve encountered a situation where I need to find out the database file,log file, total size and other useful information...

2013-07-25

4,595 reads

PowerShell – Identify and switch between installed PowerShell Versions

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Most of the time we have been used to cmdlets and it’s various features but do not know about the...

2013-07-17

1,415 reads

PowerShell – Get CPU Details and its Usage

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This PowerShell script helpful in finding No of Processors, Speed and It’s current usage based on samples being gathered at...

2013-07-11

1,659 reads

PowerSQL – Find OS and Memory Usage Details – Multi Server Script – No Input files

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Multi Server script to find OS and Memory details. It doesn’t require a text file as its input but you...

2013-07-09

907 reads

SQLCMD –Quick Copy of Files – Using Robocopy

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

The requirement is to move the files to different server programatically and hence I’ve decided to use Robocopy in SQLCMD.
Robocopy...

2013-07-05

1,991 reads

PowerSQL – SQL Instance Configuration & Installation Information by Reading Registry Keys

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Today I got a chance to retrieve configuration information of sql server 2005 instances. PowerShell provide a facility to read...

2013-07-02

1,134 reads

PowerSQL – Different Approaches to Find Free Space in all disk drives

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Different ways to find FreeSpace in all disk drives of a given server
T-SQLUsing WMIObjectCountersAll three methods are explained below
This post...

2013-06-27

1,509 reads

SQL- SP_PROCOPTION – AutoNotification to App Owners – When SQL Instance Restarts

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

We had a situation where Application owners automatically notified whenever server restarts. The SP_PROCOPTION do have a facility to perform...

2013-06-24

1,597 reads

All authors

Prashanth Jayaram

SQL – One Query to fetch SQL Jobs Details of All SQL Version – 2000/05/08/R2

SQL – Find Database File Usage Details – 2000/05/08/R2

SQL – Query to find data,log,Total Size and other Useful information of all databases – SQL 2000/2005/2008/R2

PowerShell – Identify and switch between installed PowerShell Versions

PowerShell – Get CPU Details and its Usage

PowerSQL – Find OS and Memory Usage Details – Multi Server Script – No Input files

SQLCMD –Quick Copy of Files – Using Robocopy

PowerSQL – SQL Instance Configuration & Installation Information by Reading Registry Keys

PowerSQL – Different Approaches to Find Free Space in all disk drives

SQL- SP_PROCOPTION – AutoNotification to App Owners – When SQL Instance Restarts

Blogs

Claude AI Convinced Me Not to Build an iPad App

A New Word: Dolorblindness

Claude Code Helps Analyze Test Data Manager Log Files

Forums

Data Warehouse Toolkit meets Star Schema: The Complete Reference

GPX distance and time analysis in SQL Server

The DBA is Dead; Long Live the DBA

Question of the Day

Changing the AG Listener