Browse by Tags

• sql

• PowerShell changes in SQL Server 2008 RC0

  Regular readers of my blog will remember my post about how to get PowerShell for SQL into your regular PowerShell window . Except that if you've just installed SQL Server 2008 RC0, you may have noticed it doesn't work any more. Never fear, they've Read More... Posted Thursday, June 12, 2008 12:48 PM from Rob Farley | (Comments Off) Filed under: powershell, SQL Server 2008

• SQL Server 2008 PowerShell SnapIn

  Installing SQL Server 2008 gives you SQLPS.exe, an application you can run which is a PowerShell including the PSDrives for SQL Server (and compatible with SQL Server 2005 as well!). But how do you make this work with your current copy of PowerShell? Read More... Posted Tuesday, March 04, 2008 9:17 AM from Rob Farley | (Comments Off) Filed under: sql, powershell, SQL Server 2008

• Using ScriptingOptions with SQLPS

  I've written before that SQL Server 2008 (February CTP) gives you SQLPS - a PowerShell interface to SQL Server. So I was trying to get the ScriptingOptions happening, and this is the only way I've found so far. It's ugly, and if you have a Read More... Posted Tuesday, March 04, 2008 8:53 AM from Rob Farley | (Comments Off) Filed under: sql, powershell, SQL Server 2008

• SQL Server 2008 CTP6 gives you PowerShell

  The sixth CTP of SQL Server 2008, made available this past week at http://connect.microsoft.com/sql provides a PowerShell provider for SQL Server, which is backwards compatible with SQL Server 2005 as well. I showed it a little at the User Group in Melbourne Read More... Posted Saturday, February 23, 2008 4:00 PM from Rob Farley | (Comments Off) Filed under: powershell, SQL Server 2008