Powershell for SQL Archives - SQLChamp

Powershell for SQL

Where are my system databases?

July 14, 2012 Sarabpreet Singh Anand dir, force, SQL Server system databases, system databases, using force switch with get-childitem

Hi Friends, In last post, we saw that we can very easily use powershell to connect to SQL Server instance

Powershell for SQL

How to Connect to SQL Server using Powershell

July 13, 2012 Sarabpreet Singh Anand connect to SQL, how to connect to database using powershell, Server, sqlps

Hi Friends, In this blog I’ll show you how to connect to SQL Server using Powershell Step-by-Step. There are basically

Powershell for SQL Powershell-Basics

Quotes in Powershell

July 8, 2012 Sarabpreet Singh Anand `, `n, `t, Back quote, back tick, Double Quote, Horizontal Tab, New line, posh, powershell, ps, Quotes, Single Quote, variable expansion

In General Quotes are considered to be there just to let interpreter know that the value enclosed within quotes should

Powershell for SQL

SQL Server Management Objects (SMO)

July 6, 2012 Sarabpreet Singh Anand SMO, SMO compatible, SMO dependency, SQL

SMO is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. SQL Server

Powershell for SQL

SQL with its own Powershell?

July 6, 2012 Sarabpreet Singh Anand powershell, snappin, SQL, sqlps

SQL Server 2008 and powershell are strongly integrated. In fact, SQL Server 2008 comes with its own Powershell. Microsoft SQL