PowerSQL By Prashanth Jayaram
Archives: January 2014
PowerShell – Memory Details GUI Tool
This Powershell Memory GUI tool is used to fetch memory information from a computer. In the screen that follows, enter the computer name that you would like to get the memory details for and click on Get Memory Button.
This pulls out the usage of memory of the listed computer.… Read more
1 comments, 2,449 reads
Posted in PowerSQL By Prashanth Jayaram on 27 January 2014
PowerShell – Program List – 32/64 Bit – Local/Remote Machies
This Powershell script list all the installed application on both 32 and 64 bit applications, particularly useful for people managing both 32-bit and 64-bit applications. This code also contains an exclusion array where you can exclude list of program that you don’t want to show.
- The function allows -ComputerName parameter…
10 comments, 906 reads
Posted in PowerSQL By Prashanth Jayaram on 20 January 2014
T-SQL to check Data and Log Files are on same drive or not
The below query help us in finding the physical existence of data and log files are on same drive or not of all the database in a SQL Instance.
;WITH LogCTE AS ( SELECT DISTINCT LD.Database_Name FROM ( SELECT DB_NAME(database_id) AS [Database_Name], LEFT(Physical_Name, 1) AS [Drive_Letter] FROM sys.master_files WHERE type_desc…
0 comments, 533 reads
Posted in PowerSQL By Prashanth Jayaram on 13 January 2014
T-SQL – Monitoring DiskSpace of Multiple Servers
This post talks about step by step approach to capture the disk space using T-SQL. This is a request from one of SQL enthusiast. The requirement is to do with T-SQL to monitor disk space of remote servers.
Pre-requisites are
- Enable XP_CMDShell
- Enable Ole automation on all servers
Step by… Read more
3 comments, 649 reads
Posted in PowerSQL By Prashanth Jayaram on 10 January 2014
SSRS – Identify a scheduled SSRS Report
Initiating subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a SQL Server Agent job, but the job names are Unique Identifier its hard to remember and re-call. Have complete information in single query makes one easy to validate and execute… Read more
1 comments, 606 reads
Posted in PowerSQL By Prashanth Jayaram on 10 January 2014
SQL- Useful links
Useful links – I hope you might like it too..
http://www.sqlskills.com/blogs/paul/sqlskills-holiday-gift-to-you-all-2012-insider-videos/
0 comments, 556 reads
Posted in PowerSQL By Prashanth Jayaram on 8 January 2014
Powershell – Age of File Report – Local or Remote
Here’s a very quick post by request.I just had a request for searching the file system for files matching certain criteria such as file age based on the date created. The function Get-FileAgingReport uses get-childitem cmdlet. This function uses two mandatory input parameters Computername and Folder Path.The function is validated… Read more
0 comments, 1,449 reads
Posted in PowerSQL By Prashanth Jayaram on 8 January 2014
PowerShell – Find OS architecture (32 bit or 64 bit) of local or remote machines Using Powershell
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 size of this instance. The value of this property is 4 in a 32-bit process, and 8 in a… Read more
2 comments, 1,855 reads
Posted in PowerSQL By Prashanth Jayaram on 6 January 2014