Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 52    Older >>
 

Change SQL Server Service Accounts with Powershell

If you need to change multiple SQL Server Services accounts across your environment, Powershell can do that for you.   Read more...
By Michael D'Spain 2016/02/24 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 384 reads

SQLPS Meets the DMV's

This is a great wrapper for your DMV's to automate a quick performance metric capture.  Read more...
By Edward Pochinski 2016/01/12 | Source: SQLServerCentral.com | Category: dmv
Rating: (not yet rated) |  Discuss |   Briefcase | 267 reads

Find SQL Services and Accounts

Find SQL Services and what account they run under with Powershell  Read more...
By Michael D'Spain 2015/12/18 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,023 reads

Capture the tasks performed in a text file

Creates a record of all or part of a Windows PowerShell session in a text file.  Read more...
Rating: |  Discuss |   Briefcase | 945 reads

PoSh: Get-WhoInstallSQL

Useful function that finds who installed SQL Server  Read more...
By Miguel Quintana 2015/09/28 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,026 reads

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,800 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 | 1,411 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 | 1,162 reads

Compare hotfix

Easy way to compare hotfix  Read more...
By Mashrur Shuvo 2015/08/04 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 650 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 | 616 reads

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.  Read more...
Rating: |  Discuss |   Briefcase | 931 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,504 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 | 947 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,604 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,390 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,397 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 | 721 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 | 948 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: agent jobs
Rating: |  Discuss |   Briefcase | 725 reads
   Items 1 to 20 of 52    Older >>