Tag Archives: sqlps

How to Connect to SQL Server using Powershell

Hi Friends, In this blog I’ll show you how to connect to SQL Server using Powershell Step-by-Step. There are basically two ways to connect to SQL Server, A. Using sqlps utility from Powershell.exe B. Using SSMS context menu option   Let’s review both: 1. Go to command prompt\cmd and type Powershell.exe & press enter. This …

SQL with its own Powershell?

SQL Server 2008 and powershell are strongly integrated. In fact, SQL Server 2008 comes with its own Powershell. Microsoft SQL Server Powershell also known as SQLPS is basically a custom shell built to be used just for SQL Server. SQLPS comes preconfigured with all SQL Server extensions. Technically speaking SQLPS is a mini-custom-powershell which has …