SQLServerCentral.com Content tagged powershell

Stairway to SQL PowerShell

Thu, 14 Jun 2012 09:02:13 UT

PowerShell is a powerful scripting tool that allows you to automate routine tasks, and script administrative tasks, allowing you to automate a lot of the routine work in a SQL envirionment. Ben Miller's Stairway Series introduces PowerShell from the beginning, guiding you through how to configure and get started with the framework before working towards more advanced scripting.

PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers

Fri, 17 May 2013 06:00:00 UT

We came across a scenario where database bak files being created from long time which are no more in use...

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.

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

PowerShell to SlipStream SQL 2008

Fri, 03 May 2013 06:00:00 UT

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.

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.

PowerShell to search for domain Computer objects

Wed, 01 May 2013 06:00:00 UT

Query Active Directory Computer objects to verify existence

PowerShell to Pre-Create domain objects for SQL Server Cluster

Tue, 30 Apr 2013 06:00:00 UT

Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster

Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break

Wed, 24 Apr 2013 06:00:00 UT

We all know that we should document our SQL Servers, right? RIGHT? So let's say you had some time on...

Restore Latest Backup with Powershell

Tue, 16 Apr 2013 06:00:00 UT

Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.

PowerShell Usage in DBA Work – Case Study 7/7

Fri, 29 Mar 2013 06:00:00 UT

Reading/scanning SQL Server Logs is a required DBA work item in all my work environments. I know there are lots...

PowerShell Usage in DBA Work – Case Study 6/7

Wed, 27 Mar 2013 06:00:00 UT

SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to...

‘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 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 - Document your environment

Fri, 22 Mar 2013 06:00:00 UT

This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".

A Month of PowerShell – Day 27 (Scripting SQL Objects)

Mon, 11 Mar 2013 06:00:00 UT

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

A Month of PowerShell – Day 25 (Integrity Checks)

Thu, 07 Mar 2013 07:00:00 UT

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

A Month of PowerShell – Day 22 (Restores)

Mon, 04 Mar 2013 07:00:00 UT

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

A Month of PowerShell – Day 21 (Backups)

Thu, 28 Feb 2013 07:00:00 UT

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

Powershell - Query SQL Servers Operating system details

Tue, 26 Feb 2013 07:00:00 UT

The script works through the CMS you have set up to manage your environment and gathers various server information.

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.

A Month of PowerShell – Day 13 (Databases: Adding Schemas, Tables and Indexes)

Wed, 20 Feb 2013 07:00:00 UT

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

A Month of PowerShell – Day 10 (Navigating SMO collections)

Wed, 13 Feb 2013 07:00:00 UT

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

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

Invitation for T-SQL Tuesday #39 – Can you shell what the PoSH is Cooking?

Fri, 08 Feb 2013 07:00:00 UT

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

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

Powershell - Export Stored Proc results to CSV file

Tue, 05 Feb 2013 07:00:00 UT

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

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

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.

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?

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

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.

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.