Last Update: Jun 12, 2023
Designing a backup strategy in SQL is fairly straightforward, but it can get complicated when you’ve got a lot of moving pieces in your scenario. Sean McCown, Microsoft SQL MVP, takes the readers through the “best” practices to follow.
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.