Learn how to get setup with PowerShell and SQLPSX from MVP Aaron Nelson, one of the experts teaching us how to use Powershell for SQL Server.  Read more...

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...

Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.  Read more...

At some point you are going to need a notification system for a range of events that occur in your servers. Laerte Junior shows how you can even set up temporary or permanent alerts for any WMI events to give you a system that fits your server environment perfectly.  Read more...

How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.  Read more...

If you're starting to learn PowerShell and want to see how you can use it for common DBA tasks, this tip will show you how to create a basic PowerShell script to backup all your user databases.  Read more...

Laerte Junior was asked for a quick and easy way to save the output from the Get-EventLog cmdlet in a SQL Server table. Luckily, he already knew about Chad Miller's excellent Out-DataTable and Write-DataTable functions, and has laid out everything we need to use them like pros.  Read more...

owerShell can be used to for many SQL administrative tasks; this tip walks through how to run T-SQL code and admin tasks on remote servers.  Read more...

Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.  Read more...

Often we face the situation where we need to check the total disk space and available disk space for both physical and LUN/Mount drives. See how this can be done using PowerShell.  Read more...

The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs.  Read more...

Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.  Read more...

With PowerShell in one hand, and WMI in the other, DBAs can do almost anything in their Window's environments, and Laerte Junior is using his powers for good. He built a highly precise, highly configurable alerting system for his servers, and now shows us exactly how he did it.  Read more...

For an experienced programmer to learn a new language can be a journey quite like Alice's in wonderland. Paradoxes, unexpected twists, blind tangents, bafflements and nice surprises. Michael Sorens comes to the rescue of anyone learning PowerShell with an explanation of how to use PowerShell functions.  Read more...

I want to determine who the local administrators are on each of my SQL Servers. Basically, I'd like a nightly job to run against each of my SQL Servers and produce a list of admins for each server for my review. How can I do this?   Read more...

This powershell script updates the server name specified in connections within a SQL 2005 SSIS package  Read more...

When you are first learning PowerShell, it often seems to be an 'Alice through the looking-glass' world. Just the simple process of comparing and selecting strings can seem strangely obtuse. Michael turns the looking-glass into wonderland with his wall-chart of the PowerShell string-comparison operators and syntax  Read more...

The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs. I will call this framework comprised of a library of modules and functions specialized to manage SQLServer the DBA profile.  Read more...

This article takes a look at how PowerShell can speed up the process of parsing large log files.  Read more...

Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.  Read more...