A while ago I blogged about using xp_cmdshell to execute a PowerShell script in SQL Server and return a result set. At that time I was using PowerShell V1, but now with PowerShell V2 I can clean this up a little. The improved version uses the built-in PowerShell V2 cmdlet… Read more

Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to run. The various execution policy settings are described in about_Execution_Policies. Run Get-Help about_execution_policies or see the online version for additional information.

The default setting for the execution policy is restricted… Read more

As part of the 2.3 build of SQLPSX I built an MSI based installer to package all 10 SQLPSX modules. The installer was created with Windows XML Installer (Wix). To build an MSI using Wix you manually edit XML files and run several command-line tool to generate the necessary files.… Read more

I run several SQL Server instances on my laptop, however I’ll keep the services shutdown to conserve resources and then start up the instance when needed. Doing this type of stuff through the GUI results in several clicks

1. Right click on SQL instance in SSMS
2. Select Service Control >> Start…

Read more

Just in time for PASS Summit 2010, the CodePlex project SQL Server PowerShell Extensions (SQLPSX) has been updated . Here’s a rundown of what’s new in release 2.3…

Added MSI-based installer

The installer was built using the Windows Installer XML (WiX) and this was an… Read more

Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off a SQL Server week (Nov 1st 2010) with my guest blog post. The post, Use PowerShell to Collect Server Data and Write to SQL, demonstrates my number one use case for database related PowerShell activities—loading data… Read more