Changing SQL Server Job Owners with PowerShell
Using PowerShell for changing job owners in SQL Server. Sean McCown demonstrates how PowerShell is a more efficient option than SSMS or T-SQL when changing job owners in bulk.
Jan 26, 2011
Finding What You Need in PowerShell
Sean McCown provides an overview of working with cmdlets in PowerShell. Covers how to run help on cmdlets, and search specific cmdlets to learn what's available in PowerShell, including the use of format-table and get-member to control how resulting information is displayed.
Jan 20, 2011
Overview of PowerShell basics by Sean McCown. PowerShell makes it possible for DBAs to easily manage multiple servers at once, often with very little coding. This article explains how PowerShell is organized, and how to get information about the different drives you work with.
Jan 17, 2011
Why Should DBAs Care About PowerShell?
Why Should DBAs Care About PowerShell? Sean McCown answers this question by demonstrating the simplicity of scripting in PowerShell, in contrast to T-SQL and VBScript, through a variety of real world examples.
Jan 13, 2011
Creating an Enterprise Scripting Template in PowerShell
Sean McCown builds upon past 2 PowerShell scripting articles (Scripting Database Objects in PowerShell & Scripting Database Objects with Advanced Options in PowerShell) to discuss how to build a scripting process which enables each object to be scripted to its own file.
Jan 7, 2011
Scripting Database Objects with Advanced Scripting Options in PowerShell
Sean McCown takes us beyond the basics of scripting database objects in PowerShell. This article explains how to set advanced scripting options using SMO.
Dec 30, 2010
Most popular on petri
Thank you to our petri.com site sponsors
Our sponsors help us keep our knowledge base free.