Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Articles with tag
powershell
Search for
any
content tagged
powershell
Items 1 to 20 of 131
Next 20 >>
Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets
There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen White demonstrates.
Read more...
By
Additional Articles
2013/05/23
|
Source:
SimpleTalk
|
Category:
sql server 2012
Rating:
Rate this
|
Briefcase
|
1,039 reads
Powershell for DBAs
Powershell is a great tool for helping you work with multiple instances of SQL Server. This week Steve Jones talks about how and why you might want to get started.
Read more...
By
Steve Jones
2013/05/20
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
111 reads
Powershell Database Backup Script
Learn how to write a script for regular database backups using Powershell and SMO.
Read more...
By
Jimmy Atsaves
2013/05/17 (first published: 2011/01/05)
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
17,692 reads
Monitor SQL Instance Balance across Windows Cluster Nodes Using PowerShell
This tip will demonstrate how to monitor SQL Failover Cluster Instances if they become unbalanced using Windows PowerShell.
Read more...
By
Additional Articles
2013/05/03
|
Source:
MSSQLTips.com
|
Category:
failover cluster
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,723 reads
Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks
You should be on your way with PowerShell with the previous levels and now the topic shifts to using Functions and Assemblies built in to .NET for use with automation. This topic will be used in your PowerShell adventures throughout your career and this Stairway.
Read more...
By
Ben Miller
2013/03/25
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
3,047 reads
PowerShell Basics
Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.
Read more...
By
W. Shawn Melton
2013/02/22 (first published: 2011/01/24)
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
22,246 reads
SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell
Marcin Policht presents the fundamental principles of PowerShell in the context of SQL Server 2012. Join him as he steps through its initial setup and configuration, and reviews specific management areas where its advantages can be realized.
Read more...
By
Additional Articles
2013/01/31
|
Source:
Database Journal
|
Category:
powershell
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,680 reads
The PoSh DBA: Solutions using PowerShell and SQL Server
PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much more than getting information from SQL Server instances via PowerShell; it can also be run from SQL Server as part of a system that helps with administrative and monitoring tasks.
Read more...
By
Additional Articles
2012/10/29
|
Source:
SimpleTalk
|
Category:
powershell
Rating:
Rate this
|
Briefcase
|
2,700 reads
Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell
This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.
Read more...
By
Ben Miller
2012/10/22
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
4,801 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
|
112 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,709 reads
PowerShell script to find files that are consuming the most disk space
As you know, SQL Server databases and backup files can take up a lot of disk space. When disk is running low and you need to troubleshoot disk space issues, the first thing to do is to find large files that are consuming disk space. In this article I will show you a PowerShell script that you can use to find large files on your disks.
Read more...
By
Additional Articles
2012/10/10
|
Source:
MSSQLTips.com
|
Category:
powershell
Rating:
Rate this
|
Briefcase
|
2,988 reads
Practical PowerShell for SQL Server Developers and DBAs – Part 2
Having shown just how useful PowerShell can be for DBAs in executing queries, Michael Sorens now takes us through navigating SQL Server space and finding meta-information - valuable information for anyone looking to be more productive in SQL Server.
Read more...
By
Additional Articles
2012/09/07
|
Source:
SimpleTalk
|
Category:
powershell
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,563 reads
Stairway to SQL PowerShell Level 3: Input and Output with PowerShell
This level will cover some of the Input/Output operations you can use with PowerShell.
Read more...
By
Ben Miller
2012/08/29
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
6,611 reads
Practical PowerShell for SQL Server Developers and DBAs – Part 1
There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS and the newer SQLPS module. In a two-part article and wallchart, Michael Sorens explains how to install it, what it is, and some of the excellent things it has to offer.
Read more...
By
Additional Articles
2012/08/27
|
Source:
SimpleTalk
|
Category:
powershell
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,053 reads
Working with SQL Agent Durations
SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.
Read more...
By
Kyle Neier
2012/08/23
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
2,735 reads
Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config
Now that you know how to get started with PowerShell, it is time to configure PowerShell for SQL Server use. This level covers the components you'll need and how to configure them.
Read more...
By
Ben Miller
2012/08/15
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
7,601 reads
11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines
Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.
Read more...
By
Daniel Calbimonte
2012/08/14
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
|
Discuss
|
Briefcase
|
5,854 reads
Stairway to SQL PowerShell Level 1: SQL PowerShell Basics
What are PowerShell and SQL PowerShell and how do you use them? Level 1 of this Stairway will help you answer these questions, and start to show you why you might want to use this great tool.
Read more...
By
Ben Miller
2012/08/08
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
14,483 reads
Pushing SQL Alerts to Remote Server using PowerShell 2 and T-SQL
Managing log files in a large enterprise environment can be an overwhelming task. In this article I will show you how to automate some of the work using SQL Alerts and Powershell 2.0
Read more...
By
Simon Richards
2012/08/06
|
Source:
SQLServerCentral.com
|
Category:
sql alerts
Rating:
|
Discuss
|
Briefcase
|
2,204 reads
Items 1 to 20 of 131
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.