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

Scripts with tag powershell Rss

Search for any content tagged powershell

Add a script

   Items 1 to 19 of 19   
 

PowerShell to SlipStream SQL 2008

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.  Read more...
By Fahim Ahmad 2013/05/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 440 reads

PowerShell to search for domain Computer objects

Query Active Directory Computer objects to verify existence  Read more...
By Fahim Ahmad 2013/05/01 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 473 reads

PowerShell to Pre-Create domain objects for SQL Server Cluster

Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster   Read more...
By Fahim Ahmad 2013/04/30 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 252 reads

Restore Latest Backup with Powershell

Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.  Read more...
By Luke Losli 2013/04/16 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 658 reads

Powershell - Document your environment

This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".   Read more...
By Justin Manning 2013/03/22 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,271 reads

Powershell - Query SQL Servers Operating system details

The script works through the CMS you have set up to manage your environment and gathers various server information.  Read more...
By Justin Manning 2013/02/26 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,153 reads

Powershell - Export Stored Proc results to CSV file

This Powershell script calls a stored procedure and exports the results to a CSV file  Read more...
By Mandeep Dulai 2013/02/05 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,047 reads

Unattended Install with PowerShell

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...
By Derik Hammer 2012/08/15 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 799 reads

Create Normalised Databases with Powershell

Database creation with powershell SMO objects  Read more...
By Patrick Viennot 2012/07/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 849 reads

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.  Read more...
By Gene Hunter 2012/06/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,234 reads

Scripting SQL jobs using PowerShell

Using powershell to create different sql scripts in different files.  Read more...
By Premjit Das 2012/05/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,589 reads

Check_Mirroring_Status.ps1

Check mirroring database status using PowerShell.  Read more...
By Eric SIMBOZEL 2012/03/19 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 761 reads

PowerShell - Restart Services

A PowerShell script which restarts any service running on a server.  Read more...
By Rik Thwaites 2012/02/14 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,175 reads

Powershell - Modify Server Name in SQL 2005 SSIS Connections

This powershell script updates the server name specified in connections within a SQL 2005 SSIS package  Read more...
By Mandeep Dulai 2011/06/24 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 547 reads

Automate Range Right Partition Management with Powershell (Part II)

In the last script, we covered removing the trailing partition in a Range Right, date valued partition. This script adds a new (empty) partition to the partition scheme.  Read more...
By Hugh Scott 2010/11/12 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 802 reads

Automate Range Right Partition Management with PowerShell

This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.  Read more...
By Hugh Scott 2010/11/11 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,368 reads

Powershell script to allow you to login to any instance or sqlserver

A small powershell script to grep your instances and log you in to sql.  Read more...
By terryj30 2008/10/21 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,851 reads

Powershell/SMO: Unload table schema, dri, perms & data.

PSH script to unload table schema, dri, permissions and data to file(s).  Read more...
By Gordon-265412 2008/06/10 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 914 reads

Import/Export SQL Server 2000 Enterprise Manager Registered Servers

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.   Read more...
By Chad Miller 2008/05/08 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,410 reads
   Items 1 to 19 of 19