SQL Server

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

SQL Server

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

SQL Server

PowerShell Basics for DBAs

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

SQL Server

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

PowerShell

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

SQL Server

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