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

Articles with tag powershell Rss

Search for any content tagged powershell

   Items 1 to 20 of 193    Older >>
 

PowerShell Tool Time: The Tool Framework

Start learning Powershell (PoSh) for SQL Server and improve your ability to write utilities that will make your job easier.  Read more...
By Mike Fal 2015/08/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 5,130 reads

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 | 3,090 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 | 4,112 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,476 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,674 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,730 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,986 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,445 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,632 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,864 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,780 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

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

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,792 reads

Data Mining: Part 13 Powershell

In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.  Read more...
By Daniel Calbimonte 2014/08/12 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 5,503 reads

Using PowerShell to Manage Windows Azure SQL Databases

Marcin Policht provides a comprehensive overview of Windows PowerShell’s capabilities in regard to managing SQL Databases (or, in general, cloud-resident resources).  Read more...
By Additional Articles 2014/07/18 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 2,637 reads
   Items 1 to 20 of 193    Older >>