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.

Automated Script-generation with Powershell and SMO

Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.