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 47    Older >>
 

Execute SQL Script against Multiple Servers by PowerShell

Execute SQL Script against Multiple Servers by PowerShell  Read more...
By Raushan 2015/08/21 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,090 reads

Cleanup Older than 30 days of Files & Folder through SQL Job

Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job  Read more...
By S M 2015/08/24 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 928 reads

Powershell Script To Check the SQL Jobs Status remotely

Powershell Script To Check the SQL Jobs Status remotely  Read more...
By Raushan 2015/07/30 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 973 reads

Compare hotfix

Easy way to compare hotfix  Read more...
By Mashrur Shuvo 2015/08/04 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 531 reads

Powershell command to extract SQL aliases configured

SQL aliases are stored in system registry and can be viewed via configuration manager. The powershell command can be used to extract the as same and save in a text directly  Read more...
By Kruti Mehta 2015/04/23 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 596 reads

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.  Read more...
Rating: |  Discuss |   Briefcase | 874 reads

Check running SQL Services

Check all the running SQL services in different servers. You can use the details before you start implementing SQL Patch to the servers i.e. if you want to explicitly stop the SQL Services.  Read more...
Rating: |  Discuss |   Briefcase | 1,384 reads

Check Existence of Server and find Instance Type

Execute the function and pass only the SQL Server Name to check if the SQL Instance is available and if yes, what is the Instance Type.  Read more...
Rating: |  Discuss |   Briefcase | 902 reads

Run a specific query across all servers using powershell

Run a specific query across all servers using powershell  Read more...
Rating: |  Discuss |   Briefcase | 1,498 reads

Extract SQL Server Key details

Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.  Read more...
By S M 2014/10/27 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,333 reads

PowerShell script to check last backup date for Databases

PowerShell script to check last full backup, transaction log backup date for SQL Server databases.  Read more...
By Mashrur Shuvo 2014/09/02 | Source: SQLServerCentral.com | Category: daily dba task
Rating: |  Discuss |   Briefcase | 1,302 reads

Powershell script to read Windows 2012 R2 Failover cluster log for Sql

I was having a hard time to reading the Windows 2012 R2 Failover cluster log from my live server. That is why I just wrote a simple PowerShell script to get the job done for me.  Read more...
By Mashrur Shuvo 2014/08/21 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 683 reads

Powershell script to report old backup files

Get a report of backups older than 60 days.  Read more...
By Rolando Hernandez 2014/05/30 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 912 reads

Start a job at a defined step on another sql instance

this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.  Read more...
By az352001 2014/06/04 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 707 reads

Exporting data with header using Powershell

Extracting data with header information using PowerShell  Read more...
By Louis Li 2014/04/28 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,265 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: schemas
Rating: |  Discuss |   Briefcase | 1,466 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 2015/02/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,487 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 | 531 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 | 807 reads
   Items 1 to 20 of 47    Older >>