Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tags
Blogs
,
powershell
Items 1 to 20 of 35
Older >>
Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance...
Read more...
By
Rob Sewell
2015/05/20
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
5,562 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 5
If you’ve followed along to this point, and have assembled the pieces as I’ve given them to you, you’re now...
Read more...
By
Tracy McKibben
2013/11/26
|
Source:
SQLServerCentral Blogs
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,324 reads
Azure does Powershell too
Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...
Read more...
By
Grant Fritchey
2013/05/23
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,709 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
|
2,230 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
|
3,553 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
|
2,372 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
|
2,478 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
|
3,126 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
|
2,102 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
|
2,922 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
|
2,360 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
|
2,758 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
|
2,545 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
|
1,398 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
|
18,815 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
|
2,540 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
|
3,505 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
|
5,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
|
2,424 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,834 reads
Items 1 to 20 of 35
Older >>
Tags
backup and restore
(2)
oracle
(2)
administration
(1)
auditing
(1)
azure
(1)
dba
(1)
error log
(1)
maintenance
(1)
permissions
(1)
restore
(1)
security
(1)
smo
(1)
sql compare
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.