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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.