SQLServerCentral.com Articles tagged powershell

Powershell Database Backup Script

Fri, 17 May 2013 06:00:00 UT

Learn how to write a script for regular database backups using Powershell and SMO.

Monitor SQL Instance Balance across Windows Cluster Nodes Using PowerShell

Fri, 03 May 2013 06:00:00 UT

This tip will demonstrate how to monitor SQL Failover Cluster Instances if they become unbalanced using Windows PowerShell.

Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks

Mon, 25 Mar 2013 06:00:00 UT

You should be on your way with PowerShell with the previous levels and now the topic shifts to using Functions and Assemblies built in to .NET for use with automation. This topic will be used in your PowerShell adventures throughout your career and this Stairway.

PowerShell Basics

Fri, 22 Feb 2013 07:00:00 UT

Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.

SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell

Thu, 31 Jan 2013 07:00:00 UT

Marcin Policht presents the fundamental principles of PowerShell in the context of SQL Server 2012. Join him as he steps through its initial setup and configuration, and reviews specific management areas where its advantages can be realized.

The PoSh DBA: Solutions using PowerShell and SQL Server

Mon, 29 Oct 2012 06:00:00 UT

PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much more than getting information from SQL Server instances via PowerShell; it can also be run from SQL Server as part of a system that helps with administrative and monitoring tasks.

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

Mon, 22 Oct 2012 06:00:00 UT

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.

Manage By Delegation

Wed, 17 Oct 2012 06:00:00 UT

There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Check SQL Server Virtual Log Files Using PowerShell

Thu, 11 Oct 2012 06:00:00 UT

In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution?

PowerShell script to find files that are consuming the most disk space

Wed, 10 Oct 2012 06:00:00 UT

As you know, SQL Server databases and backup files can take up a lot of disk space. When disk is running low and you need to troubleshoot disk space issues, the first thing to do is to find large files that are consuming disk space. In this article I will show you a PowerShell script that you can use to find large files on your disks.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Practical PowerShell for SQL Server Developers and DBAs – Part 2

Fri, 07 Sep 2012 06:00:00 UT

Having shown just how useful PowerShell can be for DBAs in executing queries, Michael Sorens now takes us through navigating SQL Server space and finding meta-information - valuable information for anyone looking to be more productive in SQL Server.

Stairway to SQL PowerShell Level 3: Input and Output with PowerShell

Wed, 29 Aug 2012 06:00:00 UT

This level will cover some of the Input/Output operations you can use with PowerShell.

Practical PowerShell for SQL Server Developers and DBAs – Part 1

Mon, 27 Aug 2012 06:00:00 UT

There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS and the newer SQLPS module. In a two-part article and wallchart, Michael Sorens explains how to install it, what it is, and some of the excellent things it has to offer.

Working with SQL Agent Durations

Thu, 23 Aug 2012 06:00:00 UT

SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.

Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config

Wed, 15 Aug 2012 06:00:00 UT

Now that you know how to get started with PowerShell, it is time to configure PowerShell for SQL Server use. This level covers the components you'll need and how to configure them.

11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines

Tue, 14 Aug 2012 06:00:00 UT

Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

Wed, 08 Aug 2012 06:00:00 UT

What are PowerShell and SQL PowerShell and how do you use them? Level 1 of this Stairway will help you answer these questions, and start to show you why you might want to use this great tool.

Pushing SQL Alerts to Remote Server using PowerShell 2 and T-SQL

Mon, 06 Aug 2012 06:00:00 UT

Managing log files in a large enterprise environment can be an overwhelming task. In this article I will show you how to automate some of the work using SQL Alerts and Powershell 2.0

PowerShell SMO: Just Writing Things Once

Wed, 01 Aug 2012 06:00:00 UT

Sometimes, you can tire of writing the same PowerShell code once again. After this happened to Phil whilst keying in an SMO pipeline to access databases, it occurred to him that he should have only one pipeline to access databases in PowerShell, one reusable pipeline

Comparing Two Recordsets Using Powershell

Fri, 13 Jul 2012 06:00:00 UT

How can you quickly and easily compare recordsets from different instances? This article will show you a quick way to do this with PowerShell.

The PoSh DBA - The Attributes of Advanced Functions

Thu, 12 Jul 2012 06:00:00 UT

Once you pass that point of just hurriedly writing PowerShell scripts for immediate use and start to write PowerShell functions for reuse, then you'll want a robust set of parameters that allow functions to work just like cmdlets.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Troubleshooting SQL Server with PowerShell - Virtual Chapter Meeting

Tue, 10 Jul 2012 06:00:00 UT

Come join Laerte Junior on Wednesday ,July 18th 12 noon EDT (GMT -4), for a virtual meeting on Powershell and

Email Job Failures Report to DBA using PowerShell

Tue, 03 Jul 2012 06:00:00 UT

MySQL introduced its own brand of job scheduling, called Events, in version 5.1. However, some Database Administrators (DBAs) feel that it isn't quite ready for prime time. This article presents a hybrid solution that uses MySQL Event Scheduling to manage the batch jobs and Windows PowerShell for the error handling.

Using a PowerShell Script to delete old files for SQL Server

Mon, 02 Jul 2012 06:00:00 UT

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.

Introduction into handling errors in PowerShell for SQL Server tasks

Thu, 28 Jun 2012 06:00:00 UT

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.

Pioneering with PowerShell

Mon, 25 Jun 2012 06:00:00 UT

In PowerShell, Phil Factor believes we have a true novelty: a Windows Scripting language that outsmarts Perl and Python and Ruby and one that will continue to cause radical changes to Windows server applications, and the tools we use to administer them.

The PoSh DBA: Grown-Up PowerShell Functions

Tue, 29 May 2012 06:00:00 UT

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.

Perform Routine Server Checks Using PowerShell

Mon, 21 May 2012 06:00:00 UT

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.

Microsoft SQL Server 2012 - (SQLPS)

Wed, 18 Apr 2012 06:00:00 UT

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 about the power of powershell

Thu, 22 Mar 2012 06:00:00 UT

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