Index

A

• ActiveDirectory / Introduction
• Add-Content cmdlet
  • about / How it works...
• AFTER trigger
  • creating, in PowerShell / How to do it..., How it works...
• aliases
  • testing, in PowerShell / How to do it..., How it works...
• APIPA scheme
  • about / Configuring a domain controller
• arrays
  • about / Arrays and hash tables, Arrays
• assembly
  • creating, in SQL Server / How to do it..., How it works...
• asymmetric keys
  • creating / Getting ready, How to do it..., How it works..., There's more...
• attachment
  • e-mail, sending with / Sending e-mail, There's more...
• authentication modes
  • listing, PowerShell used / Getting ready, How it works...
  • listing, SMO used / Getting ready, How it works...
  • modifying / Changing authentication mode, Getting ready, How it works..., There's more...

B

• backtick
  • about / Escape and line continuation
• Backup-ASDatabase cmdlet / How it works...
• Backup-SqlDatabase cmdlet
  • about / How it works...
  • used, for creating filegroup backup / Creating a filegroup backup, How it works...
• backup device
  • creating, PowerShell used / Getting ready, How to do it..., How it works...
• backup file
  • backup header information, listing from / Listing backup header and file list information, How to do it..., How it works...
  • backup header information, listin<?AID 0013?> XE / How it works...
• back up files
  • gathering / Step 1 – Gather your backup files
• backup header information
  • listing, from backup file / Listing backup header and file list information, How to do it..., How it works...
• backup history
  • listing, for SQL Server instance / Listing backup history, How to do it..., How it works...
• BackupRestoreBase
  • about / More about Backup and PercentCompleteEventHandler
• bcp
  • about / Performing bulk export using bcp
  • used, for performing bulk export / How to do it..., How it works...
  • used, for performing bulk import / Getting ready, How to do it..., How it works...
• binary data
  • storing, into SQL Server / Storing binary data into SQL Server, How to do it..., How it works...
  • extracting, from SQL Server / Extracting binary data from SQL Server, How to do it..., How it works...
• block comments
  • about / Comments, Comments
• blocking process
  • killing, in SQL Server / Getting ready, How to do it..., How it works...
• blocking processes
  • listing, in SQL Server instance / Listing running/blocking processes, How to do it..., How it works...
• bulk export, performing
  • Invoke-Sqlcmd used / Performing bulk export using Invoke-Sqlcmd, How to do it..., How it works...
  • bcp used / How to do it..., How it works...
• bulk import, performing
  • BULK INSERT used / Getting ready, How it works...
  • bcp used / Getting ready, How to do it..., How it works...
• BULK INSERT
  • used, for performing bulk import / Getting ready, How it works...
• BulkLogged recovery model
  • about / There's more...
• Business Intelligence (BI)
  • about / Introduction
• Business Intelligence Development Studio (BIDS) / How it works...

C

• C# code / Introduction
  • embedding, in PowerShell / How to do it..., How it works...
• callable code block
  • about / Package and reuse
• Cascading Style Sheets (CSS)
  • about / How it works...
• cell-level encryption
  • setting up, steps / There's more...
• certificate
  • creating, PowerShell used / How to do it...
  • creating, SMO used / How it works...
  • about / There's more...
• change tracking
  • enabling, to target database / Getting ready, How to do it..., There's more...
  • disabling, to target database / Getting ready, How to do it..., There's more...
• change tracking (CT)
  • about / There's more...
• ChangeTrackingEnabled property / How it works...
• Cisco / Introduction
• Citrix / Introduction
• Clear-Host cmdlet
  • about / Common aliases
• cmdlets / Introduction
  • about / How it works..., Cmdlets, Common Cmdlets
• cmdlets, file manipulation
  • Test-Path / How it works...
  • Join-Path / How it works...
  • New-Item / How it works...
  • Get-Content / How it works...
  • Add-Content / How it works...
  • Copy-Item / How it works...
  • Move-Item / How it works...
  • Remove-Item / How it works...
• cmdlets, folder manipulation
  • Get-ChildItem / How it works...
  • Test-Path / How it works...
  • New-Item / How it works...
  • Copy-Item / How it works...
  • Move-Item / How it works...
  • Remove-Item / How it works...
• Code Access Security (CAS)
  • about / There's more...
• Comma-Separated Value (CSV) / How it works...
• commands
  • chaining / You can chain commands
• comment-based help
  • about / How it works...
  • URL, for info / There's more...
• comments
  • about / Comments, Comments
• Common Language Runtime (CLR)
  • about / Introduction, How it works...
• common operators, PowerShell / Common operators
• common patterns, regular expressions / How it works...
• Compare-Object cmdlet
  • about / Common aliases
• concepts, PowerShell
  • cmdlets / Cmdlets
  • object oriented / PowerShell is object oriented, and works with .NET
  • .NET / PowerShell is object oriented, and works with .NET
  • aliases, of cmdlets / Cmdlets may have aliases or you can create one
  • commands, chaining / You can chain commands
  • package / Package and reuse
• condition
  • about / Creating a condition
  • creating / Getting ready, How to do it..., How it works...
• conditional statements
  • about / Conditions
• configuration settings, SQL Server
  • listing / Listing SQL Server configuration settings, How to do it..., How it works...
• configuring
  • domain controller / Configuring a domain controller
• ConnectionInfoBase class
  • about / How it works...
• ConnectionInfoExtended library
  • about / How it works..., How it works...
• ConnectionInfo library
  • about / How it works..., How it works...
• contents
  • extracting, of trace file / Getting ready, How to do it..., How it works...
• Continue() method
  • about / There's more...
• ConvertFrom-Csv cmdlet
  • about / Common Cmdlets
• ConvertFrom-Json cmdlet
  • about / Common Cmdlets
• ConvertFrom-SecureString cmdlet
  • about / Common Cmdlets
• ConvertTo-Csv cmdlet
  • about / Common Cmdlets
• ConvertTo-Html cmdlet
  • about / Common Cmdlets
• ConvertTo-Json cmdlet
  • about / Common Cmdlets
• ConvertTo-SecureString cmdlet
  • about / Common Cmdlets
• ConvertTo-Xml cmdlet
  • about / Common Cmdlets
• Copy-Item cmdlet
  • about / How it works..., How it works..., Common aliases
• CreateCatalogItem method
  • about / How it works...
• CreateFolderOnSqlServer method / How it works...
• Create method / How it works...
• credential
  • creating / Creating a credential, How to do it..., How it works...
• credentials
  • about / Getting credentials
• CSV
  • Get-Process cmdlet, exporting to / How to do it..., How it works...
• Cumulative Update (CU)
  • about / There's more...

D

• .dtsx file
  • SSIS package, downloading to / Downloading an SSIS package to a file, How it works...
• data
  • extracting, from web service / Extracting data from a web service, How it works...
• database
  • creating, with default properties / Getting ready, How it works...
  • dropping, SMO used / How to do it..., How it works...
  • dropping, PowerShell used / How to do it..., How it works...
  • detaching, programmatically / Getting ready, There's more...
  • attaching, with data files / Getting ready, How it works...
  • copying, PowerShell used / How to do it...
  • copying, SMO used / How it works...
  • filegroup, adding to / How to do it...
  • differential backup, creating on / Creating a differential backup, How to do it..., How it works...
  • restoring / Restoring a database to a point in time, Getting ready, How to do it..., How it works..., Step 1 – Gather your backup files, Step 2 – Restore the last good full backup, with NORECOVERY, Step 3 – Restore the last good differential backup taken after the full backup you just restored, with NORECOVERY, Step 4 – Restore the transaction logs taken after your differential backup
