Powershell Jumpstart for SQL Server DBAs

[Pages:25]POWERSHELL JUMPSTART FOR SQL SERVER DBAS

Mike Fal -

Mike Fal -

Ground Rules

Don't focus on the code, focus on the concepts. Ask questions!

Mike Fal -

Get-Agenda

The What and Why of Powershell Language Basics

Working with SQL Server And Then What?

Mike Fal -

What is Powershell?

Mike Fal -

The Facts

Released as Powershell RC 1 ? April 2006 Originally called Project "Monad" Current available version: 4.0

(5.0 preview available)

Mike Fal -

But for what?

Mike Fal -

Why PowerShell?

.NET Libraries

PowerShell

SQL Server

File System Operating

System

Invoke-SqlCmd -ServerInstance $srvr -Query "BACKUP DATABASE $db TO DISK=`'$backuplocation`'"

Mike Fal -

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download