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

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,630 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,494 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,450 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,848 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,486 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,975 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,863 reads

Powershell parameters

By Steve Jones 2015/02/06 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,569 reads

Scripting SQL Agents Jobs using Powershell

The script helps to Scripting SQL Agents Jobs using Powershell automatically by scheduling as a job.  Read more...
By Saranya Venugopal 2015/02/04 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,727 reads

Getting Started with HDInsight - Part 3 - Creating an HDInsight Cluster in Microsoft Azure Cloud

In this tip we will look at two different ways of creating an HDInsight Cluster: Creating an HDInsight Cluster through Azure Management Portal, and creating an HDInsight Cluster through Windows Azure PowerShell.  Read more...
By Additional Articles 2015/01/01 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 5,779 reads

Getting Started with HDInsight - Part 2 - Introduction to Azure HDInsight PowerShell

PowerShell is a very popular and powerful feature in the Microsoft stack. It is extensively used for development, deployment and administration across various ecosystems like SQL Server, SharePoint, Azure Cloud and others. PowerShell cmdlets are available for HDInsight as well and in this tip we will take a look at fundamental aspects of Microsoft Azure PowerShell for HDInsight.  Read more...
By Additional Articles 2014/12/26 | Source: MSSQLTips.com | Category: powershell
Rating:  Rate this |   Briefcase | 7,441 reads

Practical PowerShell Unit-Testing: Mock Objects

Pester allows you to automate the testing of PowerShell scripts. It can test the output of a function as you develop it by validating simple data (scalars) and arrays, and allows you to focus on the one function you want to test by using 'mocking' to fake all the other functions and Cmdlets.  Read more...
By Additional Articles 2014/12/23 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 6,705 reads

Scripting SQL Server databases with SMO using EnforceScriptingOptions

Obscure impact of switch EnforceScriptingOptions to scripting a SQL Server database.  Read more...
By Johan Bijnens 2014/12/08 | Source: SQLServerCentral.com | Category: sqlserver
Rating: |  Discuss |   Briefcase | 2,389 reads

Practical PowerShell Unit-Testing: Getting Started

If you're using PowerShell for automation, you'll probably need to automate the unit-testing of the PowerShell scripts themselves. Michael Sorens introduces you to Pester, the leading test framework for PowerShell, and shows how it can make it easier to produce reliable scripts  Read more...
By 2014/11/14 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 8,066 reads

Does the database exist?

By Steve Jones 2014/11/04 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,701 reads

Getting Data Into and Out of PowerShell Objects

You can execute PowerShell code that creates the data of an object, but there is no cmdlet to generate the 'object notation' code from an existing PowerShell object; until now, that is. Phil Factor also produces a ConvertTo-YAML function and explains how they both work, with illustrative code.  Read more...
By Additional Articles 2014/11/04 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 8,991 reads

Extract SQL Server Key details

Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.  Read more...
By S M 2014/10/27 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,333 reads

Stairway to SQL PowerShell Level 8: SQL Server PowerShell Provider

In this level we continue our journey into the SQL Server space by looking at the SQL Provider that comes with modules for PowerShell. You saw a little bit of the provider for SQL 2008 R2 in Level 2 of this Stairway.  Read more...
By Ben Miller 2014/10/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,791 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,855 reads
<< Newer    Items 21 to 40 of 282    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 jobs (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 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 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)