Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...

Welcome to Day 10 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...

T-SQL Tuesday Party History In case you’ve been hiding out in the desert, oblivious to all that goes on, there is...  Read more...

This Powershell script calls a stored procedure and exports the results to a CSV file  Read more...

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.  Read more...

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.  Read more...

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.  Read more...

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.  Read more...

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?   Read more...

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.   Read more...

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.  Read more...

I recently had the need to script the execution of a command-line utility and thought it would be a good...  Read more...

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

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.  Read more...

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.  Read more...

Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell...  Read more...

A PowerShell script which will guide you through an interview and produce the configuration file(s) necessary for an unattended installation of SQL Server 2008/2008R2.  Read more...

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.  Read more...

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

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.  Read more...