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


 

Content with tags Blogs, powershell Rss

   Items 1 to 20 of 32    Next 20 >>
 

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 | 819 reads

Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break

We all know that we should document our SQL Servers, right? RIGHT? So let's say you had some time on...  Read more...
By Kendal Van Dyke 2013/04/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,949 reads

PowerShell Usage in DBA Work – Case Study 7/7

Reading/scanning SQL Server Logs is a required DBA work item in all my work environments. I know there are lots...  Read more...
By Jeffrey Yao 2013/03/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,135 reads

PowerShell Usage in DBA Work – Case Study 6/7

SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to...  Read more...
By Jeffrey Yao 2013/03/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,471 reads

A Month of PowerShell – Day 27 (Scripting SQL Objects)

Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...
By Wayne Sheffield 2013/03/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,282 reads

A Month of PowerShell – Day 25 (Integrity Checks)

Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...
By Wayne Sheffield 2013/03/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 978 reads

A Month of PowerShell – Day 22 (Restores)

Welcome to Day 22 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...
By Wayne Sheffield 2013/03/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,104 reads

A Month of PowerShell – Day 21 (Backups)

Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...
By Wayne Sheffield 2013/02/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,167 reads

A Month of PowerShell – Day 13 (Databases: Adding Schemas, Tables and Indexes)

Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...
By Wayne Sheffield 2013/02/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,727 reads

A Month of PowerShell – Day 10 (Navigating SMO collections)

Welcome to Day 10 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...
By Wayne Sheffield 2013/02/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,399 reads

Invitation for T-SQL Tuesday #39 – Can you shell what the PoSH is Cooking?

T-SQL Tuesday Party History In case you’ve been hiding out in the desert, oblivious to all that goes on, there is...  Read more...
By Wayne Sheffield 2013/02/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 622 reads

PowerShell: Redirecting Console Output and Error Output to a Variable and E-mailing it

I recently had the need to script the execution of a command-line utility and thought it would be a good...  Read more...
By nycdotnet 2012/08/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,177 reads

SQL Audit 301 – Using Powershell to Manage Audits

Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell...  Read more...
By 2012/08/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,144 reads

Powershell, SMO, and Add-Member - Not Always BFF

Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of...  Read more...
By 2012/07/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,688 reads

PowerShell and T-SQL: Implementing UNION, INTERSECT, and EXCEPT

I’ve been thoroughly enjoying my experience this year with the Scripting Games. This is the first year I've competed and...  Read more...
By 2012/04/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,359 reads

Restore and Relocate Database Files Using PowerShell

I was recently asked a question on restoring a database using PowerShell with the following requirements Take a database backup file...  Read more...
By Chad Miller 2011/03/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,935 reads

Emailing tempdb Query Results to Paul Randal with PowerShell

I was referred to someone on twitter today who wants to email query results without setting up database mail.  I...  Read more...
By Aaron Nelson 2011/02/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,559 reads

Importing and Exporting SSIS Packages Using PowerShell

SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...  Read more...
By Chad Miller 2011/02/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,933 reads

Powershell to Automate SQL Compare

A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate...  Read more...
By Grant Fritchey 2011/02/02 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,874 reads

Beginning Powershell Companion PDF

Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...  Read more...
By Jen McCown 2011/01/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,251 reads
   Items 1 to 20 of 32    Next 20 >>
 
Tags
oracle (2)    
administration (1)    
auditing (1)    
azure (1)    
backup / recovery (1)    
backup / restore (1)    
dba (1)    
error log (1)    
restore (1)    
smo (1)    
sql compare (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.