Index
A
- Active Directory Services Interface (ADSI) / Managing local users and groups
- Add-Member cmdlet
- about / Extending .NET objects
- Add-TfsPendingChange cmdlet / Managing changesets, shelvesets, and pending changes
- Add-User cmdlet / Introducing Windows PowerShell
- ad hoc remoting, PowerShell / Ad hoc remoting
- aliases
- using / Understanding and using aliases
- Application Programming Interface (API) / Introducing Windows PowerShell
- arithmetic operators / Comparison and logical operators
- arrays
- assembly file
- used, for defining object type / Defining an object type using an assembly name or file
- assembly name
- used, for defining object type / Defining an object type using an assembly name or file
B
- background job concept / The key features of Windows PowerShell
- Backup-Sqlcmd cmdlet / Example 3 – restoring the SQL Server database
- Backup SqlDatabase cmdlet / Example 2 – backing up the SQL Server database
- Best Practice Analyzer
- about / TFS Power Tools
- binary module
- about / The binary modules
- creating / Creating your first binary module
- bitwise operators / Comparison and logical operators
- breakpoints
- about / Working with breakpoints
- line breakpoint / Working with breakpoints
- variable breakpoint / Working with breakpoints
- command breakpoint / Working with breakpoints
C
- changesets
- CIM
- about / Understanding CIM and WMI
- in Windows PowerShell / CIM and WMI in Windows PowerShell
- features / More reasons to adopt CIM
- CIM Object Manager (CIMOM) / More reasons to adopt CIM
- cmdlet
- about / Introducing Windows PowerShell
- COM
- working with / Working with COM
- used, for automating Internet Explorer / Automating Internet Explorer with COM and PowerShell
- used, for automating Microsoft Excel / Automating Microsoft Excel with COM and PowerShell
- command breakpoint
- about / Working with breakpoints
- comments, PowerShell
- single-line / Comments in PowerShell
- multi-line block / Comments in PowerShell
- Common Engineering Criteria (CEC) program / Introducing Windows PowerShell
- Common Language Runtime (CLR) / Introducing Windows PowerShell
- common parameters, PowerShell
- Verbose / PowerShell's common parameters
- Debug / PowerShell's common parameters
- ErrorAction / PowerShell's common parameters
- ErrorVariable / PowerShell's common parameters
- WarningAction / PowerShell's common parameters
- WarningVariable / PowerShell's common parameters
- WhatIf / PowerShell's common parameters
- Confirm / PowerShell's common parameters
- OutBuffer / PowerShell's common parameters
- OutVariable / PowerShell's common parameters
- COM object
- instance, creating of / Creating an instance of a COM object
- comparison operators / Comparison and logical operators
- Component Object Model (COM) / Introducing Windows PowerShell
- conditional execution / Conditional execution
- Connect-PSSession cmdlet
- about / Persistent session
- constrained runspaces / The key features of Windows PowerShell
- ConvertFrom-Json cmdlet
- ConvertTo-Json cmdlet
- ConvertTo-WebApplication cmdlet / Creating a new web application
- ConvertTo-Xml cmdlet / Importing and exporting XML files
D
- data types
- using / Using variables and data types
- Deployment Image Servicing and Management (DISM) tools / Installing Windows roles and features
- Desired State Configuration (DSC) / The key features of Windows PowerShell
- Disable-PSBreakpoint cmdlet
- about / Working with breakpoints
- Disable-PSRemoting cmdlet
- about / Windows PowerShell remoting
- Disable-WindowsOptioanlFeature cmdlet / Uninstalling Windows roles and features
- Disconnect-PSSession cmdlet
- about / Persistent session
- Distributed Management Task Force (DMTF) / Understanding CIM and WMI
- Dynamic Language Runtime (DLR) / Introducing Windows PowerShell
- dynamic module
- about / The dynamic modules
E
- $Error variable / The $Error and $LastExistCode variables
- Enable-PSBreakpoint cmdlet
- about / Working with breakpoints
- Enable-PSRemoting cmdlet / Windows PowerShell remoting
- Enable-WindowsOptionalFeature cmdlet / Uninstalling Windows roles and features
- Enter-PSSession cmdlet / Interactive remoting
- error-handling / The key features of Windows PowerShell
- error handling techniques
- about / Error-handling techniques
- execution, PowerShell Workflow
- sequential execution / Sequential execution
- parallel execution / Parallel execution
- inlineScript activity / InlineScript activity
- controlling / Controlling the PowerShell workflow execution
- Exit-PSSession cmdlet
- about / Interactive remoting
- Export-Alias cmdlet
- about / Understanding and using aliases
- Export-CliXml cmdlet / Importing and exporting XML files
- Export-ModuleMember cmdlet
- about / The script modules
- Export-PSSession cmdlet / Implicit remoting
- Extensible Markup Language (XML) / Introducing Windows PowerShell
F
- F12 developer tools
- features, Windows PowerShell
- modules auto-loading / The Integrated Scripting Environment (ISE)
- cmdlets discovery / The Integrated Scripting Environment (ISE)
- add-on tools / The Integrated Scripting Environment (ISE)
- autosave / The Integrated Scripting Environment (ISE)
- Show-Command cmdlet / The Integrated Scripting Environment (ISE)
- remoting feature / The key features of Windows PowerShell
- background job / The key features of Windows PowerShell
- scheduled job / The key features of Windows PowerShell
- steppable pipeline / The key features of Windows PowerShell
- script debugging / The key features of Windows PowerShell
- error handling / The key features of Windows PowerShell
- constrained runspaces / The key features of Windows PowerShell
- tab-expansion feature / The key features of Windows PowerShell
- Windows PowerShell Web Access / The key features of Windows PowerShell
- Windows PowerShell Web Service / The key features of Windows PowerShell
- Online and Updateable help / The key features of Windows PowerShell
- Windows PowerShell Workflow / The key features of Windows PowerShell
- Desired State Configuration (DSC) feature / The key features of Windows PowerShell
- files
- downloading, from Internet / Example 1 – downloading files from the Internet
- Format-Table cmdlet
- FTP site
- creating / Creating an FTP site
- functions
- about / Using functions
- syntax / Using functions
- fundamentals, Windows PowerShell
- objects / Working with objects
- pipelines / Understanding the piping and pipelines
- piping / Understanding the piping and pipelines
- aliases / Understanding and using aliases
- variables / Using variables and data types
- data types / Using variables and data types
- comparison operators / Comparison and logical operators
- logical operators / Comparison and logical operators
- arrays / Working with arrays and hash tables
- hash tables / Working with arrays and hash tables
- scripts flow / Script flow and execution control
- conditional execution / Script flow and execution control
- functions / Using functions
- providers / Understanding providers and drives
- drives / Understanding providers and drives
- scripts files / Working with script files
- comments / Comments in PowerShell
- help / Using help in Windows PowerShell
- common parameters / PowerShell's common parameters
G
- GeoIP web service
- Get-ChildItem cmdlet
- Get-CimInstance cmdlet
- Get-Command cmdlet / CIM and WMI in Windows PowerShell
- Get-Content cmdlet
- about / Loading XML files
- using / Using the Get-Content cmdlet
- Get-EvenOrOdd cmdlet
- Get-Help cmdlet
- about / Using help in Windows PowerShell
- Get-Item cmdlet / Working with web application pools
- Get-ItemProperty cmdlet
- Get-Job cmdlet / Controlling the PowerShell workflow execution
- Get-Module cmdlet
- Get-Process cmdlet / Interactive remoting, Ad hoc remoting
- Get-Service cmdlet / Introducing Windows PowerShell, Ad hoc remoting, InlineScript activity
- Get-TfsChildItem cmdlet / Working with TFS items' information
- about / Working with TFS items' information
- parameters / Working with TFS items' information
- Get-TfsItemHistory cmdlet / Working with TFS items' information
- Get-TfsItemProperty cmdlet / Working with TFS items' information
- Get-TfsServer cmdlet / Getting started with TFS PowerShell cmdlets, Retrieving TFS information
- Get-TfsWorkspace cmdlet / Getting started with TFS PowerShell cmdlets
- about / Managing TFS workspace
- Get-WebConfigurationBackup cmdlet / Backing up and restoring the web configuration
- Get-WindowsFeature cmdlet / Working with Windows roles and features
- Get-WindowsOptionalFeature cmdlet / Uninstalling Windows roles and features
- Get-WmiObject -List cmdlet / CIM and WMI in Windows PowerShell
- Get-WmiObject cmdlet / CIM and WMI in Windows PowerShell
- Get CimClass cmdlet / CIM and WMI in Windows PowerShell
- GetGeoIPContext() method
- GOOG
- group
- user account, adding to / Adding and removing a user account to and from a group
- user account, removing from / Adding and removing a user account to and from a group
- groups
- managing / Managing local users and groups
- listing / Listing all the existing users and groups
- GUI
- building, with PowerShell / Building GUI with PowerShell
H
- hash tables
- Here-String
I
- IIS web application
- creating / Creating a new web application
- IIS website
- creating / Creating a new website
- implicit remoting, PowerShell / Implicit remoting
- Import-Alias cmdlet
- about / Understanding and using aliases
- Import-CliXml cmdlet / Importing and exporting XML files
- Import-Module cmdlet / Managing web servers – IIS
- Import-PSSession cmdlet
- parameters / Implicit remoting
- inline C# class
- used, for defining object type / Defining the object type using an inline C# class
- inlineScript activity, PowerShell Workflow / InlineScript activity
- Install-WindowsFeature cmdlet / Working with Windows roles and features
- Install WindowsFeature cmdlet
- parameters / Installing Windows roles and features
- instance
- creating, of COM object / Creating an instance of a COM object
- Integrated Development Environment (IDE) / The Integrated Scripting Environment (ISE)
- Integrated Scripting Environment (ISE) / Windows PowerShell consoles, The Integrated Scripting Environment (ISE)
- interactive remoting, PowerShell / Interactive remoting
- Internet
- files, downloading from / Example 1 – downloading files from the Internet
- Internet Explorer
- automating, with COM / Automating Internet Explorer with COM and PowerShell
- automating, with PowerShell / Automating Internet Explorer with COM and PowerShell
- Internet Explorer Object Model
- Invoke-RestMethod cmdlet
- Invoke-WebRequest cmdlet
- Invoke Sqlcmd cmdlet / Example 1 – executing the T-SQL statement
- iterations statements / Iterations statements
J
- JSON
- working with / Working with JSON
- about / Working with JSON
- JSON, to PowerShell format
- objects, converting from / Example 2 – converting objects from JSON to the PowerShell format
- JSON format
- objects, converting to / Example 1 – converting objects into the JSON format
L
- $LastExistCode variable / The $Error and $LastExistCode variables
- line breakpoint
- about / Working with breakpoints
- local user account
- creating / Creating a new local user account
- modifying / Modifying an existing local user account
- removing / Removing an existing local user account
- local users
- managing / Managing local users and groups
- logical operators / Comparison and logical operators
M
- manifest module
- about / The manifest modules
- Microsoft CEC
- Microsoft Developers Network (MSDN)
- about / TFS Power Tools
- Microsoft Excel
- automating, with COM / Automating Microsoft Excel with COM and PowerShell
- automating, with PowerShell / Automating Microsoft Excel with COM and PowerShell
- Microsoft Forefront Identity Management (FIM)
- Microsoft Visual / The Integrated Scripting Environment (ISE)
- MSFT
- multi-line block comment / Comments in PowerShell
N
- .NET framework types
- extending / Extending .NET framework types
- .NET objects
- working with / Working with .NET objects
- creating / Creating .NET objects
- extending / Extending .NET objects
- New-Module cmdlet
- about / The dynamic modules
- New-ModuleManifest cmdlet
- about / The manifest modules
- New-Object cmdlet
- about / Creating an instance of a COM object, Automating Internet Explorer with COM and PowerShell, Defining the object type using an inline C# class, Defining an object type using an assembly name or file
- New-PSSession cmdlet
- about / Persistent session
- New-TfsShelveset cmdlet / Managing changesets, shelvesets, and pending changes
- New-WebApplication cmdlet / Creating a new web application
- New-WebAppPool cmdlet / Working with web application pools
- New-WebBinding cmdlet / Creating and modifying an existing website binding
- New-WebFtpSite cmdlet / Creating an FTP site
- New-WebServiceProxy cmdlet
- about / Working with web services
- New-WebVirtualDirectory cmdlet
- about / Creating a new virtual directory
O
- objects
- working with / Working with objects
- converting, to JSON format / Example 1 – converting objects into the JSON format
- converting, from JSON to PowerShell format / Example 2 – converting objects from JSON to the PowerShell format
- object type
- extending, inline C# class used / Defining the object type using an inline C# class
- defining, assembly file used / Defining an object type using an assembly name or file
- defining, assembly name used / Defining an object type using an assembly name or file
- Online and Updateable help / The key features of Windows PowerShell
- Open Management Infrastructure (OMI) / More reasons to adopt CIM
- operators, PowerShell
- arithmetic / Comparison and logical operators
- comparison / Comparison and logical operators
- wildcard / Comparison and logical operators
- RegEx match / Comparison and logical operators
- logical / Comparison and logical operators
- bitwise / Comparison and logical operators
- Out-GridView cmdlet
P
- parallel execution, PowerShell Workflow / Parallel execution
- pending changes
- persistent session, PowerShell / Persistent session
- persistent workflows / Persistent workflows
- pipeline
- piping
- PowerShell
- used, for automating Internet Explorer / Automating Internet Explorer with COM and PowerShell
- used, for automating Microsoft Excel / Automating Microsoft Excel with COM and PowerShell
- GUI, building with / Building GUI with PowerShell
- used, for creating workflow / Creating a workflow using PowerShell
- web cmdlets / Web cmdlets in PowerShell
- used, for finding YouTube videos / Example 1 – finding YouTube videos using PowerShell
- PowerShell Provider
- PowerShell remoting
- PowerShell Web Service (PSWS) / The key features of Windows PowerShell
- PowerShell Workflow
- execution, controlling / Controlling the PowerShell workflow execution
- PowerShell workflow
- executing / Executing a PowerShell Workflow
- providers
- PSBreakpoint cmdlets
R
- Receive-Job cmdlet / Controlling the PowerShell workflow execution
- RegEx match operator / Comparison and logical operators
- Register CimIndicationEvent cmdlet
- Register WmiEvent cmdlet
- registry
- Remove-CimInstance cmdlet / CIM and WMI in Windows PowerShell
- Remove-PSBreakpoint cmdlet
- about / Working with breakpoints
- Remove-PSSession cmdlet
- about / Persistent session
- Remove-WebConfigurationBackup cmdlet / Backing up and restoring the web configuration
- Remove-WmiObject cmdlet / CIM and WMI in Windows PowerShell
- REST APIs
- using / Using REST APIs
- Restart-Computer cmdlet / Introducing Windows PowerShell
- Restore SqlDatabase cmdlet / Example 3 – restoring the SQL Server database
- Resume-Job cmdlet / Controlling the PowerShell workflow execution
- Rstore-Sqlcmd cmdlet / Example 3 – restoring the SQL Server database
S
- SAPIEN PowerShell Studio / Building GUI with PowerShell
- scheduled job / The key features of Windows PowerShell
- script
- debugging / Debugging your script
- script debugging / The key features of Windows PowerShell
- script module
- about / The script modules
- creating / The script modules
- scripts files
- working with / Working with script files
- Select-Object cmdlet / Understanding and using aliases
- about / Using the Select-Xml cmdlet
- Select-Xml cmdlet
- about / Loading XML files, Using the Select-Xml cmdlet
- using / Using the Select-Xml cmdlet
- semicolon
- about / Using variables and data types
- sequential execution, PowerShell Workflow / Sequential execution
- Server Management object (SMO) / Example 4 – generating the SQL script for a database, tables, and stored procedures
- Set-CimInstance cmdlet
- Set-ExecutionPolicy cmdlet / Working with script files
- Set-Item cmdlet / Working with web application pools
- Set-Location cmdlet
- Set-WebBinding cmdlet / Creating and modifying an existing website binding
- Set WmiInstance cmdlet
- shelvesets
- Show-Command cmdlet / The Integrated Scripting Environment (ISE)
- Simple Object Access Protocol (SOAP)
- about / Working with web services
- single-line comment / Comments in PowerShell
- Sort-Object cmdlet / Understanding and using aliases
- SQL Server
- about / SQL Server and Windows PowerShell
- and Windows PowerShell / SQL Server and Windows PowerShell
- SQL Server Management Studio (SSMS) / Loading SQL Server PowerShell
- SQL Server PowerShell
- loading / Loading SQL Server PowerShell
- launching, from SSMS / Launching the SQL Server PowerShell from SSMS
- SQL Server PowerShell module
- importing / Importing SQL Server PowerShell module
- SQL Server Reporting Services (SSRS) / Managing local users and groups
- SQL Server scripting
- working with / Working with the SQL Server scripting
- T-SQL statement, executing / Example 1 – executing the T-SQL statement
- SQL Server database, backing up / Example 2 – backing up the SQL Server database
- SQL Server database, restoring / Example 3 – restoring the SQL Server database
- SQL script, generating for database / Example 4 – generating the SQL script for a database, tables, and stored procedures
- SQL script, generating for tables / Example 4 – generating the SQL script for a database, tables, and stored procedures
- SQL script, generating for stored procedures / Example 4 – generating the SQL script for a database, tables, and stored procedures
- SSMS
- SQL Server PowerShell, launching from / Launching the SQL Server PowerShell from SSMS
- steppable pipeline / The key features of Windows PowerShell
- Stock Quote web service
- stock symbol
T
- T-SQL statement
- executing / Example 1 – executing the T-SQL statement
- tab-expansion feature / The key features of Windows PowerShell
- Team Foundation Server 2013 Object Model / Managing changesets, shelvesets, and pending changes
- TF Command-Line Utility / Getting started with TFS PowerShell cmdlets
- TFS 2012 Update 4 Object Model
- URL, for downloading / Managing changesets, shelvesets, and pending changes
- TFS 2013 Object Model
- URL, for downloading / Managing changesets, shelvesets, and pending changes
- TFS information
- retrieving / Retrieving TFS information
- TFS items' information
- working with / Working with TFS items' information
- TFS PowerShell cmdlets
- TFS Power Tools
- about / TFS Power Tools
- TFS workspace
- managing / Managing TFS workspace
U
- Uninstall-WindowsFeature cmdlet / Working with Windows roles and features
- Uninstall WindowsFeature cmdlet / Uninstalling Windows roles and features
- Update-TfsWorkspace cmdlet
- about / Managing TFS workspace
- user account
- adding, to group / Adding and removing a user account to and from a group
- removing, from group / Adding and removing a user account to and from a group
- users
V
- Validate-EmailAddress cmdlet
- variable breakpoint
- about / Working with breakpoints
- variables
- using / Using variables and data types
- session configuration / Using variables and data types
- preferences settings / Using variables and data types
- virtual directory
- creating / Creating a new virtual directory
- virtual hard disk (VHD) / Installing Windows roles and features
- Visual Studio Gallery
- about / TFS Power Tools
- Visual Studio Team Foundation Server 2012 Power Tools
- URL / TFS Power Tools
- Visual Studio Team Foundation Server 2013 Power Tools
- URL / TFS Power Tools
W
- Web-Based Enterprise Management (WBEM) / Understanding CIM and WMI
- web application pools
- about / Working with web application pools
- working with / Working with web application pools
- web cmdlets, PowerShell
- about / Web cmdlets in PowerShell
- web configuration
- backing up / Backing up and restoring the web configuration
- restoring / Backing up and restoring the web configuration
- web feeds
- reading / Example 2 – reading web feeds
- web requests
- working with / Working with web requests
- web servers
- managing / Managing web servers – IIS
- web services
- working with / Working with web services
- GeoIPService / Example 1 – using the GeoIPService web service
- Stock Quote web service / Example 2 – using the Stock Quote web service
- Web Services Description Language (WSDL)
- about / Working with web services
- website binding
- Where-Object cmdlet / Understanding and using aliases
- wildcard operators / Comparison and logical operators
- Windows Management Framework (WMF) / Introducing Windows PowerShell
- Windows Management Instrumentation (WMI) / Introducing Windows PowerShell
- Windows PowerShell
- about / Introducing Windows PowerShell
- features / The Integrated Scripting Environment (ISE), The key features of Windows PowerShell
- help, using / Using help in Windows PowerShell
- parameters / PowerShell's common parameters
- working / Windows PowerShell in action
- local users, managing / Managing local users and groups
- groups, managing / Managing local users and groups
- local user account, creating / Creating a new local user account
- existing local user account, modifying / Modifying an existing local user account
- user account, adding to group / Adding and removing a user account to and from a group
- user account, removing from group / Adding and removing a user account to and from a group
- existing local user account, removing / Removing an existing local user account
- existing users, listing / Listing all the existing users and groups
- existing groups, listing / Listing all the existing users and groups
- web servers, managing / Managing web servers – IIS
- and SQL Server / SQL Server and Windows PowerShell
- Windows PowerShell console
- about / The Windows PowerShell console
- Windows PowerShell consoles
- about / Windows PowerShell consoles
- Integrated Scripting Environment (ISE) / The Integrated Scripting Environment (ISE)
- Windows PowerShell ISE / The Integrated Scripting Environment (ISE)
- Windows PowerShell Modules
- about / Understanding Windows PowerShell Modules
- creating / Creating Windows PowerShell Modules
- script module / The script modules
- binary module / The binary modules
- manifest module / The manifest modules
- dynamic module / The dynamic modules
- Windows PowerShell remoting
- about / Windows PowerShell remoting
- interactive remoting / Interactive remoting
- ad hoc remoting / Ad hoc remoting
- persistent session / Persistent session
- implicit remoting / Implicit remoting
- Windows PowerShell snap-in
- Windows PowerShell Web Access / The key features of Windows PowerShell
- Windows PowerShell Workflow / The key features of Windows PowerShell
- Windows PowerShell Workflow (PSW)
- Windows Presentation Foundation (WPF) / The Integrated Scripting Environment (ISE)
- Windows Remote Management (WinRM) / Introducing Windows PowerShell
- Windows Server
- roles, managing / Working with Windows roles and features
- features, managing / Working with Windows roles and features
- feature, installing / Installing Windows roles and features
- roles, installing / Installing Windows roles and features
- roles, uninstalling / Uninstalling Windows roles and features
- features, uninstalling / Uninstalling Windows roles and features
- Windows Workflow Foundation (WF) / Windows PowerShell Workflow (PSW)
- WinRM
- about / Windows PowerShell remoting
- WMI
- in Windows PowerShell / CIM and WMI in Windows PowerShell
- workflow
- creating, PowerShell used / Creating a workflow using PowerShell
- WQL / CIM and WMI in Windows PowerShell
- WS-Management (WS-MAN) protocol / More reasons to adopt CIM
X
- XML
- working with / Working with XML
- XML file
- loading / Loading XML files
- XML files
- importing / Importing and exporting XML files
- exporting / Importing and exporting XML files
Y
- YouTube videos
- finding, PowerShell used / Example 1 – finding YouTube videos using PowerShell