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

Start a job at a defined step on another sql instance

this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.  Read more...
By az352001 2014/06/04 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 676 reads

Extracting data with headers using PowerShell

This article provides a short PowerShell script to extrace data from a database using PowerShell.  Read more...
By Louis Li 2014/06/03 | Source: SQLServerCentral.com | Category: extracting data
Rating: |  Discuss |   Briefcase | 4,039 reads

PowerShell One-Liners: Collections, Hashtables, Arrays and Strings

The way to learn PowerShell is to browse and nibble, rather than to sit down to a formal five-course meal. In his continuing series on PowerShell one-liners, Michael Sorens provides Fast Food for busy professionals who want results quickly and aren't too faddy. Part 3 has as its tasty confections - Collections, Hashtables, arrays and strings.  Read more...
By Additional Articles 2014/06/02 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 4,316 reads

Powershell script to report old backup files

Get a report of backups older than 60 days.  Read more...
By Rolando Hernandez 2014/05/30 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 849 reads

Extract and convert all Excel worksheets into CSV files using PowerShell

Can PowerShell provide an easy way to export Excel as a CSV? Yes. Tim Smith demonstrates that whether you have multiple Excel files, or just multiple worksheets in Excel, PowerShell simplifies the process.   Read more...
By Additional Articles 2014/05/21 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,379 reads

Validate File Properties with PowerShell Prior to Import into SQL Server

We recently faced an issue where an internal data provider began providing an incomplete or inaccurate files because it lacked the proper length (or didn't exceed a certain size). In our case, we implemented a check on the file before importing using PowerShell, here's what we did.  Read more...
By Additional Articles 2014/05/15 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,655 reads

Stairway to SQL PowerShell Level 7: SQL Server PowerShell and the Basics of SMO

In this level we begin our journey into the SQL Server SMO space. SMO stands for Shared Management Objects and is a library written in .NET for use with SQL Server. The SMO library is available when you install SQL Server Management Tools or you install it separately.  Read more...
By Ben Miller 2014/05/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,899 reads

PowerShell One-Liners: Variables, Parameters, Properties, and Objects

Michael Sorens provides the second in a series of collections of general-purpose PowerShell one-liners to cover most of what you'll need to get useful scripting done.  Read more...
By 2014/05/09 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,214 reads

Stairway to SQL PowerShell Level 6: PowerShell Modules

In this level, we will walk through creating and using modules for PowerShell. Modules are simply a collection of functions that are most likely related to each other and packaged in a way that allow you to import them as a group.  Read more...
By Ben Miller 2014/04/30 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,786 reads

Exporting data with header using Powershell

Extracting data with header information using PowerShell  Read more...
By Louis Li 2014/04/28 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,182 reads

PowerShell One-Liners: Help, Syntax, Display and Files

Michael Sorens aims to make PowerShell a bit easier to get going with by providing a series of collections of general-purpose one-liners to cover most of what you'll need to get useful scripting done.  Read more...
By Additional Articles 2014/04/25 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 6,404 reads

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 12,140 reads

Managing SQL Server Services with PowerShell

PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.  Read more...
By Additional Articles 2014/04/10 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,594 reads

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...
By Hugh Scott 2014/03/21 (first published: 2010/12/28) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 6,096 reads

The PoSh DBA – Specifying and Gathering Performance Counters

If you need to keep tabs on a number of servers and applications in a Windows domain then performance counters provide the bedrock of information. It is important to identify the counters you need and gather baseline data to allow you to create alerts when abnormal conditions occur.   Read more...
By Additional Articles 2014/03/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,666 reads

Automate Sliding Window Partition Maintenance: Part II

Part 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.  Read more...
By Hugh Scott 2014/03/14 (first published: 2010/12/21) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 8,001 reads

PowerShell - Restart Services

A PowerShell script which restarts any service running on a server.  Read more...
By Rik Thwaites 2014/09/12 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,745 reads

SQL Server Database Connectivity Testing Using PowerShell

There are several networking issues that can prevent the user from reaching or connecting to the SQL Server database. Learn how to test your SQL Server connectivity with PowerShell.  Read more...
By Additional Articles 2014/02/07 | Source: MSSQLTips.com | Category: connectivity
Rating: (not yet rated)  Rate this |   Briefcase | 2,783 reads

Auto dump out database schema

This powershell script will dump out a database schema to a text file.  Read more...
By Neil Bryan 2014/02/04 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 1,406 reads

The PoSh DBA - Reading and Filtering Errors

DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs of the host servers as well. When server numbers get large, the traditional Windows GUI approach breaks down, and the PoSH DBA reaches for a PowerShell script to do the leg-work.   Read more...
By Additional Articles 2014/01/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,347 reads
<< Newer    Items 21 to 40 of 241    Older >>
 
Tags
blogs (34)    
smo (18)    
administration (15)    
stairway series (9)    
sql server 2005 (8)    
backup / restore (6)    
editorial (6)    
monitoring (6)    
amo (5)    
analysis services (ssas) (5)    
integration services (ssis) (5)    
sql server (5)    
backup (4)    
database weekly (4)    
active directory (3)    
azure (3)    
jobs (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)    
maintenance (2)    
perfmon (2)    
policy based management (pbm) (2)    
recovery model (2)    
script (2)    
scripting (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 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)    
sqlserver (1)    
ssms (1)    
string manipulation (1)    
textmode (1)    
trending (1)    
troubleshooting (1)    
twitter (1)    
unattended install (1)    
unit testing (1)    
users (1)    
virtualization (1)    
vm (1)    
windows cluster (1)    
wmi (1)    
wmi events queries (1)    
wql (1)    
xmla (1)