Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags powershell, SQL Server Rss

   Items 1 to 9 of 9   
 

Using PowerShell for SQL Server Replication Tracking

Tim Smith shows how using PowerShell can be an effective way to track SQL Server snapshot and transactional replication counts for sources and destinations.  Read more...
By Additional Articles 2016/01/28 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,349 reads

Doing a SQL Server Healthcheck via PowerShell

PowerShell is an ideal tool for doing health-checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed to suit circumstances. Omid Afzalalghom's Healthcheck allows tests to be SQL or PowerShell and requires only adding, altering or deleting files in directories.  Read more...
By Additional Articles 2015/12/01 | Source: SimpleTalk | Category: healthcheck
Rating:  Rate this |   Briefcase | 4,006 reads

PowerShell and ADO.NET Connection String Settings for SQL Server

Tim Smith addresses some common questions from PowerShell developers about connection strings, errors with strings, and alternative development approaches to using connection strings.  Read more...
By Additional Articles 2015/09/11 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,037 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,377 reads

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 12,314 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,502 reads

Using PowerShell to Manage SQL Server

The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs.  Read more...
By Additional Articles 2011/08/16 | Source: SQL Server Performance | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,431 reads

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 12,314 reads

Getting Data out of SQL Server from Powershell

In the first article, we learned how to move data into SQL Server. This time Chad Miller shows us how we can use Powershell to extract data out of SQL Server.  Read more...
By Chad Miller 2009/01/02 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 15,400 reads
   Items 1 to 9 of 9   
 
Tags
ado.net (1)    
command line install (1)    
event log (1)    
extract, transform, load (etl) (1)    
healthcheck (1)    
jobs (1)    
perfmon (1)    
replication tracking (1)    
silent install (1)    
troubleshooting (1)    
unattended install (1)