SQL Clone
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 63    Older >>
 

Add new Databases to a AG Setup with PowerShell

Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.  Read more...
By Edward Pochinski 2017/09/12 | Source: SQLServerCentral.com | Category: availability groups
Rating: (not yet rated) |  Discuss |   Briefcase | 145 reads

Get SSAS Tabular Model (2016) Roles using Powershell `

Extract roles from 2016 Tabular Models using Powershell.   Read more...
By Thasigan Chetty 2017/09/14 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 100 reads

PowerShell 3rd Party tool Memory Alert

Keeps a memory leak under control until the bug fix is developed and applied. Short term band aid.  Read more...
By Edward Pochinski 2017/04/25 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 329 reads

PowerShell for Server/DB/Object level Permissions/Logins/Roles/Users

PowerShell to generate Server Level Permissions/Logins/Roles, Object/Database Level Permissions.  Read more...
Rating: |  Discuss |   Briefcase | 457 reads

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 | 155 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 | 431 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 | 1,202 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 | 697 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 | 196 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 | 593 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 | 500 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 | 334 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,102 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 | 968 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,084 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,641 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,480 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,332 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,236 reads

Compare hotfix

Easy way to compare hotfix  Read more...
By Mashrur Shuvo 2015/08/04 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 668 reads
   Items 1 to 20 of 63    Older >>