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 – 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

739 reads

First Birthday to My Blog

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...

2014-04-10

311 reads

First Birthday to My Blog

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...

2014-04-10

548 reads

PowerShell GUI Tool – Network Ping – Version 2

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...

2014-04-02

1,622 reads

PowerShell GUI Tool – Network Ping – Version 2

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...

2014-04-02

548 reads

PowerShell – System Information

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Different ways to find system information are given below:-
Method 1:Querying WMI objectsDownload the code SystemInfoCreate the function with Powershell console...

2014-03-17

656 reads

PowerShell – System Information

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Different ways to find system information are given below:-
Method 1:Querying WMI objectsDownload the code SystemInfoCreate the function with Powershell console...

2014-03-17

1,571 reads

SQL Jobs – Complete Information – SQL 2000/2005/2008/R2

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns...

2014-03-11

772 reads

SQL Jobs – Complete Information – SQL 2000/2005/2008/R2

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns...

2014-03-11

411 reads

SQL – Backup Report

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...

2014-03-05

505 reads

All authors

Prashanth Jayaram

SQL – Find encrypted objects using sql_modules or Powershell

First Birthday to My Blog

First Birthday to My Blog

PowerShell GUI Tool – Network Ping – Version 2

PowerShell GUI Tool – Network Ping – Version 2

PowerShell – System Information

PowerShell – System Information

SQL Jobs – Complete Information – SQL 2000/2005/2008/R2

SQL Jobs – Complete Information – SQL 2000/2005/2008/R2

SQL – Backup Report

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