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

Content with tag powershell Rss

   Items 1 to 20 of 275    Older >>
 

PowerShell Day-to-Day Admin Tasks: Monitoring Performance

By reading performance counters from services such as SQL Server or Exchange, you can get a wealth of performance information. By automating the process of gathering and storing appropriate counters, you can routinely check a range of devices quickly using visual tools such as PerfMon. By then creating your own counters, you can add counter-based metrics to anything that can be measured programmatically, such as services, applications, processes such as ETL, or deployments. Nicolas Prigent shows you how.  Read more...
By Additional Articles 2015/07/16 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,959 reads

The Poster of the Plethora of PowerShell Pitfalls

One of the downsides of learning a new computer language is that transfer of training doesn't always work to your advantage. In fact, the habits you picked up in the past may now cause confusion. In this poster or wall-chart for long walls, Michael Sorens selects the thirty-six most common causes of confusion for anyone getting to grips with PowerShell.  Read more...
By Additional Articles 2015/07/08 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,983 reads

Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell

In this article, Tim Smith goes through a couple of options to automate heartbeat checks against Azure databases. This is useful if you're moved SQL Server databases to Azure and you want to have periodic checks to make sure the databases are responsive.  Read more...
By Additional Articles 2015/06/17 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,435 reads

Powershell day-to-day Admin tasks: WMI, CIM and PSWA

WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL Server or Exchange Server. It provides a logical structure and representation of systems and services that are hosted on the server and is essential for anyone who is keen to automate routine monitoring and administration work via PowerShell, especially where many servers are involved in the task.  Read more...
By Additional Articles 2015/06/15 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,593 reads

A Plethora of PowerShell Pitfalls: Part 2

There are some pitfalls in PowerShell for the unwary. Many people who are learning PowerShell come across quirks that can cause frustration. Michael Sorens continues his series, warning abut four of the most common PowerShell pitfalls and explains how to avoid them.  Read more...
By Additional Articles 2015/05/29 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 6,659 reads

Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell

If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance...  Read more...
By Rob Sewell 2015/05/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,998 reads

Automating Day-to-Day PowerShell Admin Tasks - Jobs and Workflow

If you are aiming to optimise the use of your time by doing as much as possible via scripting, you will soon want to run scripts in parallel to save time. PowerShell does not demand that you run jobs one after the other; It has the means to launch actions whenever you wish and to obtain the results when you want them.  Read more...
By Additional Articles 2015/05/15 | Source: ITKnowledge Exchange | Category: automation
Rating:  Rate this |   Briefcase | 7,796 reads

Check SQL Error Logs using Powershell

Dynamically check your SQL Error Logs and filter using Powershell.  Read more...
By Jim Breffni 2015/05/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,600 reads

Server Logins

By Steve Jones 2015/05/04 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,334 reads

Powershell command to extract SQL aliases configured

SQL aliases are stored in system registry and can be viewed via configuration manager. The powershell command can be used to extract the as same and save in a text directly  Read more...
By Kruti Mehta 2015/04/23 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 590 reads

Stairway to SQL PowerShell Level 9: Objects For Everyone

This level will show how to create objects including a login, a database, a filegroup, a file a database user and then we’ll end with a table and an index.  Read more...
By Ben Miller 2015/04/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,360 reads

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.  Read more...
Rating: |  Discuss |   Briefcase | 857 reads

Different ways to find Powershell Version

By S M 2015/03/27 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,340 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 2015/03/20 (first published: 2012/08/08) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 39,189 reads

Run a specific query across all servers using powershell

Run a specific query across all servers using powershell  Read more...
Rating: |  Discuss |   Briefcase | 1,456 reads

SQL Powershell Script to check Server's disk space Remotely

SQL Powershell Script to check Server's disk space Remotely  Read more...
By Raushan 2015/03/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,432 reads

SQL Powershell Script to get the list of Server's Local Admins

SQL Powershell Script to get the list of Server's Local Admins from remote  Read more...
By Raushan 2015/03/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,832 reads

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2015/02/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,474 reads

Error handling with try-catch-finally in PowerShell for SQL Server

PowerShell V2 introduces the "try-catch-finally" statements, similar to those you already use when you write .NET code. "Try-catch-finally" encloses a block of script that is likely to produce errors under specific circumstances and therefore helps you to keep your code organized. This article is a short usage guide for this error handling construct.   Read more...
By Additional Articles 2015/02/24 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 7,932 reads

Collect Data from Multiple Instances Using SSIS and Powershell

Use SSIS to pull data from multiple instances. Combine with powershell to run multiple instances simultaneously.  Read more...
By S. Kusen 2015/02/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,787 reads
   Items 1 to 20 of 275    Older >>
 
Tags
blogs (35)    
smo (18)    
administration (16)    
stairway series (10)    
sql server 2005 (8)    
backup / restore (6)    
editorial (6)    
integration services (ssis) (6)    
monitoring (6)    
amo (5)    
analysis services (ssas) (5)    
azure (5)    
sql server (5)    
backup (4)    
database weekly (4)    
jobs (4)    
sql agent (4)    
active directory (3)    
automation (3)    
maintenance (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
restore (3)    
sql server 2012 (3)    
windows 2012 (3)    
cluster (2)    
database (2)    
dimensions (2)    
disk space (2)    
error log (2)    
extract, transform, load (etl) (2)    
logins (2)    
perfmon (2)    
policy based management (pbm) (2)    
recovery model (2)    
script (2)    
scripting (2)    
security (2)    
sql jobs (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)    
availability groups (1)    
backup / recovery (1)    
backups (1)    
bi (1)    
capacity planning (1)    
central management server (cms) (1)    
checkdb (1)    
clustering (1)    
command line install (1)    
compare windows hotfix (1)    
connectivity (1)    
creation (1)    
csv (1)    
cube (1)    
daily dba task (1)    
data flow (1)    
data gathering (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)    
event log (1)    
events (1)    
extracting data (1)    
extracting data with header (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)    
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)    
powershell objects (1)    
profiler (1)    
quoted_identifier (1)    
r language (1)    
registered servers (1)    
remote servers (1)    
remoting (1)    
report (1)    
resource groups (1)    
schemas (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 aliases (1)    
sql compare (1)    
sql discovery (1)    
sql job (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)