• database, restoring
  • backup files, gathering / Step 1 – Gather your backup files
  • full backup, restoring with NORECOVERY option / Step 2 – Restore the last good full backup, with NORECOVERY
  • differential backup, restoring / Step 3 – Restore the last good differential backup taken after the full backup you just restored, with NORECOVERY
  • transaction logs, restoring / Step 4 – Restore the transaction logs taken after your differential backup
• database backup
  • creating, on mirrored backup files / Getting ready, How it works...
• Database Mail
  • setting up, programmatically / Getting ready, How to do it..., How it works...
  • working / How it works...
• database mappings
  • listing / Listing logins, users, and database mappings, How to do it..., How it works...
• database master key
  • about / Creating a database master key
  • creating / How to do it..., How it works...
• database objects
  • searching, PowerShell used / Searching for database objects, How to do it..., How it works..., There's more...
• database owner
  • changing / Getting ready, How it works...
• database properties
  • altering, SMO used / How to do it..., How it works...
  • altering, PowerShell used / How to do it..., How it works...
• database recovery model
  • modifying / Getting ready, How it works...
• database role
  • creating / Creating a database role, How to do it..., How it works...
• database user
  • creating, SMO used / Getting ready, How to do it..., How it works...
  • creating, PowerShell used / Getting ready, How to do it..., How it works...
  • permissions, assigning to / Getting ready, How to do it..., How it works...
• data files
  • database, attaching with / Getting ready, How it works...
• data source
  • updating, for SSRS report / Changing an SSRS report's data source reference, How to do it..., How it works...
• DataSourceDefinition class
  • about / How it works...
  • properties / How it works...
• date-time format strings, PowerShell / Common date-time format strings
• DateTimeFormatInfo class
  • URL, for info / There's more...
• DBCC commands
  • running, PowerShell used / Running DBCC commands, How it works...
• DDL events
  • WMI Server event alerts, setting up for / Setting up WMI Server event alerts, Getting ready, How to do it..., How it works...
• DependentServices property
  • about / How it works...
• DeployProject method / How it works...
• development environment
  • about / Development environment
• differential backup
  • creating, on database / Creating a differential backup, How to do it..., How it works...
• DisableNameChecking parameter / There's more...
• disk space usage
  • checking, for SQL Server instance / Checking disk space usage, How to do it..., How it works...
• DLL (Dynamic Linked Library)
  • about / How it works...
• domain accounts
  • creating / Creating domain accounts
• domain controller
  • configuring / Configuring a domain controller
• DropAndMove method / There's more...
• Dynamically Linked Libraries (DLL)
  • about / Before you start: Working with SQL Server and PowerShell

E

• e-mail
  • sending, with attachment / Sending e-mail, There's more...
• empty virtual machine
  • creating / Creating an empty virtual machine
• EnumFragmentation method / How it works..., How it works...
• EnumObjects method / There's more...
• EnumProcesses method / How it works...
• error handling
  • about / Error Handling
• error messages
  • displaying, in PowerShell / Getting additional error messages, How it works...
• escape and line continuation
  • about / Escape and line continuation
• evaluation modes, policy
  • none / How it works...
  • Enforce / How it works...
  • CheckOnChanges / How it works...
  • CheckOnSchedule / How it works...
• event log
  • reading / How to do it..., How it works...
• Excel format
  • SSRS report, downloading in / Downloading an SSRS report in Excel and PDF, How to do it..., How it works...
• Exchange / Introduction
• execution policies
  • Restricted / Execution policies
  • AllSigned / Execution policies
  • RemoteSigned / Execution policies
  • Unrestricted / Execution policies
  • Bypass / Execution policies
  • Undefined / Execution policies
• execution policy
  • about / Before you start: Working with SQL Server and PowerShell
  • modifying / Changing execution policy, Execution policies
• execution policy, PowerShell scripts
  • about / Execution policy
  • Restricted / Execution policy
  • AllSigned / Execution policy
  • RemoteSigned / Execution policy
  • Unrestricted / Execution policy
  • Bypass / Execution policy
  • Undefined / Execution policy
• Export-Clixml cmdlet
  • about / How it works..., Common Cmdlets
• Export-Csv cmdlet
  • about / How it works..., Common Cmdlets
• ExpressionNodeOperator
  • URL / See also
• ExpressionNodes
  • URL / See also

F

• facet properties
  • listing / How to do it..., How it works...
• facets
  • listing / How to do it..., How it works...
• failed login attempts
  • listing, in SQL Server instance / Listing failed login attempts, How it works...
• features, PowerShell v3
  • workflows / Notable PowerShell V3 features
  • robust sessions / Notable PowerShell V3 features
  • scheduled jobs / Notable PowerShell V3 features
  • Module AutoLoading / Notable PowerShell V3 features
  • web service support / Notable PowerShell V3 features
  • simplified language syntax / Notable PowerShell V3 features
  • Improved Integrated Scripting Environment (ISE) / Notable PowerShell V3 features
• file
  • SSIS package, downloading to / Downloading an SSIS package to a file, How it works...
• filegroup
  • adding, to database / How to do it...
  • secondary data files, adding to / Getting ready, How to do it..., How it works...
  • indexes, moving to / Moving an index to a different filegroup, How to do it..., How it works..., There's more...
• filegroup backup
  • creating, Backup-SqlDatabase cmdlet used / Creating a filegroup backup, How it works...
• file list information
  • listing / Listing backup header and file list information, How to do it..., How it works...
• file manipulation
  • URL, for info / There's more...
• files
  • manipulating, in PowerShell / Manipulating files, How it works...
  • searching, in PowerShell / Searching for files, How it works...
• FolderExistsOnSqlServer method / How it works...
• folders
  • creating, in SSIS instance / Creating folders in an SSIS package store and MSDB, How to do it..., How it works...
  • creating, in SSIS package store / Creating folders in an SSIS package store and MSDB, How to do it..., How it works...
  • managing, in PowerShell / How to do it..., There's more...
• Foreach-Object cmdlet
  • about / How it works..., How it works..., How it works..., How it works..., Common aliases
• Foreach loop
  • about / Arrays and loops
• for loop
  • about / Arrays and loops
• Format-List cmdlet
  • about / Common Cmdlets
• Format-Table cmdlet
  • about / Common Cmdlets
• format patterns, timestamp
  • about / How it works...
  • tt / How it works...
  • ss / How it works...
  • mm / How it works...
  • dd / How it works...
  • dddd / How it works...
  • hh / How it works...
  • HH / How it works...
  • MM / How it works...
  • MMM / How it works...
  • MMMM / How it works...
  • yy / How it works...
  • yyyy / How it works...
• FreeISO Creator
  • URL / Terminology
• full backup
  • restoring, with NORECOVERY / Step 2 – Restore the last good full backup, with NORECOVERY
• full database backup
  • creating, PowerShell used / Creating a full backup, How to do it..., How it works..., There's more...
• Full recovery model
  • about / There's more...
• function
  • about / Converting script into functions
  • script, converting into / Converting script into functions
• functions / Introduction
  • about / Functions

G

• Get-Alias cmdlet
  • about / How it works..., Common Cmdlets
• Get-ChildItem cmdlet
  • about / How it works..., How it works..., How to do it..., Common aliases, Cmdlets, Common Cmdlets
