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

Content with tag powershell Rss

<< Newer    Items 41 to 60 of 235    Older >>
 

Powershell script to interactively move cluster resources

Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.  Read more...
By Rolando Hernandez 2013/11/19 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 465 reads

Script to determine if two instances are on the same node

Determines if two instances of a Active/Active cluster are running on the same node.  Read more...
By Gregory Ferdinandsen 2013/11/13 | Source: SQLServerCentral.com | Category: wmi
Rating: |  Discuss |   Briefcase | 760 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,862 reads

Database Restore Automation

Read about Paul Brewer's Framework (Version 2) for Database Restore Automation.  Read more...
By Paul Brewer 2013/11/04 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,741 reads

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.  Read more...
By Gene Hunter 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,671 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 2013/10/23 (first published: 2012/08/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,945 reads

Lab Ops 2–The Lee-Robinson Script

Marcus Robinson adapted PowerShell scripts by Thomas Lee to build a set of VMs to run a course in a reliable and repeatable way. With Marcus’s permission, Andrew Fryer has put that Setup Script on SkyDrive, and provided notes on the script.  Read more...
By Additional Articles 2013/10/03 | Source: Microsoft MSDN | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,396 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 2013/09/25 (first published: 2012/08/15) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,913 reads

The PoSh DBA – Getting to know PowerShell

Although it was primarily designed for System Administrators, PowerShell is now extending its use to Database, SharePoint, Exchange and all Microsoft products. In this article Laerte Junior offers an introduction to PowerShell and describes how DBAs can use PowerShell to automate repetitive tasks. He also explains when to use PowerShell instead of, or in addition to, T-SQL and SSIS.  Read more...
By Additional Articles 2013/09/23 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 3,523 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 2013/09/04 (first published: 2012/08/08) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 28,457 reads

Test Your SQL Server Backups with PowerShell

The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White shows how, with PowerShell.  Read more...
By Additional Articles 2013/09/02 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,411 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,567 reads

SSIS 2012 - Using PowerShell to Remotely Execute File System Packages in Multi-Server Scenarios

In this article Marcin Policht discusses different methods of executing SQL Server 2012 Integration Services packages deployed by employing the traditional Package Deployment Model, focusing in particular on those stored in the .dtsx file system format.   Read more...
By Additional Articles 2013/08/27 | Source: Database Journal | Category: file system task
Rating: (not yet rated)  Rate this |   Briefcase | 1,884 reads

SSIS 2012 - Using PowerShell to Remotely Execute File System Packages

A Powershell script that allows you to execute SSIS packages using the traditional Package Deployment Model can be very useful. But what do you do when the execution isn't triggered by the same computer where the target package resides? Marcin Policht offers a solution.  Read more...
Rating:  Rate this |   Briefcase | 2,153 reads

PowerShell the SQL Server Way

Although Windows PowerShell has been available to IT professionals going on seven years, there are still many IT pros who are just now deciding to see what the fuss is all about. Depending on your job, you might find PowerShell an invaluable tool. Microsoft's plan is that PowerShell will be the management tool for all of its servers and platforms. For most IT pros, it's not a matter of if you'll be using PowerShell, only a matter of when.  Read more...
By Additional Articles 2013/07/26 | Source: SQL Server Magazine | Category: powershell
Rating:  Rate this |   Briefcase | 3,718 reads

Finding lost or forgotten SQL Servers

This article will show a way to find all SQL Servers, particularly those that have been forgotten about or lost.  Read more...
By Clay Punnett 2013/07/25 (first published: 2011/04/19) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 15,467 reads

How To Document Your PowerShell Library

PowerShell provides comment-based help for functions and scripts with Get-Help, but when you want to document modues or generate a complete indexed API in HTML format, just as you can with Sandcastle for .NET or javadoc for Java, then stronger magic is required. Michael Sorens shows you how it is done, with source code.  Read more...
By Additional Articles 2013/07/18 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,904 reads

Log Shipping Lite with PowerShell

A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.  Read more...
By Paul Brewer 2013/07/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,996 reads

Check SQL Error Logs using Powershell

Dynamically check your SQL Error Logs and filter using Powershell.  Read more...
By Jim Breffni 2014/08/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,578 reads

Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell

Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.   Read more...
By Additional Articles 2013/06/19 | Source: MSSQLTips.com | Category: recovery model
Rating: (not yet rated)  Rate this |   Briefcase | 2,988 reads
<< Newer    Items 41 to 60 of 235    Older >>
 
Tags
blogs (34)    
smo (17)    
administration (15)    
sql server 2005 (8)    
stairway series (8)    
backup / restore (6)    
editorial (6)    
monitoring (6)    
amo (5)    
analysis services (ssas) (5)    
integration services (ssis) (5)    
backup (4)    
database weekly (4)    
sql server (4)    
active directory (3)    
azure (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
restore (3)    
sql agent (3)    
sql server 2012 (3)    
windows 2012 (3)    
cluster (2)    
database (2)    
dimensions (2)    
disk space (2)    
extract, transform, load (etl) (2)    
jobs (2)    
maintenance (2)    
perfmon (2)    
policy based management (pbm) (2)    
recovery model (2)    
script (2)    
security (2)    
sql server 2008 (2)    
transaction logs (2)    
t-sql (2)    
webinar (2)    
windows 2008 r2 (2)    
windows azure sql database (2)    
ansi_nulls (1)    
auditing (1)    
automation (1)    
availability groups (1)    
backup / recovery (1)    
backups (1)    
bi (1)    
capacity planning (1)    
central management server (cms) (1)    
checkdb (1)    
command line install (1)    
connectivity (1)    
creation (1)    
csv (1)    
cube (1)    
daily dba task (1)    
data mining (1)    
database mail (1)    
database space (1)    
dba (1)    
dbcc checkdb (1)    
document environment (1)    
documentation (1)    
domain (1)    
enterprise manager (1)    
epm (1)    
error handling (1)    
error log (1)    
errorlogs (1)    
event log (1)    
events (1)    
extracting data (1)    
extracting data with header (1)    
failover cluster (1)    
file system task (1)    
find stored procedures (1)    
fragmentation (1)    
free training (1)    
html (1)    
indexing (1)    
interactive (1)    
introduction (1)    
log shipping (1)    
logins (1)    
management (1)    
migration (1)    
mirroring (1)    
ms sql 2008 policy-based management & (1)    
multi-server management (1)    
objects (1)    
old files (1)    
pass (1)    
performance counters (1)    
performance monitoring (1)    
permissions (1)    
powershell modules (1)    
profiler (1)    
quoted_identifier (1)    
registered servers (1)    
remote servers (1)    
remoting (1)    
report (1)    
resource groups (1)    
schema (1)    
script jobs (1)    
scripting (1)    
scripting jobs (1)    
service restart (1)    
services (1)    
silent install (1)    
simple-talk series (1)    
size (1)    
sliding windows (1)    
sliding windows technique (1)    
slipstream (1)    
sql alerts (1)    
sql compare (1)    
sql discovery (1)    
sql job (1)    
sql jobs (1)    
sql server 7 (1)    
sql server cluster (1)    
sqlcmd (1)    
sqljob (1)    
sqljobs (1)    
sqlpsx (1)    
ssms (1)    
string manipulation (1)    
textmode (1)    
trending (1)    
troubleshooting (1)    
twitter (1)    
unattended install (1)    
users (1)    
virtualization (1)    
vm (1)    
windows cluster (1)    
wmi (1)    
wmi events queries (1)    
wql (1)    
xmla (1)