Category Archives: PowerShell

About PowerShell.

PowerShell quick list of SQL Users with SysAdmin Role

Posted on February 3, 2012 by admin

Here’s a quick way to start getting a list of SQL Server users having “SysAdmin” Role.  Basically, I’m using SQLPS module (now available with SQL Server 2012) which loads all the SMO needed to help you script against your SQL … Continue reading →

Posted in Office, PowerShell, SQL Server | Comments Off

QuickBlog – Use PowerShell to submit SQLServicePack job to multiple Server

Posted on January 25, 2012 by admin

This was an interesting discussion in the LinkedIn “How to Install SQL Service Pack by PowerShell?”.  I got the chance to create and test this one out. I scratched the previous script I posted trying to show probe a concept, and … Continue reading →

Posted in PowerShell, SQL Server, Windows 8 | Comments Off

PowerShell – Trap cmdlet errors.

Posted on December 29, 2011 by admin

Sometimes working with data can be challenging.  As a SQL Developer, creating ETL solutions, is our responsibility all this data makes it to our users.  Sometime data manipulation might be limited in SSIS, we are force to look for other … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

PowerShell – Sum items in a CSV file.

Posted on December 21, 2011 by admin

The fact that PowerShell gives you the ability to a build tasks in many different ways, it’s sometimes intimidating.  But, you’ll find the way to improve your coding as time goes.  I try, the best I can, to keep things simple. So, … Continue reading →

Posted in PowerShell | Comments Off

QuickBlog – Finding a value in a PowerShell Hash table – Simple!!

Posted on December 16, 2011 by admin

For this quick blog, let’s create a month hash object table containing the number and name of the month.  Then, we are going to query this Hash Table object for a specific month. 1. Creating our Month Hash Table: Notice in this … Continue reading →

Posted in PowerShell | Comments Off

SQLPASS PowerShell Virtual Chapter – “Extending T-SQL with PowerShell” Posted Slides & Scripts..

Posted on December 5, 2011 by admin

For all whom attended the SQLPASS PowerShell Virtual Chapter – “Extending Your T-SQL Scripting with PowerShell” session on Wednesday November 16th, I finally got it posted here. My sincere Apologies for the long delay in posting my session slides and … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

YES!! Windows Management Framework (WMF/PowerShell) 3.0 CTP2 is here.

Posted on December 3, 2011 by admin

YES!!  It’s another great accomplishment from the Microsoft PowerShell Team.  Just released on December 2nd 2011 this CTP (Community Technology Preview) come with fixes and more enhancements.  Please CHECK out PowerShell ISE, is really showing some progress. Get it here: http://www.microsoft.com/download/en/details.aspx?id=27548 … Continue reading →

Posted in Hyper-V, PowerShell, Windows 8 | Comments Off

Windows 8 Hyper-V 3.0 – My Personal 8 Tips for the Newbie

Posted on October 31, 2011 by admin

Well, Here’s some tips to those who are first timers with Windows 8 Server (or Client) Preview edition.  I have to say, after been using the previous version of Hyper-V, I’m very happy for what i’ve seen so far in … Continue reading →

Posted in Hyper-V, PowerShell, SQL Server, Windows 8 | Comments Off

SQL Server PowerShell SMO – Simple way to Change SQL User Passwords

Posted on October 28, 2011 by admin

Here’s a simple PowerShell SMO code that shows you How-To change a SQL user password.  Keep in mind, SMO needs to be installed and the assemblies loaded before using this code. To load SMO, you can: 1. Install the SQLPS Module … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

Creating a Standalone Windows 8 Server Virtual Machine with SQL Server 2012 CTP3

Posted on October 24, 2011 by admin

Here’s how I build my version of a standalone workgroup Windows 8 Server Virtual Machine(VM) with SQL Server 2012 (“Denal;i”) CTP3. When you create this VM, make sure to give enough memory. How-To create a VM in Hyper-V Manager console: I’m not … Continue reading →

Posted in Hyper-V, PowerShell, SQL Server, Windows 8 | Comments Off