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 21 to 40 of 210    Older >>
 

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 2013/10/25 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,069 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 | 11,803 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,333 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 | 13,262 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,466 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 | 25,219 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,359 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,479 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,843 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,110 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,676 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,385 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,849 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,950 reads

Check SQL Error Logs using Powershell

Dynamically check your SQL Error Logs and filter using Powershell.  Read more...
By Jim Breffni 2013/06/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,520 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,951 reads

PowerShell vs GUI Availability Group Rebuild

Windows Cluster\SQL Availability Group rebuild times comparison - Management Studio & Cluster Manager Vs PowerShell Commands   Read more...
By Paul Brewer 2013/06/17 | Source: SQLServerCentral.com | Category: windows cluster
Rating: |  Discuss |   Briefcase | 2,582 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/14 | Source: MSSQLTips.com | Category: recovery model
Rating: (not yet rated)  Rate this |   Briefcase | 130 reads

SQL Server 2012 Integration Services - Using PowerShell to Configure Project Environments

Continuing our discussion on how to leverage the capabilities of PowerShell to automate the most basic SSIS management tasks, this article will explore more complex topics by demonstrating the use of PowerShell in implementing and utilizing project environments.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,548 reads

Change the Settings of a Database Object Using Powershell

This post tells you how to change the QUOTED_IDENTIFIER and ANSI_NULLS settings of a database objects using Powershell.  Read more...
By Ravi Kumar SV 2013/05/28 | Source: SQLServerCentral.com | Category: quoted_identifier
Rating: |  Discuss |   Briefcase | 1,963 reads
<< Newer    Items 21 to 40 of 210    Older >>
 
Tags
blogs (34)    
smo (16)    
administration (15)    
sql server 2005 (8)    
stairway series (7)    
backup / restore (6)    
monitoring (6)    
amo (5)    
analysis services (ssas) (5)    
editorial (5)    
integration services (ssis) (5)    
sql server (4)    
active directory (3)    
backup (3)    
database weekly (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
restore (3)    
sql agent (3)    
sql server 2012 (3)    
windows 2012 (3)    
azure (2)    
cluster (2)    
database (2)    
dimensions (2)    
disk space (2)    
extract, transform, load (etl) (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)    
ansi_nulls (1)    
auditing (1)    
availability groups (1)    
backup / recovery (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)    
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 with header (1)    
failover cluster (1)    
file system task (1)    
fragmentation (1)    
free training (1)    
indexing (1)    
interactive (1)    
introduction (1)    
jobs (1)    
log shipping (1)    
logins (1)    
maintenance (1)    
management (1)    
migration (1)    
mirroring (1)    
ms sql 2008 policy-based management & (1)    
multi-server management (1)    
objects (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)    
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)    
string manipulation (1)    
textmode (1)    
trending (1)    
troubleshooting (1)    
twitter (1)    
unattended install (1)    
users (1)    
virtualization (1)    
vm (1)    
windows azure sql database (1)    
windows cluster (1)    
wmi (1)    
wmi events queries (1)    
wql (1)    
xmla (1)