More PowerShell Variables

Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services

Learn how to monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services

Cloning all the Databases on a Server

Phil Factor shows uses SQL Clone and PowerShell to automatically create images of all databases on an instance, if they don't already exist, and then create or refresh clones of each one, on all your development servers.

Comments and More in PowerShell

Comments are helpful when programming in any language, and PowerShell is no exception. In this article, Greg Moore demonstrates how to use comments to document code and to add prerequisites in PowerShell with #Requires.

Portable Objects in PowerShell with CLIXML

PowerShell is a widely used tool for administrator...

Building a Countdown Timer with PowerShell

Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that can create a window for a countdown timer.

Exporting Data with PowerShell

Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a short tutorial on exporting data from SQL Server […]

The directory creation time

The PowerShell String

SQL Clone PowerShell Scripting: The Basics

Phil Factor demonstrates some simple examples of how to use SQL Clone's PowerShell library to pass objects between cmdlets, and simplify common tasks, such as creating and deploying clones from various images. He then documents the objects and cmdlets, and illustrates their inputs and outputs.