Monthly Archives: February 2014

PowerShell – SSRS Inventory – Automatic – Excel File – EMAIL

Posted on February 27, 2014 by Prashanth Jayaram

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage. Download the file and save as SSRSInventory.PS1. It has five mandatory parameters InputFileName – Text File … Continue reading →

Posted in PowerShell, SQL, SSRS | Tagged , , , | Leave a comment

PowerShell – Export SQL Data to Excel with Powershell

Posted on February 24, 2014 by Prashanth Jayaram

SQL Server  Export  to Excel with Powershell is very useful for all sorts of activities – ETL and reporting are some examples. This post is to Export SQL Data to Excel with Powershell.In this example, a connection is made to … Continue reading →

Posted in T-SQL | Tagged , , , , | 5 Comments

PowerShellGUI Tools – Disk,Memory and Process – Modules

Posted on February 20, 2014 by Prashanth Jayaram

I’ve created a script which gives details of Disk, Memory and Process and its represented graphically. Here, the scripts are enclosed in module. At its simplest, a module is just a PowerShell script, contained in a file with a .PSM1 extension A module … Continue reading →

Posted in PowerShell | Tagged , , , , , , , | Leave a comment

Top 10 Process Listing By Memory Consumption – GUI Tool

Posted on February 7, 2014 by Prashanth Jayaram

This Powershell GUI tool is used to list Top 10 memory consumption process of a given computer[local /Remote]. In the screen that follows, enter the computer name that you would like to get the top 10 processes and hit Get … Continue reading →

Posted in PowerShell | Tagged , , , | 2 Comments

PowerShell – SQL Inventory – Automatic – Excel File – EMAIL

Posted on February 4, 2014 by Prashanth Jayaram

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage. Download the file and save as SQLInventoryExcel.PS1. It has Five mandatory parameters InputFileName – Text File … Continue reading →

Posted in PowerShell, SQL | Tagged , , , | 7 Comments