• Get-Command cmdlet
  • about / Learning PowerShell, Get-Command
• Get-Content cmdlet
  • about / How it works..., How it works..., How it works..., Common aliases, Common Cmdlets
• Get-Credential cmdlet
  • about / Common Cmdlets
• Get-Date cmdlet
  • about / Common Cmdlets
• Get-EventLog cmdlet
  • about / Common Cmdlets
• Get-ExecutionPolicy cmdlet
  • about / Execution policy, Common Cmdlets
• Get-Help cmdlet
  • PowerShell script, documenting for / Documenting PowerShell script for Get-Help, How to do it..., How it works...
  • about / Learning PowerShell, Get-Help
• Get-History cmdlet
  • about / Common aliases
• Get-Hotfix cmdlet / How it works...
• Get-HotFix cmdlet
  • about / Common Cmdlets
• Get-Location cmdlet
  • about / Common aliases
• Get-Member cmdlet / How it works...
  • about / Learning PowerShell, Get-Member, PowerShell is object oriented, and works with .NET, Common Cmdlets
• Get-Process cmdlet
  • URL, for info / There's more...
  • about / Exporting to CSV and XML, Common aliases, Common Cmdlets
  • exporting, to XML / How to do it..., How it works...
  • exporting, to CSV / How to do it..., How it works...
• Get-Service cmdlet
  • about / There's more..., How it works..., Common Cmdlets
• Get-SSRSItems fun / Converting script into functions
• Get-WmiObject cmdlet
  • about / There's more..., Common Cmdlets
• GetDtsServerPackageInfos method / How it works...
• GetItemDataSources method / How it works...
• GetItemDefinition method
  • about / How it works...
• GetName method
  • about / How it works...
• GetOrdinal method
  • about / How it works..., How it works...
• GetPolicies method / How it works...
• GetValue method
  • about / How it works..., How it works...
• Global Assembly Cache (GAC) / How it works...
• Guest OS
  • Windows Server 2008 R2, installing as / Installing Windows Server 2008 R2 as Guest OS

H

• hash
  • about / Hashes
• hash table
  • about / Arrays and hash tables
• help cmdlet
  • about / Common aliases
• here-string
  • about / Here-string, Here-string
• here-string variable
  • about / How it works...
• hMailServer
  • about / There's more...
  • URL / There's more...
• Hotfix
  • about / There's more...
• HTML report
  • creating, PowerShell used / How to do it..., How it works...

I

• .ispac file
  • about / How it works...
  • deploying / How it works...
• Import-Clixml cmdlet
  • about / Common Cmdlets
• Import-Csv cmdlet
  • about / Common Cmdlets
• ImportPolicy method
  • about / How it works..., There's more...
  • parameters / There's more...
• ImportPolicy method, parameters
  • XMLReader / There's more...
  • ImportEnabledState / There's more...
  • overwriteExistingPolicy / There's more...
  • overwriteExistingCondition / There's more...
• Improved Integrated Scripting Environment (ISE)
  • about / Notable PowerShell V3 features
• index
  • creating, SMO used / Getting ready, How to do it..., How it works...
  • creating, PowerShell used / Getting ready, How to do it..., How it works...
  • rebuilding / Reorganizing/rebuilding an index, How it works...
  • reorganizing / Reorganizing/rebuilding an index, How it works...
• indexes
  • moving, to filegroup / Moving an index to a different filegroup, How to do it..., How it works..., There's more...
• index fragmentation
  • investigating, SMO used / Getting ready, How it works...
  • investigating, PowerShell used / Getting ready, How it works...
• index type
  • filtered / There's more...
  • FullText / There's more...
  • XML / There's more...
  • spatial / There's more...
• INSERT statement
  • about / How it works...
• installed hotfixes
  • listing, in SQL Server / Listing installed hotfixes and service packs, How it works..., There's more...
• installing
  • Windows Server 2008 R2, as Guest OS / Installing Windows Server 2008 R2 as Guest OS
  • VMWare tools / Installing VMWare tools
  • SQL Server 2012, on VM / Installing SQL Server 2012 on a VM
  • SQL Server sample databases / Installing sample databases
  • PowerShell V3 / Installing PowerShell V3
• instance classes
  • about / Installing SMO
• instance properties
  • exporting, to text file / How to do it..., How it works..., There's more...
• Integrated Scripting Environment (ISE)
  • about / Through shell or through ISE
• Intellisense
  • about / Notable PowerShell V3 features
• International Organization for Standardization (ISO)
  • about / Terminology
• Invoke-Command cmdlet
  • about / How it works...
• Invoke-Expression
  • using / How to do it..., How it works...
• Invoke-Expression cmdlet
  • about / How it works..., How it works..., Using Invoke-Expression
• Invoke-Expression command
  • about / How it works...
• Invoke-PolicyEvaluation cmdlet
  • about / There's more...
• Invoke-Sqlcmd cmdlet
  • about / How it works..., Performing bulk export using Invoke-Sqlcmd, How it works..., How it works..., Create SMO Server Object
  • used, for performing bulk export / Performing bulk export using Invoke-Sqlcmd, How to do it..., How it works...
• Invoke-SqlCmd cmdlet
  • about / How it works...
• Invoke-WebRequest cmdlet
  • about / Notable PowerShell V3 features
• ISO File
  • about / Terminology
• ISPAC file
  • deploying, to SSISDB / Deploying an ISPAC file to SSISDB, How to do it..., How it works...
• items
  • listing, in SSRS report server / Listing items in your SSRS Report Server, How it works...

J

• Join-Path cmdlet
  • about / How it works...

K

• KillDatabase method / How it works...
• KillProcess method / How it works...

L

• -LogTruncationType parameter
  • about / How it works...
• ListChildren method / How it works..., How it works...
• ListChildren method / How it works...
• Load() method / How it works...
• LoadFromDtsServer method / How it works...
• LoadFromSqlServer method / How it works...
• Load method
  • about / How it works...
• LoadWithPartialName() method / How it works...
• local network
  • SQL Server instances, listing in / Getting ready, How to do it..., How it works..., There's more...
• log errors
  • listing, in SQL Server / Getting ready, How to do it..., How it works...
• logics
  • about / Logic
• login
  • creating, SMO used / Creating a login, How to do it..., How it works...
  • creating, PowerShell used / Creating a login, How to do it..., How it works...
  • roles, assigning / Getting ready, How to do it..., How it works...
  • permissions, assigning / Getting ready, How to do it..., How it works...
• login/user roles
  • listing / How to do it..., How it works...
• LoginMode property / How it works...
• logins
  • listing / Listing logins, users, and database mappings, How to do it..., How it works...
• loop
  • about / Loop
• loops
  • while / Arrays and loops
  • about / Arrays and loops
  • for / Arrays and loops
  • Foreach / Arrays and loops

M

• MagicISO
  • URL / Terminology
• ManagedComputer object
  • about / How it works..., There's more..., How it works...
• management cmdlets
  • about / Common Cmdlets
  • Get-ChildItem / Common Cmdlets, Common Cmdlets
  • Get-Content / Common Cmdlets, Common Cmdlets
  • Get-EventLog / Common Cmdlets, Common Cmdlets
  • Get-HotFix / Common Cmdlets, Common Cmdlets
  • Get-Process / Common Cmdlets, Common Cmdlets
  • Get-Service / Common Cmdlets, Common Cmdlets
  • Get-WmiObject / Common Cmdlets, Common Cmdlets
  • New-WebServiceProxy / Common Cmdlets, Common Cmdlets
  • Start-Process / Common Cmdlets, Common Cmdlets
  • Start-Service / Common Cmdlets, Common Cmdlets
