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

Connect to MongoDB on Remote Linux Server with Powershell

Return values from MongoDB on Linux server with Powershell  Read more...
By Michael D'Spain 2017/03/20 | Source: SQLServerCentral.com | Category: mongodb
Rating: |  Discuss |   Briefcase | 121 reads

Powershell Script to find a SQL\Windows login in SQL Server

This script will help you to find out whether a particular id (SQL or Windows ID) is present in the SQL Server  Read more...
By Vishnu Gupthan 2017/01/26 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 385 reads

Powershell Script for regular DBA activities

This script will perfrom following tasks : 1. BackUp DB 2. Restore DB from BackUp File 3. Restore DB from DB 4. Create a new DB from Existing Db It takes care of all the possible failures during these operations, while done manually.   Read more...
By Mayank Shukla 2017/01/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 953 reads

Using Powershell to run queries on remote server .

This is a function written in powershell , which can used to run queries remotely   Read more...
By himanshu.sinha 2016/07/20 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 666 reads

Capture Linux Drive Space data with Powershell

Capture Linux Drive Space data with Powershell using Posh-SSH module   Read more...
By Michael D'Spain 2016/07/19 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 184 reads

Send Email to recipients with Attachment using PowerShell

If you have a requirement to send email to recipients with attachment, can use the script.  Read more...
Rating: |  Discuss |   Briefcase | 556 reads

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 | 454 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 | 327 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,088 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 | 964 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,073 reads

Execute SQL Script against Multiple Servers by PowerShell

Execute SQL Script against Multiple Servers by PowerShell  Read more...
By Raushan 2016/05/09 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,474 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,465 reads

Drive Space

Combine Drive Space report for all Servers  Read more...
By Mashrur Shuvo 2016/12/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,313 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,207 reads

Compare hotfix

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

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.  Read more...
Rating: |  Discuss |   Briefcase | 1,172 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,547 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 | 963 reads
   Items 1 to 20 of 59    Older >>