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

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

757 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

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

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