Sean McCown Microsoft SQL MVP

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.

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.

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.

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.

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.

Sean McCown takes us beyond the basics of scripting database objects in PowerShell. This article explains how to set advanced scripting options using SMO.

A step-by-step guide covering the basics of scripting database objects in PowerShell by Sean McCown. With PowerShell you can easily script all the objects in your database manually, or schedule the scripting anytime you’d like, and for as many of your servers as you’d like.

Sean McCown discusses moving database files in SQL Server with the Detach/Attach method. Includes discussion of restrictions and implications to be aware of when detaching a database.

Sean McCown discusses moving database files in SQL Server by taking the database offline, in his opinion on the simplest, most flexible, and least invasive method.

This is one of those database topics that sounds really easy on its face but can be tricky in practice. The issue is how to gain exclusive access to a database so you can perform operations like taking it offline, etc. MVP Sean McCown explains what’s involved and the benefits of each method.