• MasterKey class / How it works...
• MasterKey object / How it works...
• messages
  • displaying / Displaying messages
• Microsoft .NET Framework 4.0
  • installing / How to do it...
• mirrored backup files
  • database backup, creating on / Getting ready, How it works...
• mixed assembly error
  • about / More information on mixed assembly error
• module
  • about / How it works...
• Module AutoLoading
  • about / Notable PowerShell V3 features
• modules and snap-ins
  • about / Before you start: Working with SQL Server and PowerShell
• Move-Item cmdlet
  • about / How it works..., How it works..., Common aliases
• MSDN Add-Type
  • URL / There's more...
• MSDN ConvertTo-HTML
  • URL / There's more...
• MSDN Get-Date
  • URL, for info / There's more...
• MSDN Get-Process
  • URL, for info / There's more...
• MSDN Invoke-Expression
  • URL / There's more...
• MSDN Send-MailMessage
  • URL / There's more...
• MS Virtual PC
  • URL / Terminology
• multiple servers
  • SQL query, executing to / Executing a SQL query to multiple servers, How it works...

N

• -NoRecovery parameter
  • about / How it works...
• .NET language
  • C# / Installing SMO
  • VB.NET / Installing SMO
  • PowerShell / Installing SMO
• .NET library
  • about / What is PowerShell, and why learn another language
• Nero Burning Software
  • URL / Terminology
• New-Item cmdlet
  • about / How it works..., How it works..., How it works...
• New-WebServiceProxy cmdlet / How it works...
  • about / Common Cmdlets
• NORECOVERY option / Step 2 – Restore the last good full backup, with NORECOVERY
  • full backup, restoring / Step 2 – Restore the last good full backup, with NORECOVERY

O

• online piecemeal restore
  • performing / Performing an online piecemeal restore, How to do it..., How it works...
• OPENROWSET method
  • URL, for info / There's more...
• operators
  • about / Operators
• orphaned users
  • fixing / Fixing orphaned users, How to do it..., How it works...
• OverrideIfAlreadyUser option / How it works...

P

• Pause() method
  • about / There's more...
• PDF format
  • SSRS report, downloading in / Downloading an SSRS report in Excel and PDF, How to do it..., How it works...
• PercentCompleteEventHandler
  • about / More about Backup and PercentCompleteEventHandler
• permissions
  • listing / How to do it..., How it works...
  • assigning, to login / Getting ready, How to do it..., How it works...
  • assigning, to database user / Getting ready, How to do it..., How it works...
• pipe operator / You can chain commands
• policies
  • about / Introduction, Listing policies
  • listing / Getting ready, How it works...
• policy
  • exporting, to XML file / Getting ready, How to do it..., How it works...
  • exporting, from SQL Server Management Studio / There's more...
  • importing, into SQL Server / Importing a policy, How to do it..., How it works...
  • creating, programmatically / Getting ready, How to do it..., How it works...
  • evaluation modes / How it works...
  • evaluating, against SQL Server instance / Getting ready, How to do it..., How it works...
• Policy Based Management (PBM)
  • about / How it works...
• PolicyStore parameter
  • about / How it works...
• PowerISO
  • URL / Terminology
• PowerShell
  • about / Introduction, Introduction, What is PowerShell, and why learn another language
  • administrator, scripting / Administrator
  • scripts, running / Running scripts, Through shell or through ISE
  • instance configuration settings, modifying / Changing SQL Server instance configurations, How to do it..., How it works..., There's more...
  • used, for searching database objects / Searching for database objects, How to do it..., How it works..., There's more...
  • database, creating with default properties / Getting ready, How it works...
  • used, for altering database properties / How to do it..., How it works...
  • database, dropping / How to do it..., How it works...
  • used, for creating table / How to do it...
  • used, for creating view / How to do it..., How it works...
  • used, for creating stored procedure / Creating a stored procedure, How to do it..., How it works...
  • AFTER trigger, creating / How to do it..., How it works...
  • used, for creating index / Getting ready, How to do it..., How it works...
  • hardcoded query, executing / Executing a query / SQL script, How to do it..., How it works...
  • SQL script, executing / Executing a query / SQL script, How to do it..., How it works...
  • administrative tasks / Introduction
  • used, for copying database / How to do it...
  • used, for creating filegroup / How to do it...
  • used, for adding secondary data files to filegroup / Getting ready, How to do it..., How it works...
  • used, for investigating index fragmentation / Getting ready, How it works...
  • index, reorganizing / Reorganizing/rebuilding an index, How it works...
  • index, rebuilding / Reorganizing/rebuilding an index, How it works...
  • used, for running DBCC commands / Running DBCC commands, How it works...
  • used, for setting up Database Mail / Getting ready, How to do it..., How it works...
  • used, for listing SQL Server jobs / Getting ready, How to do it..., How it works...
  • used, for creating SQL Server operator / Getting ready, How to do it..., How it works...
  • SQL Server job, creating programmatically / Creating a SQL Server job, How to do it..., How it works...
  • SQL Server event alert, adding / Adding a SQL Server event alert, How it works...
  • SQL Server job, running programmatically / Running a SQL Server job, How it works...
  • used, for scheduling SQL Server job / Scheduling a SQL Server job, How to do it..., How it works..., There's more...
  • used, for listing authentication modes / Getting ready, How it works...
  • used, for creating login / Creating a login, How to do it..., How it works...
  • permissions, assigning to login / Getting ready, How to do it..., How it works...
  • roles, assigning to login / Getting ready, How to do it..., How it works...
  • used, for creating database user / Getting ready, How to do it..., How it works...
  • permissions, assigning to database user / Getting ready, How to do it..., How it works...
  • database role, creating / Creating a database role, How to do it..., How it works...
  • orphaned users, fixing / Fixing orphaned users, How to do it..., How it works...
  • facets, listing / How to do it..., How it works...
  • facet properties, listing / How to do it..., How it works...
  • policies, listing / Getting ready, How it works...
  • policy, exporting to XML file / Getting ready, How to do it..., How it works...
  • policy, importing into SQL Server / Importing a policy, How to do it..., How it works...
  • condition, creating / Getting ready, How to do it..., How it works...
  • used, for creating policy / Getting ready, How to do it..., How it works...
  • policy, evaluating / Getting ready, How to do it..., How it works...
  • change tracking, disabling to target database / Getting ready, How to do it..., There's more...
  • change tracking, enabling to target database / Getting ready, How to do it..., There's more...
  • profiler trace event, running / Getting ready, How to do it..., How it works...
  • profiler trace event, saving / Getting ready, How to do it..., How it works...
  • used, for extracting content of trace file / Getting ready, How to do it..., How it works...
  • database master key, creating / How to do it..., How it works...
  • certificate, creating / How to do it...
  • symmetric keys, creating / Getting ready, How to do it..., How it works..., There's more...
  • asymmetric keys, creating / Getting ready, How to do it..., How it works..., There's more...
  • Transparent Data Encryption (TDE), setting up / How to do it..., How it works...
  • database recovery model, modifying / Getting ready, How it works...
  • backup history, listing for SQL Server instance / Listing backup history, How to do it..., How it works...
  • used, for creating backup device / Getting ready, How to do it..., How it works...
  • backup header information, listing from backup file / Listing backup header and file list information, How to do it..., How it works...
  • file list information, listing / Listing backup header and file list information, How to do it..., How it works...
  • used, for creating full database backup / Creating a full backup, How to do it..., How it works..., There's more...
  • database backup, creating on mirrored backup files / Getting ready, How it works...
  • differential backup, creating on database / Creating a differential backup, How to do it..., How it works...
  • transaction log backup, creating / Getting ready, How to do it..., How it works...
  • database, restoring / Restoring a database to a point in time, Getting ready, How to do it..., How it works..., Step 1 – Gather your backup files, Step 2 – Restore the last good full backup, with NORECOVERY, Step 3 – Restore the last good differential backup taken after the full backup you just restored, with NORECOVERY, Step 4 – Restore the transaction logs taken after your differential backup
  • online piecemeal restore, performing / Performing an online piecemeal restore, How to do it..., How it works...
  • used, for creating RSS feed / How to do it..., How it works...
  • capabilities / Introduction
  • used, for executing SSIS package / Executing an SSIS package stored in the package store or File System, How to do it..., How it works...
  • timestamp, getting in / How to do it..., How it works...
  • error messages, displaying / Getting additional error messages, How it works...
  • used, for listing processes / How to do it..., How it works...
  • aliases, testing / How to do it..., How it works...
  • Invoke-Expression, using / How to do it..., How it works...
  • regular expressions, testing / How to do it..., How it works...
  • folders, managing / How to do it..., There's more...
  • files, manipulating / Manipulating files, How it works...
  • files, searching / Searching for files, How it works...
  • Windows event log, reading from / How to do it..., How it works...
  • attachment, sending with e-mail / Sending e-mail, There's more...
  • C# code, embedding / How to do it..., How it works...
  • used, for creating HTML report / How to do it..., How it works...
  • used, for parsing XML / Getting ready, How it works...
  • data, extracting from web service / Extracting data from a web service, How it works...
  • learning / Learning PowerShell
  • execution policy, modifying / Changing execution policy, Execution policies
  • execution policy, getting / Changing execution policy
  • execution policy, setting / Changing execution policy
  • script, running / Running a script
  • aliases / Common aliases
  • cmdlets, for displaying output / Displaying output
  • special characters / Special characters
  • special variables / Special variables
  • common operators / Common operators
  • date-time format strings / Common date-time format strings
  • comments / Comments
  • here-string / Here-string
  • regex patterns / Common regex characters and patterns
  • regex characters / Common regex characters and patterns
  • arrays / Arrays and hash tables
  • hash table / Arrays and hash tables
  • loops / Arrays and loops
  • logics / Logic
  • functions / Functions
  • utility cmdlets / Common Cmdlets
  • management cmdlets / Common Cmdlets
  • security cmdlets / Common Cmdlets
  • SQL Server Snapins, adding / Add SQL Server Snapins
  • SQL Server Assemblies, adding / Add SQL Server Assemblies
  • credentials / Getting credentials
  • advantages / What is PowerShell, and why learn another language
  • environment, setting up / Setting up the Environment
  • resources / Resources
  • podcasts / PowerShell Webcasts and Podcasts
  • webcasts / PowerShell Webcasts and Podcasts
  • tools / PowerShell Tools
