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

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 25    Older >>
 

Exporting data with header using Powershell

Extracting data with header information using PowerShell  Read more...
By Louis Li 2014/04/07 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 156 reads

Auto dump out database schema

This powershell script will dump out a database schema to a text file.  Read more...
By Neil Bryan 2014/02/04 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 1,249 reads

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2013/11/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,396 reads

Powershell script to interactively move cluster resources

Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.  Read more...
By Rolando Hernandez 2013/11/19 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 428 reads

Script to determine if two instances are on the same node

Determines if two instances of a Active/Active cluster are running on the same node.  Read more...
By Gregory Ferdinandsen 2013/11/13 | Source: SQLServerCentral.com | Category: wmi
Rating: |  Discuss |   Briefcase | 727 reads

Check SQL Error Logs using Powershell

Dynamically check your SQL Error Logs and filter using Powershell.  Read more...
By Jim Breffni 2013/06/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,527 reads

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 | 622 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 | 699 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: |  Discuss |   Briefcase | 326 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 | 875 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,773 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,373 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,209 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 | 1,021 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 | 905 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 2013/10/25 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,070 reads

Scripting SQL jobs using PowerShell

Using powershell to create different sql scripts in different files.  Read more...
By Premjit Das 2013/12/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,405 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 | 856 reads

PowerShell - Restart Services

A PowerShell script which restarts any service running on a server.  Read more...
By Rik Thwaites 2014/02/14 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,954 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 | 584 reads
   Items 1 to 20 of 25    Older >>