Using a PowerShell Script to delete old files for SQL Server

Many clients are using custom stored procedures or third party tools to backup databases in production environments instead of using database maintenance plans. One of the things that you need to do is to maintain the number of backup files that exist on disk, so you don't run out of disk space. There are several techniques for deleting old files, but in this tip I show how this can be done using PowerShell.

Create Normalised Databases with Powershell

Database creation with powershell SMO objects

Introduction into handling errors in PowerShell for SQL Server tasks

PowerShell is becoming a great tool for managing SQL Server tasks, but like most tasks that are coded there is always the need for error handling to deal with the unknown. PowerShell has several options for handling and capturing error details and in this tip we will explain these options using PowerShell for SQL Server examples.

The PoSh DBA: Grown-Up PowerShell Functions

Laerte Junior goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing how pipelines and advanced functions can make PowerShell more effective in helping to automate many of the working DBA's chores.

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes

YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.

Perform Routine Server Checks Using PowerShell

Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.

Scripting SQL jobs using PowerShell

Using powershell to create different sql scripts in different files.

Microsoft SQL Server 2012 - (SQLPS)

Prior to SQL Server 2012, Microsoft provided a mini shell called sqlps.exe; in SQL Server 2012, SQLPS exists in the form of module. Learn how to make use of the SQLPS module and how to access SQL Server components and features via Windows PowerShell.

A Demo of the Power of Powershell

This demo will show you the how powerfull is powershell. We will use cicles and the get-content command.

Working with Perfmon CSV logs in Powershell

When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.