• PowerShell, books
  • PowerShell V2 / PowerShell V2
  • PowerShell V2 Free E-books / PowerShell V2 Free E-books
• PowerShell, resources
  • books / PowerShell V3, PowerShell V2, PowerShell V2 Free E-books
  • sites / PowerShell Blogs and Sites
  • blogs / PowerShell Blogs and Sites
• PowerShell ISE
  • about / PowerShell ISE, Getting ready
  • Script Pane / PowerShell ISE
  • Command Pane / PowerShell ISE
• PowerShell Remoting
  • about / Using PowerShell Remoting
  • using / How to do it..., How it works...
  • URL, for info / There's more...
• PowerShell script
  • documenting, for Get-Help cmdlet / Documenting PowerShell script for Get-Help, How to do it..., How it works...
• PowerShell scripts
  • running / More information on running PowerShell scripts, Through shell or through ISE
  • execution policy / Execution policy
• PowerShell syntax
  • about / Scripting syntax
  • statement terminators / Statement terminators
  • escape and line continuation / Escape and line continuation
  • variables / Variables
  • operators / Operators
  • message display / Displaying messages
  • comments / Comments
  • special variables / Special variables
  • conditional statements / Conditions
  • regular expressions / Regular Expressions
  • arrays / Arrays
  • hashes / Hashes
  • loop / Loop
  • error handling / Error Handling
• PowerShell V2
  • Where-Object syntax / PowerShell V2 versus V3 Where-Object syntax
  • SQLPS module, importing / Import SQLPS module
  • books / PowerShell V2
• PowerShell V2 Free E-books / PowerShell V2 Free E-books
• PowerShell v3
  • features / Notable PowerShell V3 features
  • installing / How to do it...
• PowerShell V3
  • Where-Object syntax / PowerShell V2 versus V3 Where-Object syntax
  • books / PowerShell V3
  • installing / Installing PowerShell V3
• PowerShell v3 ISE
  • enabling / How to do it...
• processes
  • listing, PowerShell used / How to do it..., How it works...
• Process ID (PID)
  • about / Special variables
• profiler trace event
  • saving / Getting ready, How to do it..., How it works...
  • running / Getting ready, How to do it..., How it works...
• properties
  • listing, for SSRS report / Listing SSRS report properties, How to do it..., How it works...
• proxy
  • creating, in SQL Server / Getting ready, How to do it..., How it works...
• PSCX
  • about / PSCX
  • URL / PSCX
• PSDrive
  • about / Before you start: Working with SQL Server and PowerShell
• PSProvider
  • about / Before you start: Working with SQL Server and PowerShell
• PSScheduledJob module
  • about / Notable PowerShell V3 features

Q

• query
  • executing, from PowerShell / Executing a query / SQL script, How to do it..., How it works...
• Quest / Introduction
• Quick Fix Engineering (QFE)
  • about / There's more...

R

• .rdl file / Uploading an SSRS report to Report Manager
• RDL files
  • downloading, from SSRS report server / Getting ready, How to do it..., How it works...
• Read-Host cmdlet
  • about / Common Cmdlets
• ReadErrorLog method / How it works...
• RecoveryModel property
  • modifying / How it works...
  • about / There's more...
• Recovery Point Objective (RPO)
  • about / There's more...
• Recovery Time Objective (RTO)
  • about / There's more...
• Refresh() method
  • about / There's more...
• regex characters, PowerShell / Common regex characters and patterns
• regex methods
  • URL, for info / There's more...
• regex patterns, PowerShell / Common regex characters and patterns
• Register-WmiEvent cmdle
  • about / How it works...
• regular expressions
  • testing, in PowerShell / How to do it..., How it works...
  • about / How it works..., Regular Expressions
  • common patterns / How it works...
• Released to Manufacturing (RTM)
  • about / Setting up the Environment
• RemoteSigned
  • about / Before you start: Working with SQL Server and PowerShell
• Remove-Item cmdlet
  • about / How it works..., How it works..., Common aliases
• Render method / How it works...
• Report Manager
  • SSRS report, uploading to / Uploading an SSRS report to Report Manager, How to do it..., How it works...
• ReportService2010 web service
  • about / How it works...
• ReportViewer
  • used, for displaying SSRS report / Using ReportViewer to view your SSRS report, How to do it..., How it works...
  • working / How it works...
