Powershell for SQL Archives - SQLChamp

Sunday, December 10, 2023

Latest:

SQLChamp

Let's learn together!

Powershell for SQL

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

Where are my system databases?

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

Powershell for SQL

Sarabpreet Singh Anand July 13, 2012 connect to SQL, how to connect to database using powershell, Server, 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

Powershell for SQL Powershell-Basics

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

Quotes in Powershell

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

Powershell for SQL

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

SQL Server Management Objects (SMO)

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

Powershell for SQL

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

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