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

T-SQL to check Data and Log Files are on same drive or not

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

The below query help us in finding the physical existence of data and log files are on same drive or...

2014-01-13

630 reads

SSRS – Identify a scheduled SSRS Report

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Initiating subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a...

2014-01-10

687 reads

T-SQL – Monitoring DiskSpace of Multiple Servers

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

This post talks about step by step approach to capture the disk space using T-SQL. This is a request from...

2014-01-10

758 reads

Powershell – Age of File Report – Local or Remote

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Here’s a very quick post by request.I just had a request for searching the file system for files matching certain...

2014-01-08

1,653 reads

SQL- Useful links

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Useful links – I hope you might like it too..
http://www.sqlskills.com/blogs/paul/sqlskills-holiday-gift-to-you-all-2012-insider-videos/

2014-01-08

614 reads

PowerShell – Find OS architecture (32 bit or 64 bit) of local or remote machines Using Powershell

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Method 1: Environment Variable
PS:\>$ENV:PROCESSOR_ARCHITECTURE
Method 2: Using Win32_OperatingSystem
ps:\>$computername=’abcd’
ps:\>(Get-WmiObject Win32_OperatingSystem -computername $computername).OSArchitecture
Method 3: Using Win32_Processor
ps:\>$computername=’abcd’
ps:\>Get-WmiObject -Class Win32_Processor -ComputerName $ComputerName| Select-Object AddressWidth
Method 4:[IntPtr]::Size - Gets the...

2014-01-06

2,150 reads