• ReportViewer control
  • about / Getting ready
• Restore-ASDatabase cmdlet
  • about / How it works...
• robust sessions, PowerShell v3
  • about / Notable PowerShell V3 features
• roles
  • assigning, to login / Getting ready, How to do it..., How it works...
• RSS
  • about / There's more...
• RSS feed
  • creating, PowerShell used / How to do it..., How it works...
  • creating, T-SQL used / How to do it..., How it works...
  • creating, from SQL Server content / How to do it..., How it works...
  • XSL, applying to / Applying XSL to an RSS feed, How it works...
• RSS feeds
  • URL, for info / There's more...
• RTM
  • about / There's more...
• running processes
  • listing, in SQL Server instance / Listing running/blocking processes, How to do it..., How it works...

S

• sample code
  • working with / Working with the sample code
• SaveToDtsServer method
  • about / How it works...
• SaveToSQLServer method
  • about / How it works...
• SaveToXml method / How it works...
• script
  • running / Running a script
  • converting, into function / Converting script into functions
• scripts
  • running / Running scripts
• secondary data files
  • adding, to filegroup / Getting ready, How to do it..., How it works...
• security cmdlets
  • about / Common Cmdlets
  • ConvertFrom-SecureString / Common Cmdlets, Common Cmdlets
  • ConvertTo-SecureString / Common Cmdlets, Common Cmdlets
  • Get-Credential / Common Cmdlets, Common Cmdlets
  • Get-ExecutionPolicy / Common Cmdlets, Common Cmdlets
  • Set-ExecutionPolicy / Common Cmdlets, Common Cmdlets
• security levels
  • SAFE / There's more...
  • EXTERNAL_ACCESS / There's more...
  • UNSAFE / There's more...
• semicolon
  • about / Statement terminators
• ServerInstance property / How it works...
• service account
  • about / Terminology
• service accounts
  • listing / How to do it..., How it works...
  • modifying / Changing SQL Server service account, How to do it..., How it works...
• service packs
  • listing, in SQL Server / Listing installed hotfixes and service packs, How it works..., There's more...
• Set-Alias cmdlet
  • about / How it works...
• Set-ExecutionPolicy cmdlet
  • about / Execution policy, Common Cmdlets
• Set-Location cmdlet
  • about / Common aliases
• SetItemDataSources method / How it works...
  • about / How it works...
• SetOwner method / How it works...
• SetPolicies method / How it works...
• set_Login method / How it works...
• SharePoint / Introduction
• Simple recovery model
  • about / There's more...
• simplified language syntax
  • about / Notable PowerShell V3 features
• single line comments
  • about / Comments, Comments
• SMO
  • about / Installing SMO, Introduction
  • installing / Installing SMO, Getting ready, How to do it...
  • instance classes / Installing SMO
  • utility classes / Installing SMO
  • used, for altering database properties / How to do it..., How it works...
  • database, dropping / How to do it..., How it works...
  • used, for creating table / How it works...
  • used, for creating view / How to do it..., How it works...
  • used, for creating stored procedure / Creating a stored procedure, How to do it..., How it works...
  • used, for creating index / Getting ready, How to do it..., How it works...
  • used, for copying database / How it works...
  • used, for creating filegroup / How to do it...
  • used, for adding secondary data files to filegroup / Getting ready, How to do it..., How it works...
  • used, for investigating index fragmentation / Getting ready, How it works...
  • used, for creating SQL Server operator / Getting ready, How to do it..., How it works...
  • used, for scheduling SQL Server job / Scheduling a SQL Server job, How to do it..., How it works..., There's more...
  • used, for listing authentication modes / Getting ready, How it works...
  • used, for creating login / Creating a login, How to do it..., How it works...
  • permissions, assigning to login / Getting ready, How to do it..., How it works...
  • roles, assigning to login / Getting ready, How to do it..., How it works...
  • used, for creating database user / Getting ready, How to do it..., How it works...
  • permissions, assigning to database user / Getting ready, How to do it..., How it works...
  • certificate, creating / How it works...
  • Transparent Data Encryption (TDE), setting up / How to do it..., How it works...
• SMO assemblies
  • loading / Loading SMO assemblies, How it works...
  • working / How it works...
• SMO Certificate object
  • about / How it works...
• SMO libraries
  • gaining / Installing SMO
• SMO Server Object
  • creating / Create SMO Server Object
• SMO server objects
  • exploring / Exploring SMO server objects
  • working / How it works...
• snap-in
  • about / How it works...
• Sort-Object cmdlet
  • about / Common aliases
• special characters
  • about / Special characters
• special variables
  • about / Special variables, Special variables
• SQL-related cmdlets
  • discovering / Discovering SQL-related cmdlets and modules
  • working / How it works...
• SQL-related modules
  • discovering / How to do it...
• SQLCLR assemblies
  • URL, for info / There's more...
  • about / How it works...
• SqlConnectionInfo connection object
  • about / How it works...
• SQLConnection object / How it works...
• SQL Login
  • about / There's more...
• SQLPS and SQLASCMDLETS cmdlets
  • list / There's more...
• SQLPS module
  • importing / Import SQLPS module
• SQLPSX
  • about / Cmdlets, SQLPSX
  • URL / SQLPSX
• SQL query
  • executing, to multiple servers / Executing a SQL query to multiple servers, How it works...
• SQL script
  • executing, from PowerShell / Executing a query / SQL script, How to do it..., How it works...
• SQL Server
  • working, with PowerShell / Before you start: Working with SQL Server and PowerShell
  • about / Introduction, Introduction, Introduction
  • services, discovering / Discovering SQL Server services, How it works..., There's more...
  • services, starting / How to do it... , How it works..., There's more...
  • services, stopping / How to do it... , How it works..., There's more...
  • configuration settings, listing / Listing SQL Server configuration settings, How to do it..., How it works...
  • instance configuration settings / Changing SQL Server instance configurations, How to do it..., How it works..., There's more...
  • database owner, changing / Getting ready, How it works...
  • trigger, creating / Creating a trigger, How to do it..., How it works...
  • instance properties, exporting to text file / How to do it..., How it works..., There's more...
  • database inventory, creating / Creating a SQL Server database inventory, How it works...
  • service packs, listing / Listing installed hotfixes and service packs, How it works..., There's more...
  • installed hotfixes, listing / Listing installed hotfixes and service packs, How it works..., There's more...
  • blocking procss, killing / Getting ready, How to do it..., How it works...
  • database, detaching programmatically / Getting ready, There's more...
  • service accounts, listing / How to do it..., How it works...
  • service accounts, modifying / Changing SQL Server service account, How to do it..., How it works...
  • authentication modes, modifying / Changing authentication mode, Getting ready, How it works..., There's more...
  • log errors, listing / Getting ready, How to do it..., How it works...
  • credential, creating / Creating a credential, How to do it..., How it works...
  • proxyTopicncreating / Getting ready, How to do it..., How it works...
  • policy, importing into / Importing a policy, How to do it..., How it works...
  • XML content, inserting into / Inserting XML into SQL Server, How it works...
  • XML content, extracting from / Extracting XML from SQL Server, How to do it..., How it works...
  • binary data, storing into / Storing binary data into SQL Server, How to do it..., How it works...
  • binary data, extracting from / Extracting binary data from SQL Server, How to do it..., How it works...
  • assembly, creating / How to do it..., How it works...
