How to Install the PowerShell Cmdlets for Apache™ Hadoop™-based Services for Windows

How to Install the PowerShell Cmdlets for Apache™ Hadoop™-based Services for Windows Small Bites of Big Data Cindy Gross, SQLCAT PM   UPDATED JUNE 2013 – The very early version of PowerShell cmdlets I discussed below have been replaced – see Managing Your HDInsight Cluster with PowerShell http://blogs.msdn.com/b/carlnol/archive/2013/06/07/managing-your-hdinsight-cluster-with-powershell.aspx We have a cool new addition to Microsoft’s…


SQL PowerShell Demo – Intro

SQL PowerShell Demo – Intro Cindy Gross, Dedicated Support Engineer   Audience: SQL Server DBAs and/or developers who are familiar with basic SQL Server commands, SQL Server Management Studio (SSMS), and SQL Agent jobs. 0.     Prerequisites Read the introductory “PowerShell For SQL Server Basics” 1.     Install Basics Check what version of PowerShell you currently have on…


PowerShell for SQL Server – Basics

PowerShell for SQL Server – Basics Cindy Gross, Dedicated Support Engineer  Audience: SQL DBAs and/or developers who are familiar with basic SQL Server commands, SQL Server Management Studio (SSMS), and SQL Agent jobs. Basics PowerShell processes objects based on .NET. Cmdlets are named in a Verb-Noun format such as Start-Service and Get-Help. For help on…

2

PowerShell for SQL – Getting Started

PowerShell for SQL – Getting Started Cindy Gross, Dedicated Support Engineer You may want to use PowerShell to automate SQL activities such as backups. There are various ways to automate backups. For example, you can centralize the backup calls on an admin server which has some type of list of instances and databases and possibly…