Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag powershell Rss

Search for any content tagged powershell

   Items 1 to 20 of 161    Older >>
 

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 11,577 reads

Managing SQL Server Services with PowerShell

PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.  Read more...
By Additional Articles 2014/04/10 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,296 reads

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...
By Hugh Scott 2014/03/21 (first published: 2010/12/28) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 5,872 reads

The PoSh DBA – Specifying and Gathering Performance Counters

If you need to keep tabs on a number of servers and applications in a Windows domain then performance counters provide the bedrock of information. It is important to identify the counters you need and gather baseline data to allow you to create alerts when abnormal conditions occur.   Read more...
By Additional Articles 2014/03/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,402 reads

Automate Sliding Window Partition Maintenance: Part II

Part 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.  Read more...
By Hugh Scott 2014/03/14 (first published: 2010/12/21) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 7,634 reads

SQL Server Database Connectivity Testing Using PowerShell

There are several networking issues that can prevent the user from reaching or connecting to the SQL Server database. Learn how to test your SQL Server connectivity with PowerShell.  Read more...
By Additional Articles 2014/02/07 | Source: MSSQLTips.com | Category: connectivity
Rating: (not yet rated)  Rate this |   Briefcase | 2,641 reads

The PoSh DBA - Reading and Filtering Errors

DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs of the host servers as well. When server numbers get large, the traditional Windows GUI approach breaks down, and the PoSH DBA reaches for a PowerShell script to do the leg-work.   Read more...
By Additional Articles 2014/01/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,163 reads

Stop & Start Your VM’s on Azure with Powershell

This is a very simple script can be used as a framework for you to stop and start your VM’s on Azure with Powershell.  Read more...
By Additional Articles 2014/01/10 | Source: TechNet Blogs | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,933 reads

The PoSH DBA - SQLPSX: SQL Server PowerShell Extensions

Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed to provide intuitive functions around the SMO objects. Laerte Junior, who is one of the developers on the open-source project, describes how to use it.  Read more...
By Additional Articles 2013/12/27 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,391 reads

PowerShell Data Basics: File-Based Data

One of the frustrations of anyone beginning with PowerShell is the simple task of getting data in and out. To help out with this, Michael Sorens begins a series that shows you how to import data from most of the common file formats and sources. He also shows how to export data in a range of formats.  Read more...
By Additional Articles 2013/12/10 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 1,957 reads

The PoSh DBA – Getting Airborne with PowerShell

Maybe the best way of helping the busy database professional to get started with practical PowerShell-based administration is to pull together all the essential community cmdlets into a toolkit for the POSH DBA, and explain how and why you'd use them.  Read more...
By Additional Articles 2013/11/11 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,784 reads

Database Restore Automation

Read about Paul Brewer's Framework (Version 2) for Database Restore Automation.  Read more...
By Paul Brewer 2013/11/04 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,611 reads

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

This level will cover some of the Input/Output operations you can use with PowerShell.   Read more...
By Ben Miller 2013/10/23 (first published: 2012/08/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,820 reads

Lab Ops 2–The Lee-Robinson Script

Marcus Robinson adapted PowerShell scripts by Thomas Lee to build a set of VMs to run a course in a reliable and repeatable way. With Marcus’s permission, Andrew Fryer has put that Setup Script on SkyDrive, and provided notes on the script.  Read more...
By Additional Articles 2013/10/03 | Source: Microsoft MSDN | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,336 reads

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

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...
By Ben Miller 2013/09/25 (first published: 2012/08/15) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,285 reads

The PoSh DBA – Getting to know PowerShell

Although it was primarily designed for System Administrators, PowerShell is now extending its use to Database, SharePoint, Exchange and all Microsoft products. In this article Laerte Junior offers an introduction to PowerShell and describes how DBAs can use PowerShell to automate repetitive tasks. He also explains when to use PowerShell instead of, or in addition to, T-SQL and SSIS.  Read more...
By Additional Articles 2013/09/23 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 3,472 reads

Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

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...
By Ben Miller 2013/09/04 (first published: 2012/08/08) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 25,257 reads

Test Your SQL Server Backups with PowerShell

The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White shows how, with PowerShell.  Read more...
By Additional Articles 2013/09/02 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,363 reads

Drive Space Monitoring Gets An Update

Monitoring drive space is something every DBA ought to be doing. Shaun Stuarts brings us a method that can easily be used to keep track of your SQL Server instance  Read more...
By Shaun J. Stuart 2013/08/30 (first published: 2010/10/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,484 reads

SSIS 2012 - Using PowerShell to Remotely Execute File System Packages in Multi-Server Scenarios

In this article Marcin Policht discusses different methods of executing SQL Server 2012 Integration Services packages deployed by employing the traditional Package Deployment Model, focusing in particular on those stored in the .dtsx file system format.   Read more...
By Additional Articles 2013/08/27 | Source: Database Journal | Category: file system task
Rating: (not yet rated)  Rate this |   Briefcase | 1,846 reads
   Items 1 to 20 of 161    Older >>