Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, powershell Rss

   Items 1 to 17 of 17   
 

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...
By Hugh Scott 2014/03/21 (first published: 2010/12/28) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 6,062 reads

The PoSh DBA - Reading and Filtering Errors

DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs of the host servers as well. When server numbers get large, the traditional Windows GUI approach breaks down, and the PoSH DBA reaches for a PowerShell script to do the leg-work.   Read more...
By Additional Articles 2014/01/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,307 reads

The PoSH DBA - SQLPSX: SQL Server PowerShell Extensions

Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed to provide intuitive functions around the SMO objects. Laerte Junior, who is one of the developers on the open-source project, describes how to use it.  Read more...
By Additional Articles 2013/12/27 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,556 reads

The PoSh DBA – Getting Airborne with PowerShell

Maybe the best way of helping the busy database professional to get started with practical PowerShell-based administration is to pull together all the essential community cmdlets into a toolkit for the POSH DBA, and explain how and why you'd use them.  Read more...
By Additional Articles 2013/11/11 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,877 reads

Drive Space Monitoring Gets An Update

Monitoring drive space is something every DBA ought to be doing. Shaun Stuarts brings us a method that can easily be used to keep track of your SQL Server instance  Read more...
By Shaun J. Stuart 2013/08/30 (first published: 2010/10/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,580 reads

PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers

We came across a scenario where database bak files being created from long time which are no more in use...  Read more...
By Prashanth Jayaram 2013/05/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,288 reads

Manage By Delegation

There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.  Read more...
By Steve Jones 2012/10/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 120 reads

Check SQL Server Virtual Log Files Using PowerShell

In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution?   Read more...
By Additional Articles 2012/10/11 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 2,870 reads

Comparing Two Recordsets Using Powershell

How can you quickly and easily compare recordsets from different instances? This article will show you a quick way to do this with PowerShell.  Read more...
By Tom Powell 2012/07/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,039 reads

Perform Routine Server Checks Using PowerShell

Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.  Read more...
By Additional Articles 2012/05/21 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 3,577 reads

Automating Daily Checks with Powershell

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...
By Warren Campbell 2011/12/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 10,616 reads

Using PowerShell to Manage SQLServer

This article provides a practical example of how Powershell can be used by DBAs.  Read more...
By Additional Articles 2011/04/06 | Source: SQL Server Performance | Category: administration
Rating:  Rate this |   Briefcase | 4,092 reads

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...
By Hugh Scott 2014/03/21 (first published: 2010/12/28) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 6,062 reads

Drive Space Monitoring Gets An Update

Monitoring drive space is something every DBA ought to be doing. Shaun Stuarts brings us a method that can easily be used to keep track of your SQL Server instance  Read more...
By Shaun J. Stuart 2013/08/30 (first published: 2010/10/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,580 reads

Moving Indexes with Powershell and SMO

Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.  Read more...
By Zach Mattson 2010/09/30 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 4,000 reads

Retrieve Default SQL Server Backup Folder using PowerShell

In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?   Read more...
By Additional Articles 2010/04/23 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,028 reads

Discover SQL Server TCP Port

Learn how to discover the TCP port for a SQL Server instance from the registry using Windows Powershell.  Read more...
By Additional Articles 2008/08/27 | Source: SQLServerCentral.com | Category: powershell
Rating:  Rate this |   Briefcase | 3,992 reads
   Items 1 to 17 of 17   
 
Tags
monitoring (2)    
backup / restore (1)    
blogs (1)    
editorial (1)    
errorlogs (1)    
indexing (1)    
maintenance (1)    
partitioning (1)    
policy based management (pbm) (1)    
sliding windows technique (1)    
smo (1)    
sqlpsx (1)