Category Archives: SQL Server

About SQL Server.

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

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

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

SQL Saturday #86 Tampa BI edition: SSIS – Analyzing your data integrating PowerShell session

Posted on October 21, 2011 by admin

I’m excited to bring this new topic to #SQLSat86 Tampa for the BI community.  So, here’s a brief rundown of what I will be covering on Saturday, November 5th morning session: Topic: SSIS – Analyzing your data integrating PowerShell *Note: … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

PowerShell working with SQLPS or SMO…

Posted on September 22, 2011 by admin

Today, while help @meltondba with his SQLPS question on the enumerating jobs history, @LaerteSQLDBA provided a oneliner to provide this result.  There’s one concern, should we use SQLPS instead of SMO.   For this answer I’m going to point out MSDN article regrading … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

No-Hassle SQL Server Remoting with PowerShell V2

Posted on September 6, 2011 by admin

Although, PowerShell give the whole remoting experience, you may still need to ask you network administrator to let you configure remoting on all the machines you need to access.  Of course, unless you hold the keys of the kingdom.  But, it … Continue reading →

Posted in PowerShell, SQL Server | Comments Off