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

Creating PowerShell Stacks and Expression Evaluators

To demonstrate that dynamic modules in PowerShell can be used to easily create objects with methods and properties, Phil Factor implements an expression analyser written in PowerShell, using a variation of Dijstra's Shunting Algorithm.  Read more...
By Additional Articles 2016/09/16 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 5,184 reads

Towards a Single Management Stack

Phil Factor argues that with both SQL Server and PowerShell now running on Linux, the latter becomes increasingly important in achieving the goal of a single management stack for databases across all hosting environments.  Read more...
By Phil Factor 2016/09/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 47 reads

Get-SqlLogin and Remove-SqlLogin Are Here

Learn how to use the login commands included with SSMS2016 from PowerShell.  Read more...
By Aaron Nelson 2016/09/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,793 reads

Generate password using PowerShell

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

Simple T-SQL Code Comparison With PowerShell

Tim Smith shows how you can use PowerShell to automate a simple comparison of objects such as stored procedures, views, and fucntions.  Read more...
By Additional Articles 2016/08/17 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,351 reads

PowerShell Desired State Configuration: Automating and Monitoring Pull mode

The Pull mode of Desired State Configuration (DSC) is more complicated to implement because you need to meticulously manage the MOF files and their naming conventions so as to ensure that you deploy your DSC configurations correctly. In this first article of a two-part series, Nicolas Prigent describes how you can best automate this, and then in a second part on monitoring DSC he describes techniques to help you to use the pull mode as a regular part of your admin work.  Read more...
By Additional Articles 2016/07/22 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,843 reads

Using Powershell to run queries on remote server .

This is a function written in powershell , which can used to run queries remotely   Read more...
By himanshu.sinha 2016/07/20 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 647 reads

Capture Linux Drive Space data with Powershell

Capture Linux Drive Space data with Powershell using Posh-SSH module   Read more...
By Michael D'Spain 2016/07/19 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 177 reads

Stairway to Server Management Objects (SMO) Level 2: Connections and Creating Server Inventories

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2016/07/13 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 1,113 reads

The cmdlets Are Coming! The cmdlets Are Coming!

A number of new SQL Server PowerShell cmdlets have been released and the Microsoft is asking for feedback on what else you'd like to see.  Read more...
By Aaron Nelson 2016/07/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,156 reads

PowerShell Interview Questions for SQL Server DBAs

With PowerShell playing a more important role in administration of various types of servers, more SQL Server DBA candidates should have PowerShell knowledge and skills. In this article, Jeffrey Yao lists some common SQL Server DBA tasks that may be completed easier with PS than T-SQL.  Read more...
By Additional Articles 2016/06/29 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,999 reads

Send Email to recipients with Attachment using PowerShell

If you have a requirement to send email to recipients with attachment, can use the script.  Read more...
Rating: |  Discuss |   Briefcase | 544 reads

Persistent PowerShell: The PowerShell Profile

You can mould PowerShell to the way you want to work, with all the settings and modules that you require, by using the profiles. Profiles are PowerShell scripts that run at startup, and once you have understood where they are and when each is used, they have a whole range of uses that make using PowerShell a lot more convenient.   Read more...
By Additional Articles 2016/06/24 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 5,124 reads

The PoSh DBA: Accessing SQL Server from PowerShell

The worst part for a DBA of getting started with PowerShell is often just figuring out the best way of working with SQL Server. The most suitable approach to accessing SQL Server depends on the sort of task you need to produce a script for. Laerte Junior aims at a simple guide to the most common approaches and when to use them.  Read more...
By Additional Articles 2016/06/14 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,538 reads

PowerShell Desired State Configuration: Pull Mode

Automated configuration management is simpler with Desired State Configuration (DSC) and Push mode, but what is the best way to use DSC to automate deployments on your machines? ‘Push’ mode or ‘Pull’ mode? How can you reduce configuration-drift over time? Nicolas Prigent describes the second DSC deployment mode: Pull mode.  Read more...
By Additional Articles 2016/06/13 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,062 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,990 reads

Automatically Creating UML Database Diagrams for SQL Server

SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want, other than a vast Entity-relationship diagram. However, you can do it without buying any third-party tool, just using some existing Java-based open-source tools; and can even automate it entirely, using SQL and PowerShell. Phil Factor shows how.  Read more...
By Additional Articles 2016/05/27 | Source: SimpleTalk | Category: diagrams
Rating: (not yet rated)  Rate this |   Briefcase | 4,316 reads

Unified Approach to Generating Documentation for PowerShell Cmdlets

Now, it is easy to provide professional-quality documentation for PowerShell cmdlets, and to keep it in sync when you make changes, whether they are written in PowerShell or C#. While this has always been easy to do in PowerShell, it was always painful to do in C# or VB because it meant having to build your own MAML file. Michael Sorens completes his three-part series by summarising, in a wallchart, how to go about it.  Read more...
By Additional Articles 2016/05/24 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,288 reads

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2016/05/11 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 2,710 reads

Execute SQL Script against Multiple Servers by PowerShell

Execute SQL Script against Multiple Servers by PowerShell  Read more...
By Raushan 2016/05/09 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,407 reads
<< Newer    Items 21 to 40 of 355    Older >>
 
Tags
blogs (35)    
smo (21)    
administration (20)    
stairway series (14)    
editorial (10)    
sql server (8)    
sql server 2005 (8)    
backup and restore (7)    
azure (6)    
backup (6)    
integration services (ssis) (6)    
monitoring (6)    
amo (5)    
analysis services (ssas) (5)    
database weekly (5)    
maintenance (5)    
active directory (4)    
agent jobs (4)    
restore (4)    
sql (4)    
sql agent (4)    
automation (3)    
desired state configuration (3)    
logins (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
security (3)    
sql jobs (3)    
sql server 2012 (3)    
t-sql (3)    
windows 2012 (3)    
cluster (2)    
clustering (2)    
database (2)    
dimensions (2)    
disk space (2)    
dsc (2)    
error log (2)    
extract, transform, load (etl) (2)    
indexing (2)    
perfmon (2)    
policy based management (pbm) (2)    
recovery model (2)    
registered servers (2)    
script (2)    
scripting (2)    
server (2)    
size (2)    
sql server 2008 (2)    
sqlcmd (2)    
ssms (2)    
transaction log (2)    
webinar (2)    
windows 2008 r2 (2)    
windows azure sql database (2)    
ado (1)    
ado.net (1)    
ansi_nulls (1)    
auditing (1)    
availability groups (ag) (1)    
azure iaas vm (1)    
backups (1)    
bcp (1)    
best practice (1)    
bi (1)    
binary cmdlets (1)    
c# (1)    
capacity planning (1)    
central management server (cms) (1)    
checkdb (1)    
cmdlets (1)    
command line install (1)    
compare (1)    
compare windows hotfix (1)    
connectivity (1)    
copy (1)    
create (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)    
datafile (1)    
dba (1)    
dbatools.io (1)    
dbcc checkdb (1)    
diagrams (1)    
dmv (1)    
document environment (1)    
documentation (1)    
documenting (1)    
domain (1)    
drive space (1)    
email (1)    
enterprise manager (1)    
epm (1)    
error handling (1)    
event log (1)    
events (1)    
export (1)    
extracting data (1)    
extracting data with header (1)    
file system task (1)    
find stored procedures (1)    
fragmentation (1)    
free training (1)    
get-sqllogin (1)    
healthcheck (1)    
html (1)    
import-module (1)    
installation (1)    
interactive (1)    
introduction (1)    
linux (1)    
log shipping (1)    
logfile (1)    
management (1)    
migration (1)    
mirroring (1)    
monitor (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)    
postgres (1)    
powershell tool time (1)    
profiler (1)    
query (1)    
quoted_identifier (1)    
r language (1)    
remote (1)    
remote servers (1)    
remoting (1)    
remove-sqllogin (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)    
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 connections (1)    
sql server service accounts (1)    
sql service accounts (1)    
sqlite (1)    
sqljob (1)    
sqljobs (1)    
sqlps (1)    
sqlpsx (1)    
sqlserver (1)    
stored procedures (1)    
string manipulation (1)    
text (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)