Month: July 2011

PoshUtils: Get-DBSize – Get SQL Database space usage

Here is an improved version of the script I am using to get the database space usage details. This is one of the utility scripts I have been using and will be publishing soon as PoshUtils on Codeplex. For this script to work, you need the SQL Management Object (SMO) assemblies. These assemblies are available on systems with SQL server installed or where SQL management tools are installed.

Here are some examples:

This gets the database space usage details for all databases on a SQL server named Server01.

The above example gets the space usage details for TestDB1 and TestDB2 on  a SQL Server named Server02.

This last example get the space usage details for TestDB1 and TestDB2 on the local SQL server. And, finally, you can avoid all parameters to get space usage for all databases on the local SQL Server. Here is how the output looks:

A simple PowerShell script explorer addon using ShowUI

Update: The select-ViaUI function is no more in ShowUI module starting version 1.2. So, if you plan to run this, you need to go back to ShowUI 1.1. Okay, there is nothing really fancy here. This is all done in just ten lines of PowerShell code. In fact, only 3 lines for the real logic. I am not even creating my own UI to do this. This is all done using the Select-ViaUI cmdlet in ShowUI module. Here is how it looks: So, within this addon, I list all ps1, psm1, and xml files at a pre-defined location. At the bottom, you see a search box. If you find it difficult to scroll to the item you want, you can just type the name ( or partial name) and filter the list. Once you select the item, just click OK to open that file(s) in ISE. Simple! Here is the code:

Just execute the above code or add the above code to your ISE profile and restart ISE. Now, when you press Ctrl+Alt+E, this …

PowerShell ISE addon menu generator – The ShowUI way

Update: @Jaykul was kind enough to review this code and post an updated (and better) version of this addon with guidelines & best practices. Don’t forget to read the first few lines of text on that page to learn the best practices when scripting WPF UI. A while ago, I wrote about a PowerShell ISE addon that can be used to add items to ISE and load them dynamically by adding the same to ISE profile. This used WinForms to generate the GUI required for the addon functionality. As you may know already, ShowUI 1.1 is available for creating WPF UI in PowerShell. So, I decided to re-write this addon to use ShowUI. Here is the new code:

The WinForms implementation of this addon had 235 lines of PowerShell code. Where as, ShowUI version has only 48 lines! This shows that the value per line of PowerShell code is amazing when using ShowUI. ShowUI really makes it easy. Thanks to James Brundage and Joel Bennett. Now, to use this addon: Copy the contents of above script …

Windows PowerShell MVP for another year

I just got the email from Microsoft saying I’ve been renewed for 2nd year as Windows PowerShell MVP. Nice way to end the day! Dear Ravikanth C, Congratulations! We are pleased to present you with the 2011 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in PowerShell technical communities during the past year. The Microsoft MVP Award provides us the unique opportunity to celebrate and honor your significant contributions and say “Thank you for your technical leadership.” Toby Richards General Manager Community & Online Support