• SQL Server 2012
  • installing / How to do it...
  • SSAS cmdlets, listing / Listing SSAS cmdlets, How it works...
  • installing, on VM / Installing SQL Server 2012 on a VM
• SQL Server 2012 trial version ISO file
  • URL, for downloading / Downloading software
• SQL Server Agent Account
  • about / VM details and accounts
• SQL Server and PowerShell
  • working with / Before you start: Working with SQL Server and PowerShell
• SQL Server Assemblies
  • adding / Add SQL Server Assemblies
• SQL Server content
  • RSS feed, creating from / How to do it..., How it works...
• SQL Server database
  • user-defined assemblies, creating in / Listing user-defined assemblies, How it works...
• SQL Server database inventory
  • creating / Creating a SQL Server database inventory, How it works...
• SQL Server Data Tools (SSDT) / How it works...
• SQL Server event alert
  • adding / Adding a SQL Server event alert, How it works...
• SQL Server instance
  • blocking processes, listing / Listing running/blocking processes, How to do it..., How it works...
  • running processes, listing / Listing running/blocking processes, How to do it..., How it works...
  • disk space usage, checking for / Checking disk space usage, How to do it..., How it works...
  • failed login attempts, listing in / Listing failed login attempts, How it works...
  • backup history, listing for / Listing backup history, How to do it..., How it works...
• SQL Server instance inventory
  • about / Creating a SQL Server instance inventory
  • creating / How to do it..., How it works..., There's more...
• SQL Server instance object
  • creating / Creating a SQL Server instance object, How to do it...
  • working / How it works...
• SQL Server Instances
  • about / VM details and accounts
• SQL Server instances
  • about / Listing SQL Server instances
  • listing, in local network / Getting ready, How to do it..., How it works..., There's more...
• SQL Server job
  • creating, programmatically / Creating a SQL Server job, How to do it..., How it works...
  • running, programmatically / Running a SQL Server job, How it works...
  • scheduling, SMO used / Scheduling a SQL Server job, How to do it..., How it works..., There's more...
  • scheduling, PowerShell used / Scheduling a SQL Server job, How to do it..., How it works..., There's more...
• SQL Server jobs
  • listing, PowerShell used / Getting ready, How to do it..., How it works...
• SQL Server Management Studio
  • policy, exporting from / There's more...
• SQL Server operator
  • creating, SMO used / Getting ready, How to do it..., How it works...
  • creating, PowerShell used / Getting ready, How to do it..., How it works...
• SQL Server PowerShell hierarchy
  • exploring / Exploring the SQL Server PowerShell hierarchy, How to do it...
  • working / How it works...
• SQL Server processes
  • running / Getting credentials
  • blocking / Getting credentials
• SQL Server proxy
  • creating / Getting ready, How to do it..., How it works...
• SQL Server sample databases
  • installing / Installing sample databases
• SQL Server Service Account
  • about / VM details and accounts
• SQL Server services
  • discovering / Discovering SQL Server services, How it works..., There's more...
  • stopping / How to do it... , How it works..., There's more...
  • starting / How to do it... , How it works..., There's more...
• SQL Server Snapins
  • adding / Add SQL Server Snapins
• SSAS
  • about / Introduction, How it works...
  • instance properties, listing / How to do it..., How it works...
  • database, backing up / Backing up an SSAS database, How it works...
  • database, restoring / Getting ready, How it works...
• SSAS cmdlets
  • listing / Listing SSAS cmdlets, How it works...
• SSAS cube
  • about / Processing an SSAS cube
  • processing / Getting ready, How to do it..., How it works...
• SSAS database
  • backing up / Backing up an SSAS database, How it works...
  • restoring / Getting ready, How it works...
• SSAS database backup
  • creating / Backing up an SSAS database, How it works...
• SSAS instance properties
  • listing / Listing SSAS instance properties, How it works...
• SSAS Object
  • creating / Create SSAS ObjectcreatingSSAS Object
• SSIS
  • about / Introduction
• SSISDB
  • catalog, creating / Creating an SSISDB catalog, How to do it..., How it works...
  • folder, creating / Creating an SSISDB folder, How it works...
  • ISPAC file, deploying to / Deploying an ISPAC file to SSISDB, How to do it..., How it works...
  • SSIS package / Executing an SSIS package stored in SSISDB, How to do it..., How it works...
• SSISDB catalog
  • creating / Creating an SSISDB catalog, How to do it..., How it works...
• SSISDB folder
  • creating / Creating an SSISDB folder, How it works...
• SSIS instance
  • folders, creating in / Creating folders in an SSIS package store and MSDB, How to do it..., How it works...
• SSIS Object (SQL Server 2005/2008/2008R2)
  • creating / Create SSIS Object (SQL Server 2005/2008/2008R2)
• SSIS Object (SQL Server 2012)
  • creating / Create an SSIS Object (SQL Server 2012)
• SSIS package
  • deploying, to package store / Deploying an SSIS package to the package store, How to do it..., How it works...
  • executing, PowerShell used / Executing an SSIS package stored in the package store or File System, How to do it..., How it works...
  • downloading, to .dtsx file / Downloading an SSIS package to a file, How it works...
  • executing / Executing an SSIS package stored in SSISDB, How to do it..., How it works...
• SSIS package store
  • folders, creating in / Creating folders in an SSIS package store and MSDB, How to do it..., How it works...
  • SSIS package, deploying to / Deploying an SSIS package to the package store, How to do it..., How it works...
• SSRS
  • about / Introduction
  • folder, creating / Creating an SSRS folder, How to do it..., How it works...
  • data source, creating / Getting ready, How to do it..., How it works...
• SSRS data source
  • about / Creating an SSRS data source
  • creating / Getting ready, How to do it..., How it works...
• SSRS folder
  • creating / Creating an SSRS folder, How to do it..., How it works...
• SSRS Proxy Object
  • creating / Create SSIS Object (SQL Server 2005/2008/2008R2)
• SSRS report
  • properties, listing / Listing SSRS report properties, How to do it..., How it works...
  • displaying, ReportViewer used / Using ReportViewer to view your SSRS report, How to do it..., How it works...
  • downloading, in PDF format / Downloading an SSRS report in Excel and PDF, How to do it..., How it works...
  • downloading, in Excel format / Downloading an SSRS report in Excel and PDF, How to do it..., How it works...
  • data source, updating / Changing an SSRS report's data source reference, How to do it..., How it works...
  • uploading, to Report Manager / Uploading an SSRS report to Report Manager, How to do it..., How it works...
  • user, adding to / Adding a user with a role to an SSRS report, How to do it..., How it works...
• SSRS report properties
  • listing / Listing SSRS report properties, How to do it..., How it works...
• SSRS report server
  • items, listing in / Listing items in your SSRS Report Server, How it works...
  • RDL files, downloading from / Getting ready, How to do it..., How it works...
• standard Date and Time format strings
  • URL, for info / There's more...
• Start() method
  • about / There's more...
• Start-Process cmdlet
  • about / Common Cmdlets
• Start-Service cmdlet
  • about / Common Cmdlets
• statement terminators
  • about / Statement terminators
• Stop() method
  • about / There's more...
• Stop-Process cmdlet
  • about / Common aliases
• stored procedure
  • creating, PowerShell used / Creating a stored procedure, How to do it..., How it works...
  • creating, SMO used / Creating a stored procedure, How to do it..., How it works...
• string interpolation
  • about / String interpolation
• switch statement
  • about / How it works...
