Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag powershell Rss

<< Newer    Items 21 to 40 of 323    Older >>
 

Documenting Your PowerShell Binary Cmdlets

Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as to provide comprehensive help at the command-line or IDE, the same isn't true of binary cmdlets written in C#. At last, there is an open-source utility to assist with this that is being actively maintained and updated. At last, binary cmdlets need no longer be the poor cousins of scripted cmdlets in their documentation  Read more...
By Additional Articles 2016/01/18 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,917 reads

SQLPS Meets the DMV's

This is a great wrapper for your DMV's to automate a quick performance metric capture.  Read more...
By Edward Pochinski 2016/01/12 | Source: SQLServerCentral.com | Category: dmv
Rating: (not yet rated) |  Discuss |   Briefcase | 279 reads

PowerShell Tool Time: Building Help

Learn how you can customize the help for your library of scripts in this edition of PowerShell Tool Time.  Read more...
By Mike Fal 2016/01/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,956 reads

PoSh Index Rebuilds

By Steve Jones 2016/01/04 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,229 reads

The PoSh DBA - Using the Basic PowerShell Paradigms

PowerShell is like any computer language: you must understand the paradigms, the constructs, and the way it is designed to work to get the most value from it. It is no good just translating 'sausage-string' procedural algorithms. To demonstrate how Powersahell should be used as its' creators intended, Laerte Junior shows the difference between PowerShell problem-solving with, and without, PowerShell paradigms.  Read more...
By Additional Articles 2016/01/01 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 6,442 reads

Server.Configuration Properties

By Steve Jones 2015/12/29 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,044 reads

Find SQL Services and Accounts

Find SQL Services and what account they run under with Powershell  Read more...
By Michael D'Spain 2015/12/18 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,039 reads

Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell

This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.  Read more...
By Ben Miller 2015/12/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,683 reads

ExecuteNonQuery

By Steve Jones 2015/12/10 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,164 reads

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.  Read more...
By Ben Miller 2015/12/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,309 reads

Doing a SQL Server Healthcheck via PowerShell

PowerShell is an ideal tool for doing health-checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed to suit circumstances. Omid Afzalalghom's Healthcheck allows tests to be SQL or PowerShell and requires only adding, altering or deleting files in directories.  Read more...
By Additional Articles 2015/12/01 | Source: SimpleTalk | Category: healthcheck
Rating:  Rate this |   Briefcase | 4,195 reads

Automating Your SQL Server Best Practice Reports: The Document

If you're making a report from table-based data, an MS Word document is often a good option. In the second part of his introduction to SQL Server best-practice monitoring, Laerte Junior shows how to use PowerShell scripts to create a Word-based report with colour-coded alerts where there are problems or best practices aren't being followed.  Read more...
By Additional Articles 2015/11/12 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 7,830 reads

Powershell Functions

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

The Complete Guide to PowerShell Punctuation

It is the punctuation, the strange dollar signs, brackets and parentheses that bewilder anyone learning PowerShell. Add to that the aliases and you can bewilder everyone. The punctuation is essential, so here is the the complete PowerShell wallchart and guide to Powershell Punctuation. Thanks to Michael Sorens, PowerShell need no longer be perplexing.  Read more...
By Additional Articles 2015/10/26 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 3,439 reads

Capture the tasks performed in a text file

Creates a record of all or part of a Windows PowerShell session in a text file.  Read more...
Rating: |  Discuss |   Briefcase | 952 reads

PoSh: Get-WhoInstallSQL

Useful function that finds who installed SQL Server  Read more...
By Miguel Quintana 2015/09/28 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,041 reads

PowerShell Tool Time: Controlling Our Tools

The next installment of the Powershell Tool Time series shows you how to manage backup files by   Read more...
By Mike Fal 2015/09/16 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 3,825 reads

PowerShell and ADO.NET Connection String Settings for SQL Server

Tim Smith addresses some common questions from PowerShell developers about connection strings, errors with strings, and alternative development approaches to using connection strings.  Read more...
By Additional Articles 2015/09/11 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,155 reads

When to Quote in PowerShell

The one question about PowerShell that trips up almost everyone is about when and how to quote strings. Because PowerShell replaces the old command shell, it has to be able to work the way that it did with string parameters, but it also has to behave like a .NET scripting language to replace VBA. In this article, Michael Sorens explains the how and when of PowerShell quoting.  Read more...
By Additional Articles 2015/09/10 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,221 reads
<< Newer    Items 21 to 40 of 323    Older >>
 
Tags
blogs (35)    
smo (19)    
administration (17)    
stairway series (13)    
editorial (8)    
sql server (8)    
sql server 2005 (8)    
backup and restore (7)    
azure (6)    
integration services (ssis) (6)    
monitoring (6)    
amo (5)    
analysis services (ssas) (5)    
maintenance (5)    
active directory (4)    
agent jobs (4)    
backup (4)    
database weekly (4)    
sql agent (4)    
automation (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
restore (3)    
sql jobs (3)    
sql server 2012 (3)    
windows 2012 (3)    
cluster (2)    
clustering (2)    
database (2)    
dimensions (2)    
disk space (2)    
error log (2)    
extract, transform, load (etl) (2)    
indexing (2)    
logins (2)    
perfmon (2)    
policy based management (pbm) (2)    
recovery model (2)    
script (2)    
scripting (2)    
security (2)    
sql server 2008 (2)    
ssms (2)    
transaction log (2)    
t-sql (2)    
webinar (2)    
windows 2008 r2 (2)    
windows azure sql database (2)    
ado.net (1)    
ansi_nulls (1)    
auditing (1)    
availability groups (1)    
azure iaas vm (1)    
backups (1)    
best practice (1)    
bi (1)    
binary cmdlets (1)    
capacity planning (1)    
central management server (cms) (1)    
checkdb (1)    
cmdlets (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)    
desired state configuration (1)    
diagrams (1)    
dmv (1)    
document environment (1)    
documentation (1)    
documenting (1)    
domain (1)    
dsc (1)    
email (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)    
healthcheck (1)    
html (1)    
installation (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)    
posh (1)    
powershell tool time (1)    
profiler (1)    
quoted_identifier (1)    
r language (1)    
registered servers (1)    
remote servers (1)    
remoting (1)    
replication tracking (1)    
report (1)    
resource groups (1)    
resource monitor (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 (1)    
sql alerts (1)    
sql aliases (1)    
sql compare (1)    
sql discovery (1)    
sql server 7 (1)    
sql server service accounts (1)    
sql service accounts (1)    
sqlcmd (1)    
sqljob (1)    
sqljobs (1)    
sqlps (1)    
sqlpsx (1)    
sqlserver (1)    
string manipulation (1)    
textmode (1)    
trending (1)    
troubleshooting (1)    
twitter (1)    
uml (1)    
unattended install (1)    
unit testing (1)    
users (1)    
virtual chapters (1)    
virtualization (1)    
vm (1)    
windows cluster (1)    
windows management framework (1)    
wmi (1)    
wmi events queries (1)    
wql (1)    
xmla (1)