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 211    Older >>
 

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

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

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 | 2,825 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 | 314 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 | 1,188 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 | 19,816 reads

PowerShell to SlipStream SQL 2008

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.  Read more...
By Fahim Ahmad 2013/05/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 619 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,970 reads

PowerShell to search for domain Computer objects

Query Active Directory Computer objects to verify existence  Read more...
By Fahim Ahmad 2013/05/01 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 698 reads

PowerShell to Pre-Create domain objects for SQL Server Cluster

Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster   Read more...
By Fahim Ahmad 2013/04/30 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 324 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 | 2,399 reads

Restore Latest Backup with Powershell

Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.  Read more...
By Luke Losli 2013/04/16 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 872 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,445 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,689 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 | 4,547 reads

Powershell - Document your environment

This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".   Read more...
By Justin Manning 2013/03/22 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,766 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,792 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 | 1,294 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,507 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,441 reads
<< Newer    Items 41 to 60 of 211    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)