• symmetric keys
  • creating / Getting ready, How to do it..., How it works..., There's more...

T

• T-SQL
  • about / Introduction
  • used, for creating RSS feed / How to do it..., How it works...
• table, creating
  • PowerShell used / How to do it...
  • SMO used / How it works...
• tasks, modules
  • list loaded modules / How it works...
  • list installed modules / How it works...
  • show commands in module / How it works...
  • load a specific module / How it works...
• tasks, snap-ins
  • list loaded snap-ins / How it works...
  • list installed snap-ins / How it works...
  • show commands in snap-in / How it works...
  • load specific snap-in / How it works...
• Template Definition File (TDF)
  • about / Getting ready
• Test-Path cmdlet
  • about / How it works..., How it works...
• text file
  • instance properties, exporting to / How to do it..., How it works..., There's more...
• TextHeader property / How it works...
• TextMode property / How it works...
• timestamp
  • about / Getting a timestamp
  • getting, in PowerShell / How to do it..., How it works...
  • format patterns / How it works...
• trace file
  • content, extracting / Getting ready, How to do it..., How it works...
• TraceFile class
  • about / How it works...
• TraceFile object
  • about / How it works...
• TraceServer class
  • about / How it works...
• TraceServer object
  • about / How it works...
• transaction log backup
  • creating / Getting ready, How to do it..., How it works...
• transaction logs
  • restoring / Step 4 – Restore the transaction logs taken after your differential backup
• Transparent Database Encryption (TDE)
  • about / Introduction, Getting ready
  • setting up, programmatically / How to do it..., How it works...
• trigger
  • creating, in SQL Server / Creating a trigger, How to do it..., How it works...
• TRUNCATE TABLE command / How it works...

U

• Unregister-Event cmdlet
  • about / How it works...
• user
  • adding, to SSRS report / Adding a user with a role to an SSRS report, How to do it..., How it works...
• user-defined assemblies
  • listing, in SQL Server database / Listing user-defined assemblies, How it works...
  • resaving, back to filesystem as DLLs / How to do it..., How it works...
  • extracting / How to do it..., How it works...
• users
  • listing / Listing logins, users, and database mappings, How to do it..., How it works...
• utility classes
  • about / Installing SMO
• utility cmdlets
  • about / Common Cmdlets, Common Cmdlets
  • ConvertFrom-Csv / Common Cmdlets, Common Cmdlets
  • ConvertFrom-Json / Common Cmdlets, Common Cmdlets
  • ConvertTo-Csv / Common Cmdlets, Common Cmdlets
  • ConvertTo-Html / Common Cmdlets, Common Cmdlets
  • ConvertTo-Json / Common Cmdlets, Common Cmdlets
  • ConvertTo-Xml / Common Cmdlets, Common Cmdlets
  • Export-Clixml / Common Cmdlets, Common Cmdlets
  • Export-Csv / Common Cmdlets, Common Cmdlets
  • Format-List / Common Cmdlets, Common Cmdlets
  • Format-Table / Common Cmdlets, Common Cmdlets
  • Get-Alias / Common Cmdlets, Common Cmdlets
  • Get-Date / Common Cmdlets, Common Cmdlets
  • Get-Member / Common Cmdlets, Common Cmdlets
  • Import-Clixml / Common Cmdlets, Common Cmdlets
  • Import-Csv / Common Cmdlets, Common Cmdlets
  • Read-Host / Common Cmdlets, Common Cmdlets

V

• variables
  • about / Variables
• view
  • creating, SMO used / How to do it..., How it works...
  • creating, PowerShell used / How to do it..., How it works...
• Virtual Box
  • URL / Terminology
• Virtual Machine (VM)
  • about / Terminology
• Virtual Machine Computer Administrator Account
  • about / VM details and accounts
• Virtual Machine Computer Name
  • about / VM details and accounts
• Virtual Machine Name
  • about / VM details and accounts
• Visual Studio 2010 trial version ISO
  • URL, for downloading / Downloading software
• VM
  • accounts / VM details and accounts
  • logging in / VM details and accounts
  • SQL Server 2012, installing on / Installing SQL Server 2012 on a VM
• VMWare / Introduction
  • URL, for shortcuts / VM details and accounts
  • tools, installing / Installing VMWare tools
• VMWare Player
  • URL / Terminology
  • about / Downloading software
  • URL, for downloading / Downloading software
  • URL, for documentation / Downloading software
• VMWare tools
  • installing / Installing VMWare tools
• VMWare Workstation
  • URL / Terminology

W

• Web-based Enterprise Management (WBEM)
  • about / How it works...
• web service
  • data, extracting from / Extracting data from a web service, How it works...
• web service proxy
  • about / How it works...
• Web Services for Management (WSMan)
  • about / How it works...
• web service support
  • about / Notable PowerShell V3 features
• Where-Object cmdlet / How it works..., How it works...
  • about / Common aliases
• Where-Object syntax / How it works...
  • for PowerShell V2 / PowerShell V2 versus V3 Where-Object syntax
  • for PowerShell V3 / PowerShell V2 versus V3 Where-Object syntax
• Windows event log
  • reading, from PowerShell / How to do it..., How it works...
• Windows Login
  • about / There's more...
• Windows Management Framework
  • URL, for downloading / Downloading software
• Windows Management Framework 3.0
  • installing / How to do it...
• Windows Management Instrumentation (WMI)
  • about / Introduction, How it works..., How it works..., How it works...
• Windows PowerShell Tip of the Week – Formatting Dates and Times
  • URL, for info / There's more...
• Windows PowerShell Workflow (PSWF) / Notable PowerShell V3 features
• Windows Remote Management (WinRM)
  • about / How it works...
• Windows Server / Introduction
• Windows Server 2008 R2
  • URL, for downloading / Downloading software
  • installing, as Guest OS / Installing Windows Server 2008 R2 as Guest OS
• Windows Server Hyper-V Server 2008 R2
  • URL / Terminology
• WMI Query Language (WQL)
  • about / How it works...
  / There's more...
• WMI Server event alerts
  • setting up, for DDL events / Setting up WMI Server event alerts, Getting ready, How to do it..., How it works...
• workflows, PowerShell v3
  • about / Notable PowerShell V3 features
• Write-Debug cmdlet
  • about / Displaying output
  / Displaying messages
• Write-Error cmdlet
  • about / Displaying output
  / Displaying messages
• Write-EventLog cmdlet
  • about / Displaying output
  / Displaying messages
• Write-Host cmdlet
  • about / Displaying output
  / Displaying messages
• Write-Output cmdlet
  • about / Common aliases, Displaying output
  / Displaying messages
• Write-Progress cmdlet
  • about / Displaying output
  / Displaying messages
• Write-Verbose cmdlet
  • about / Displaying output
  / Displaying messages
• Write-Warning cmdlet
  • about / Displaying output
  / Displaying messages

X

• XML
  • about / Introduction
  • Get-Process cmdlet, exporting to / How to do it..., How it works...
  • parsing, PowerShell used / Getting ready, How it works...
• XML content
  • inserting, into SQL Server / Inserting XML into SQL Server, How it works...
  • extracting, from SQL Server / Extracting XML from SQL Server, How to do it..., How it works...
• XML file
  • policy, exporting to / Getting ready, How to do it..., How it works...
• XSL
  • applying, to RSS feed / Applying XSL to an RSS feed, How it works...
• XslCompiledTransform variable
  • about / How it works...

Z

• 7-Zip
  • URL, for downloading / Getting ready