Index

A

• Add-Type
  • URL / There's more...
• Alert class
  • URL / There's more...
• alert types
  • defining / There's more...
  • SQL Server Event Alert / There's more...
  • SQL Server Performance Condition Alert / There's more...
  • WMI Event Alert / There's more...
• aliases
  • obtaining / Getting aliases, How it works...
• AlwaysOn Availability Group
  • creating / Creating an AlwaysOn Availability Group, Getting ready, How to do it..., How it works...
• AlwaysOn feature
  • benefits / Introduction
  • enabling, in SQL Server / Enabling AlwaysOn in SQL Server, How to do it..., How it works...
  • URL / There's more...
• AlwaysOn health, monitoring
  • URL / There's more...
• AlwaysOn health model
  • URL / There's more...
• AlwaysOn terminologies
  • primary / Getting ready
  • secondary / Getting ready
  • availability databases / Getting ready
  • availability replica / Getting ready
  • availability mode / Getting ready
  • synchronous commit mode / Getting ready
  • asynchronous commit mode / Getting ready
  • failover mode / Getting ready
• Analysis Services
  • URL / There's more...
• Analysis Services PowerShell
  • URL / There's more...
• Analysis Services PowerShell Reference
  • URL / There's more...
• Application.LoadPackage method
  • URL / There's more...
• Application.SaveToXml Method
  • URL / There's more...
• Application class
  • URL / There's more...
• asymmetric key
  • creating / Getting ready, How to do it..., How it works..., There's more...
• AttachDatabase options
  • URL / There's more...
• authentication mode
  • listing / Listing authentication mode, How to do it..., How it works...
  • changing / Changing authentication mode, Getting ready, How it works..., There's more..., More on legacy LoginMode values
• Automatic Private IP Addressing (APIPA)
  • about / Configuring a domain controller (optional)
• availability database
  • adding, to Availability Group / Adding an availability database to an Availability Group, How to do it..., How it works...
  • prerequisites / Getting ready
• Availability Group
  • secondary replicas, joining to / Joining the secondary replicas to Availability Group, Getting ready, How it works..., There's more...
  • prerequisites and syntax, URL / There's more...
  • availability database, adding to / Adding an availability database to an Availability Group, How to do it..., How it works...
• Availability Group failover
  • testing / Testing the Availability Group failover, How to do it..., There's more...
• Availability Group listener
  • creating / Creating an Availability Group listener, How to do it..., How it works...
  • URL / There's more...
• Availability Groups, in PowerShell
  • URL / There's more...
• Azure Blob storage
  • database, backing up / Backing up database to Azure Blob storage, How to do it..., How it works...
  • database, restoring from / Restoring database from Azure Blob storage, How it works...
  • references / There's more...
• Azure BLOB storage
  • best practices and troubleshooting, URL / There's more...
• Azure SQL database
  • connecting to / Connecting to an Azure SQL database, How to do it..., How it works..., There's more...
  • table, creating / Creating a table in an Azure SQL database, How to do it..., How it works...
• Azure SQL Database cmdlets
  • URL / There's more...

B

• backing up files and filegroups
  • URL / There's more...
• backtick (`)
  • about / Escape and line continuation
• backtick (`) character
  • URL / Line continuation
• backup
  • creating, on Mirrored Media Sets / Creating a backup on Mirrored Media Sets, How to do it..., How it works...
• Backup-ASDatabase cmdlet
  • URL / There's more...
• backup device
  • creating / Creating a backup device, How to do it..., There's more...
• backup files
  • gathering / Gathering your backup files
• backup header
  • listing / Listing backup header and FileList information, How to do it..., How it works...
• BackupRestoreBase
  • defining / More about backup and PercentCompleteEventHandler
  • URL / More about backup and PercentCompleteEventHandler
• backup types
  • full backup / Getting ready
  • differential backup / Getting ready
  • transaction log backup / Getting ready
• bcp
  • URL / There's more...
• bcp command-line utility
  • used, for performing bulk export / Performing bulk export using the bcp command-line utility, How to do it...
  • used, for performing bulk import / Performing bulk import using the bcp command-line utility, Getting ready, How it works...
• bcp format file options
  • URL / There's more...
• bcp utility
  • URL / There's more..., There's more...
  • references / There's more...
• binary data
  • storing, in SQL Server / Storing binary data in SQL Server, Getting ready, How to do it..., How it works...
  • extracting, from SQL Server / Extracting binary data from SQL Server, How to do it..., How it works...
• binary large objects (BLOBs)
  • about / Introduction
• blocking process
  • killing / Killing a blocking process, How to do it..., There's more...
• BoeProx, PowerShell MVP
  • URL / Listing notable PowerShell features
• bulk export
  • performing, Invoke-SqlCmd used / Performing bulk export using Invoke-SqlCmd, How it works...
  • performing, bcp command-line utility used / Performing bulk export using the bcp command-line utility, How to do it...
• bulk import
  • performing, BULK INSERT used / Performing bulk import using BULK INSERT, How to do it..., How it works...
  • performing, bcp command-line utility used / Performing bulk import using the bcp command-line utility, Getting ready, How it works...
• BULK INSERT
  • used, for performing bulk import / Performing bulk import using BULK INSERT, How to do it..., How it works...
• Bulk Logged and Full Recovery Model
  • about / How it works...
• BulkLogged recovery
  • URL / There's more...
• Business Intelligence (BI)
  • about / Introduction
• Business Intelligence Development Studio (BIDS)
  • about / How it works...

C

• -Class switch
  • URL / How it works...
• C# code
  • embedding / Embedding C# code, How it works...
• CatalogFolder class
  • URL / There's more...
• CatalogItem class
  • URL / There's more...
• certificate
  • creating / Creating a certificate, How to do it..., There's more...
  • URL / There's more...
• Change Data Capture (CDC)
  • about / There's more...
• change tracking
  • enabling / Enabling/disabling change tracking, How to do it...
  • disabling / Enabling/disabling change tracking, How to do it...
• Change Tracking (CT)
  • about / There's more...
  • references / There's more...
• Chocolatey repository
  • URL / Listing notable PowerShell features
• Client Tools SDK
  • installing / Getting ready
• cmdlets / Cmdlets
  • writing, URL / There's more...
  • defining, that support folder manipulation / How it works..., How it works...
  • archiving / Listing notable PowerShell features
• cmdlets, for SharePoint 2013
  • URL / How it works...
• Code Access Security (CAS)
  • about / There's more...
• CodePlex
  • URL / How it works...
• comma-separated value (CSV)
  • about / How it works...
• commandlets
  • about / Cmdlets
• comment-based help
  • about / How it works...
  • URL / There's more...
• Comment-Based Help
  • about / Comments
• comment-based help header comment
  • creating / How it works...
• Common Criteria
  • URL / There's more...
• Common Criteria compliance
  • enabling / Enabling Common Criteria compliance, How to do it..., How it works...
• Common Criteria feature, in SQL Server
  • URL / There's more...
• Common Engineering Criteria program
  • URL / Understanding the need for PowerShell
• Common Language Runtime (CLR)
  • about / Introduction, How it works...
• compression and Solid State Disks
  • references / How it works...
• condition
  • creating / Creating a condition, How to do it..., How it works...
• configuration values
  • URL / How it works...
• ConvertTo-HTML cmdlet
  • URL / There's more...
• ConvertTo-Json cmdlet
  • URL / There's more...
• CreateCatalogItem method
  • URL / There's more...
• CSV and XML
  • exporting to / Exporting to CSV and XML, How it works...
• Cumulative Update (CU)
  • about / There's more...
• Customer Service and Support (CSS)
  • about / There's more...

D

• data
  • importing, from text file / Importing data from a text file, How to do it..., There's more...
  • extracting, from web service / Extracting data from a web service, How it works..., There's more...
• database
  • creating / Creating a database, How it works...
  • dropping / Dropping a database, How to do it...
  • detaching / Detaching a database, How to do it..., There's more...
  • references / How it works...
  • attaching / Attaching a database, Getting ready, How to do it..., How it works...
  • copying / Copying a database, How to do it..., How it works...
  • restoring, to point-in-time / Restoring a database to a point-in-time, Getting ready, How it works...
  • backing up, to Azure Blob storage / Backing up database to Azure Blob storage, How to do it..., How it works...
• Database Mail
  • setting up / Setting up Database Mail, How to do it..., How it works...
• database mappings
  • listing / Listing logins, users, and database mappings, How to do it..., How it works..., There's more...
• database master key
  • creating / Creating a database master key, How it works...
• database mirroring
  • limitations / Introduction
• database mirroring endpoint
  • URL / There's more...
• database objects
  • searching / Searching for database objects, How it works..., There's more...
• database owner
  • changing / Changing database owner, How to do it..., How it works...
• DatabasePermissionSet class
  • URL / There's more...
• database properties
  • altering / Altering database properties, How to do it..., How it works...
• database recovery model
  • changing / Changing database recovery model, Getting ready, How it works..., There's more...
• database role
  • creating / Creating a database role, How to do it..., How it works...
• database snapshot
  • listing / Listing database snapshots, How to do it...
  • URL / There's more...
  • creating / Creating a database snapshot, How it works...
  • dropping / Dropping a database snapshot, How to do it...
• database user
  • creating / Creating a database user, How to do it..., How it works...
  • permissions, assigning to / Assigning permissions to a database user, Getting ready, How to do it...
• DataFile class
  • URL / How it works...
• data file size
  • increasing / Increase data file size, How it works...
• data source reference, SSRS report
  • changing / Changing an SSRS report's data source reference, How to do it..., How it works...
• dates, in PowerShell
  • references / There's more...
• DBCC commands
  • running / Running DBCC commands, How to do it...
• DDL Event Groups
  • URL / There's more...
• Declarative Management Framework (DMF)
  • about / How it works...
• Desired State Configuration (DSC)
  • about / How to do it..., There's more..., Listing notable PowerShell features
  • URL / There's more..., Listing notable PowerShell features
• Desired State Configuration(DSC)
  • about / Listing notable PowerShell features
• differential backup
  • creating / Creating a differential backup, How to do it..., There's more...
• directories and paths, in FileTables
  • URL / There's more...
• disk-based indexes
  • about / How it works...
• disk space usage
  • checking / Checking disk space usage, How to do it..., How it works..., There's more...
• domain accounts
  • creating / Creating domain accounts
• domain controller (optional)
  • configuring / Configuring a domain controller (optional)
  • URL / Configuring a domain controller (optional)
• Dynamic Host Configuration Protocol (DHCP)
  • about / How it works...
• Dynamic Linked Library (DLL)
  • about / How it works...
• dynamic namespaces, in SSRS
  • URL / There's more...

E

• e-mail
  • sending / Sending an e-mail, There's more...
• empty virtual machine
  • creating / Creating an empty virtual machine
• Enable-PSRemoting permission
  • URL / There's more...
• encryption_state values, of sys.dm_database_encryption_keys
  • URL / There's more...
• enumeration values
  • URL / How it works...
• EnumFragmentation method
  • URL / There's more...
• EnumProcesses method
  • URL / There's more...
• environment
  • setting up / Setting up the environment
• error messages
  • obtaining / Getting more error messages, How it works...
• evaluation methods
  • URL / How it works...
• evaluation mode
  • defining / How it works...
• EvaluationMode enumeration values
  • URL / There's more...
• event log
  • reading / Reading an event log, How it works...
• Execution Policy settings
  • about / Execution Policy
• Export-Clixml
  • URL / There's more...
• Export-Csv
  • URL / There's more...
• ExpressionNode
  • URL / See also
• ExpressionNodeOperator
  • URL / There's more...
• Extensible Stylesheet Language (XSL)
  • about / How it works...
  • URL / There's more...

F

• Fabulous Manual
  • URL / There's more...
• facets
  • listing / Listing facets and their properties, How it works...
  • properties, listing / Listing facets and their properties, How it works...
  • URL / There's more...
• failed login attempts
  • listing / Listing failed login attempts, How it works...
• Failover Cluster feature
  • installing, on Windows / Installing the Failover Cluster feature on Windows, How to do it..., How it works..., There's more...
• file
  • SSIS package, downloading to / Downloading an SSIS package to a file, How it works...
• filegroup
  • creating / Creating a filegroup, How to do it..., How it works...
  • secondary data file, adding to / Adding a secondary data file to a filegroup, How it works...
  • index, moving to / Moving an index to a different filegroup, How to do it..., How it works..., There's more...
• filegroup backup
  • creating / Creating a filegroup backup, How it works...
• FileList information
  • listing / Listing backup header and FileList information, How to do it..., How it works...
• files
  • adding, to FileTable / Adding files to a FileTable, How to do it..., How it works...
  • manipulating / Manipulating files, How it works...
  • compressing / Compressing files, How it works...
  • searching / Searching for files, How it works...
• FileStream
  • enabling / Enabling FileStream, How it works..., There's more...
  • URL / There's more...
• FileStream Filegroup
  • setting up / Setting up a FileStream filegroup, How to do it..., How it works..., There's more...
• FileTable
  • adding / Adding a FileTable, How it works...
  • files, adding to / Adding files to a FileTable, How to do it..., How it works...
• FileTable feature
  • URL / There's more...
• folders
  • managing / Managing folders, There's more...
  • references / There's more..., There's more...
• format file
  • defining / How to do it...
• format strings
  • defining / How it works...
• FOR XML clause
  • URL / There's more...
• FrequencyInterval documentation
  • URL / There's more...
• FrequencyType
  • URL / There's more...
• full-text catalog
  • adding / Adding full-text catalog, How to do it..., How it works...
  • references / There's more...
• full-text index
  • adding / Adding full-text index, How to do it..., How it works...
  • URL / There's more..., How it works...
• full backup
  • creating / Creating a full backup, How to do it..., How it works..., There's more...
• fully qualified domain name (FQDN)
  • about / How it works...
• functions
  • scripts, converting into / Converting scripts into functions

G

• Get-Alias cmdlet
  • URL / There's more...
• Get-ChildItem
  • URL / There's more...
• Get-Credential
  • URL / How it works...
• Get-Credential cmdlet
  • about / How it works...
• Get-EventLog cmdlet
  • URL / There's more...
• Get-Help cmdlet
  • PowerShell script, documenting for / Documenting PowerShell script for Get-Help, How to do it..., How it works..., There's more...
  • URL / Get-Help
• Get-Hotfix
  • URL / How it works...
  • references / How it works...
• Get-Process Cmdlet
  • references / There's more...
• Get-WinEvent
  • URL / There's more...
• GetItemDefinition method
  • URL / There's more...
• GetPolicies method
  • URL / There's more...
• Global Assembly Cache (GAC)
  • about / How it works...
• Graphical User Interface (GUI)
  • about / Introduction
• guest machine
  • about / Terminologies
• guest OS
  • Windows Server 2012 R2, installing as / Installing Windows Server 2012 R2 as guest OS

H

• HADR endpoint
  • creating / Creating and enabling the HADR endpoint, How to do it..., How it works...
  • enabling / Creating and enabling the HADR endpoint, How to do it..., How it works...
  • CONNECT permission, granting to / Granting the CONNECT permission to the HADR endpoint, How it works..., There's more...
• health, of Availability Group
  • monitoring / Monitoring the health of an Availability Group, How to do it..., How it works..., There's more...
• high availability disaster recovery (HADR)
  • about / Introduction
• history
  • obtaining / Getting history, How it works...
• hotfix
  • about / There's more...
  • URL / There's more...
• hotfixes and service packs
  • URL / There's more...
• HTML report
  • creating / Creating an HTML report, How to do it..., How it works...

I

• I Love You virus
  • URL / The execution policy
• In-Memory OLTP
  • URL / There's more...
• index
  • creating / Creating an index, How to do it..., How it works..., There's more...
  • moving, to different filegroup / Moving an index to a different filegroup, How to do it..., How it works..., There's more...
  • reorganizing / Reorganizing/rebuilding an index, How it works...
  • rebuilding / Reorganizing/rebuilding an index, How it works...
  • references / How it works...
• index fragmentation
  • checking / Checking index fragmentation, How to do it..., How it works..., There's more...
• InheritParentSecurity method
  • URL / There's more...
• installed hotfixes
  • listing / Listing installed hotfixes and Service Packs, How it works..., There's more...
• Integrated Scripting Environment (ISE)
  • about / How to do it..., Running PowerShell scripts, Listing notable PowerShell features
• IntegrationServices assembly
  • URL / There's more..., There's more...
• Integration Services Project Deployment File Format
  • URL / There's more...
• Intellisense feature
  • about / How it works...
• International Organization for Standardization (ISO)
  • about / Terminologies
• International Standards Organization (ISO)
  • about / How it works...
• Invoke-Expression
  • using / Using Invoke-Expression, How it works...
• Invoke-Expression cmdlet
  • URL / There's more...
• Invoke-ProcessCube cmdlet
  • URL / There's more...
• Invoke-SqlCmd
  • used, for performing bulk export / Performing bulk export using Invoke-SqlCmd, How it works...
• invoke code and executables, in PowerShell
  • URL / Running scripts
• ISO Creator
  • URL / Terminologies
• ISPAC file
  • deploying, to SSISDB / Deploying an ISPAC file to SSISDB, How to do it..., How it works..., There's more...

J

• JavaScript Object Notation (JSON)
  • about / How it works...
• JSON file
  • creating, from SQL Server / Creating a JSON file from SQL Server, How to do it..., How it works...

K

• KB number
  • about / How it works...

L

• last backup date
  • checking / Checking last backup date, How to do it..., How it works...
• line continuation
  • defining / Line continuation
• LoadFromDtsServer Method
  • URL / There's more..., There's more...
• LoadFromSqlServer Method
  • URL / There's more...
• LoadPackage Method
  • URL / There's more...
• LocalDB
  • connecting to / Connecting to LocalDB, How it works..., There's more...
  • URL / How it works..., Getting ready
  • about / How it works...
  • references / There's more...
• LocalDB, with SQL Server Express
  • URL / Getting ready
• LocalDB instance
  • creating / Creating a new LocalDB instance, How it works...
• log backups
  • URL / There's more...
• Logical Sequence Number (LSN)
  • about / How it works...
• login
  • creating / Creating a login, How to do it..., How it works...
  • permissions and roles, assigning to / Assigning permissions and roles to a login, How to do it..., How it works...
• login/user roles and permissions
  • listing / Listing login/user roles and permissions, How it works...
• logins
  • listing / Listing logins, users, and database mappings, How to do it..., How it works..., There's more...

M

• MagicISO
  • URL / Terminologies
• Management Object Framework (MOF)
  • about / There's more...
• MasterKey class
  • URL / There's more...
• memory-optimized indexes
  • about / How it works...
• memory-optimized table
  • creating / Creating a memory-optimized table, How to do it..., How it works...
• memory-optimized tables
  • references / There's more...
• MemoryStream class
  • URL / There's more...
• Microsoft Azure Virtual Machines
  • URL / Terminologies
• Microsoft Connect item
  • URL / Get-Help
• Microsoft Web Platform Installer
  • URL / Getting ready
• Mirrored Backup Media Sets
  • URL / There's more...
• Mirrored Media Sets
  • backup, creating / Creating a backup on Mirrored Media Sets, How to do it..., How it works...
• MSDN
  • URL / There's more...
• MSDN Channel 9 PowerShell Webcasts
  • URL / Exploring more PowerShell
• multiple database, backing up
  • URL / There's more...
• multiple servers
  • SQL query, executing to / Executing SQL query to multiple servers, How to do it..., How it works...

N

• .NET 3.5
  • about / Installing SQL Server 2014 on a VM
  • URL / Installing SQL Server 2014 on a VM
• .NET format specifiers
  • URL / There's more...
• named pipes
  • enabling, in SQL Server / Enabling TCP and named pipes in SQL Server, How to do it...
• namespace collision issue
  • URL / There's more...
• Nero Burning Software
  • URL / Terminologies
• network protocols, in SQL Server
  • URL / There's more...
• Network Switch cmdlets
  • about / Listing notable PowerShell features
• New-WebServiceProxy
  • URL / There's more...
• New-WebServiceProxy cmdlet
  • URL / There's more...
• newline
  • about / Statement terminators
• NORECOVERY option
  • used, for restoring latest good full backup / Restoring the latest good full backup with NORECOVERY
  • used, for restoring last good differential backup / Restoring the last good differential backup taken after the full backup you just restored with NORECOVERY
• notable PowerShell features
  • listing / Listing notable PowerShell features

O

• online piecemeal restore
  • performing / Performing an online piecemeal restore, How to do it..., How it works...
  • URL / How it works...
• OPENROWSET method
  • URL / There's more...
• operating systems, for SQL Server 2014
  • URL / How to do it...
• orphaned users
  • fixing / Fixing orphaned users, How to do it..., How it works..., There's more...

P

• PackageInfo
  • URL / There's more...
• PackageManagement module
  • URL / Listing notable PowerShell features
• package store
  • SSIS package, deploying to / Deploying an SSIS package to the package store, How to do it..., How it works...
• parameters
  • ACTION / How it works...
  • IACCEPTSQLSERVERLICENSETERMS / How it works...
  • UPDATEENABLED / How it works...
  • FEATURES / How it works...
  • INSTANCENAME / How it works...
  • AGTSVCACCOUNT / How it works...
  • AGTSVCSTARTUPTYPE / How it works...
  • SQLCOLLATION / How it works...
  • SQLSVCACCOUNT / How it works...
  • SQLSYSADMINACCOUNTS / How it works...
  • TCPENABLED / How it works...
  • references / How it works...
• parameters, full backup
  • defining / How it works...
• parameters, log backups
  • defining / How it works...
• parameters, Mirrored Backup Media Sets
  • defining / How it works...
• patterns
  • defining / How it works...
• PercentCompleteEventHandler
  • defining / More about backup and PercentCompleteEventHandler
  • URL / See also
• permissions, AlwaysOn
  • URL / There's more...
• piecemeal restores
  • performing, URL / There's more...
• planned failovers
  • references / There's more...
• point-in-time restore
  • performing / How it works...
  • URL / There's more...
• policies
  • listing / Listing policies, How to do it..., How it works...
• policy
  • exporting / Exporting a policy, Getting ready, How to do it..., How it works...
  • importing / Importing a policy, How to do it..., How it works..., See also
  • creating / Creating a policy, How it works...
  • evaluating / Evaluating a policy, How to do it..., There's more...
• Policy Based Management (PBM)
  • about / Introduction, How it works...
• PowerISO
  • URL / Terminologies
• PowerScripting Podcasts
  • URL / Exploring more PowerShell
• PowerShell
  • about / Introduction, Introduction, Introduction
  • using / Introduction, Understanding the need for PowerShell
  • modules / PowerShell modules
  • used, for installing SQL Server / Installing SQL Server using PowerShell, How to do it..., How it works..., There's more...
  • used, for executing SSIS package / Executing an SSIS package stored in a package store or filesystem, How to do it..., How it works...
  • need for / Understanding the need for PowerShell
  • learning / Learning PowerShell
  • Get-Command / Get-Command
  • Get-Help / Get-Help
  • Get-Member / Get-Member
  • defining / Starter notes, Cmdlets may have aliases or you can create one
  • working, with .NET / PowerShell is object-oriented and works with .NET
  • cmdlets / Cmdlets may have aliases or you can create one, Common cmdlets
  • aliases, defining / Cmdlets may have aliases or you can create one
  • commands, chaining / You can chain commands
  • formatting / Filter left, format right
  • package / Package and reuse
  • reusing / Package and reuse
  • classes / Listing notable PowerShell features
  • debugging / Listing notable PowerShell features
  • exploring / Exploring more PowerShell
  • references / Exploring more PowerShell
• PowerShell admin regex article
  • URL / There's more...
• PowerShell basics
  • learning / Learning PowerShell basics, Cmdlets
  • cmdlets / Cmdlets
• PowerShellGallery
  • URL / Listing notable PowerShell features
• PowerShell ISE (x86)
  • using / How it works...
• PowerShell Magazine
  • URL / Exploring more PowerShell
• PowerShell remoting
  • using / Using PowerShell remoting, Getting ready, How it works..., There's more...
  • references / There's more...
• PowerShell script
  • documenting, for Get-Help / Documenting PowerShell script for Get-Help, How to do it..., How it works..., There's more...
• PowerShell scripts
  • running / Running PowerShell scripts
• PowerShell scripts, running
  • through shell / Through shell or through the ISE
  • through ISE / Through shell or through the ISE
  • execution policy / The execution policy
• PowerShell team blog
  • URL / See also
• PowerShell V5
  • installing / Installing PowerShell V5
  • URL / Installing PowerShell V5
• PowerShell versions
  • running / Running different PowerShell versions
• PowerShell WMI Explorer
  • URL / There's more...
• PowerShell Workflows (PSWF)
  • about / Listing notable PowerShell features
  • URL / Listing notable PowerShell features
• processes
  • listing / Listing processes, How to do it..., How it works...
• Process ID (PID)
  • about / How it works...
• profiler trace event
  • running / Running and saving a profiler trace event, How to do it..., How it works...
  • saving / Running and saving a profiler trace event, How to do it..., How it works...
  • URL / There's more...
• program
  • running, as administrator / Running as an administrator
• properties, data file
  • defining / How it works...
• properties, settings/configurations
  • Information / How it works...
  • Settings / How it works...
  • UserOptions / How it works...
  • Configuration / How it works...
• protocols, SQL Server installation
  • shared memory / How it works...
  • named pipes / How it works...
  • TCP/IP / How it works...
• proxy
  • creating / Creating a proxy, How to do it..., How it works..., There's more...
• PSCustomObject
  • about / Listing notable PowerShell features

Q

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

R

• ReadErrorLog method
  • URL / How it works...
• Really Simple Syndication (RSS)
  • about / There's more...
• records
  • exporting, to text file / Exporting records to a text file, How it works...
• recovery model
  • URL / There's more...
• Recovery Point Objective (RPO)
  • about / There's more...
• Recovery Time Objective (RTO)
  • about / There's more...
• Red Hat Package Manager(RPM)
  • about / Listing notable PowerShell features
• Regex Methods
  • URL / There's more...
• regular expressions
  • testing / Testing regular expressions, How it works..., There's more...
  • URL / There's more...
• Reporting Services
  • configuring, in native mode / Configuring Reporting Services in native mode
  • URL / Configuring Reporting Services in native mode
• Report Manager
  • SSRS report, uploading to / Uploading an SSRS report to Report Manager, How it works..., There's more...
• Report Server Namespace Management Methods
  • URL / There's more...
• ReportService.DataSourceDefinition class
  • URL / There's more...
• ReportService2010.CreateFolder method
  • URL / There's more...
• ReportViewer
  • used, for viewing SSRS report / Using ReportViewer to view your SSRS report, How to do it..., How it works...
• ReportViewer Class
  • URL / There's more...
• ReportViewer Properties
  • URL / There's more...
• ReportViewer Web Server and Windows Form Controls
  • URL / There's more...
• ReportViewer Web Server and Windows Forms Controls
  • URL / There's more...
• Residual Information Protection
  • about / There's more...
• Restore-ASDatabase cmdlet
  • URL / There's more...
• Restore class
  • URL / There's more...
• RSS feed
  • creating, from SQL Server content / Creating an RSS feed from SQL Server content, How to do it..., How it works...
  • XSL, applying to / Applying XSL to an RSS feed, How it works..., There's more...
• RSS feeds
  • URL / There's more...
• RTM (Release to Manufacturing)
  • about / There's more...
• running/blocking processes
  • listing / Listing running/blocking processes, How to do it..., How it works..., There's more...

S

• @sqlcoffee
  • URL / There's more...
• sample code
  • working with / Working with the sample code, How to do it...
• sample databases
  • installing / Installing sample databases
  • installing, URL / Installing sample databases
• sample databases, SQL Server
  • URL / Installing sample databases
• scripts
  • running / Running scripts
  • converting, into functions / Converting scripts into functions
• secondary databases
  • references / There's more...
• secondary data file
  • adding, to filegroup / Adding a secondary data file to a filegroup, How it works...
• security issue
  • URL / How it works...
• security levels
  • SAFE / There's more...
  • EXTERNAL_ACCESS / There's more...
  • UNSAFE / There's more...
  • URL / There's more...
• semicolon
  • about / Statement terminators
• Send-MailMessage cmdlet
  • URL / There's more...
• Server Core
  • URL / Installing Windows Server 2012 R2 as guest OS
• ServerLoginMode enumeration values
  • URL / There's more..., More on legacy LoginMode values
• Server Management Objects (SMO)
  • about / Installing SQL Server Management Objects
• ServerPermission properties
  • URL / There's more..., There's more...
• ServerPermissionSet class
  • URL / There's more..., There's more...
• ServerReport.Render Method
  • URL / There's more...
• service-oriented cmdlets
  • and service methods, comparing / There's more...
• service accounts
  • references / There's more...
  • URL / Terminologies
• Service Pack
  • about / There's more...
• Service Packs
  • listing / Listing installed hotfixes and Service Packs, How it works..., There's more...
• SetItemDataSources method
  • URL / There's more...
• SetPolicies method
  • URL / There's more...
• settings, execution policy
  • Restricted / The execution policy
  • AllSigned / The execution policy
  • RemoteSigned / The execution policy
  • Unrestricted / The execution policy
  • Bypass / The execution policy
  • Undefined / The execution policy
• setup parameters
  • URL / How it works...
• SMO assemblies
  • loading / Loading SMO assemblies, There's more...
  • URL / There's more...
• SMO classes
  • URL / There's more...
• SMO DataType classes
  • URL / There's more...
• SMO indexes
  • URL / There's more...
• SMO index object
  • indexes, defining / There's more...
• SMO Object Model Diagram
  • URL / How it works...
• SMO Server Objects
  • exploring / Exploring SMO Server Objects, How to do it...
• SMO Transfer class
  • URL / There's more...
• Snapin
  • about / How it works...
  • tasks, defining / How it works...
• snapshot
  • making, as baseline / Making a snapshot as a baseline
• software
  • downloading / Downloading software
• special variables
  • defining / How it works..., Special variables
• SQL-related cmdlets and modules
  • discovering / Discovering SQL-related cmdlets and modules, How to do it..., How it works..., There's more...
• SQL Authentication
  • about / How to do it...
• SQLCLR assemblies
  • URL / There's more...
• SQLLocalDB utility
  • URL / There's more...
• SQL Management Objects (SMO)
  • about / Introduction
• SQLPS
  • about / There's more...
• SQLPSX
  • URL / Cmdlets
• SQL query
  • executing, to multiple servers / Executing SQL query to multiple servers, How to do it..., How it works...
• SQL Server
  • URL / How to do it..., There's more..., Installing SQL Server 2014 on a VM
  • installing, PowerShell used / Installing SQL Server using PowerShell, How to do it..., How it works..., There's more...
  • TCP, enabling in / Enabling TCP and named pipes in SQL Server, How to do it...
  • named pipes, enabling in / Enabling TCP and named pipes in SQL Server, How to do it..., How it works...
  • AlwaysOn feature, enabling in / Enabling AlwaysOn in SQL Server, How to do it..., How it works...
  • XML, inserting into / Inserting XML into SQL Server, How to do it..., How it works...
  • XML, extracting from / Extracting XML from SQL Server, How to do it..., How it works...
  • JSON file, creating from / Creating a JSON file from SQL Server, How to do it..., How it works...
  • binary data, storing / Storing binary data in SQL Server, Getting ready, How to do it..., How it works...
  • binary data, extracting from / Extracting binary data from SQL Server, How to do it..., How it works...
  • using, on Windows Azure VM / Using SQL Server on a Windows Azure VM
• SQL Server, on Windows Azure VM
  • URL / Using SQL Server on a Windows Azure VM
• SQL Server 2012 SSIS
  • URL / There's more...
• SQL Server 2014
  • installing, on VM / Installing SQL Server 2014 on a VM
• SQL Server 2014 trial version ISO file
  • URL / Downloading software
• SQL Server Analysis Services (SSAS)
  • about / Introduction
• SQL Server Analysis Services class
  • URL / There's more...
• SQL Server Audit
  • configuring / Configuring SQL Server Audit, How to do it..., How it works..., There's more...
  • URL / How it works...
  • references / There's more...
• SQL Server Backup
  • URL / There's more...
• SQL Server backups
  • URL / There's more...
• SQL Server binary
  • URL / How it works...
• SQL Server Browser
  • about / How it works...
• SQL Server builds
  • URL / There's more...
• SQL Server Configuration Manager (SSCM)
  • about / How it works...
• SQL Server configuration settings
  • listing / Listing SQL Server configuration settings, How to do it..., How it works...
• SQL Server content
  • RSS feed, creating from / Creating an RSS feed from SQL Server content, How to do it..., How it works...
• SQL Server credential
  • creating / Creating a credential, How to do it...
• SQL Server Database Engine Cmdlets
  • URL / There's more...
• SQL Server database inventory
  • creating / Creating a SQL Server database inventory, How it works...
• SQL Server Data Tools (SSDT)
  • about / How it works...
  • URL / Downloading software
• SQL Server Data Tools (SSDT-BI)
  • about / Getting ready
  • URL / Getting ready
• SQL Server Data Tools Business Intelligence
  • URL / Downloading software
• SQL Server event alert
  • adding / Adding a SQL Server event alert, How it works..., There's more...
• SQL Server Extended Events
  • URL / There's more...
• SQL Server Filestream
  • URL / There's more...
• SQL Server installation
  • Wizard, using / How it works...
  • via command prompt / How it works...
  • via configuration file / How it works...
  • via SysPrep / How it works...
• SQL Server Instance configurations
  • changing / Changing SQL Server Instance configurations, How to do it..., There's more...
• SQL Server instance inventory
  • creating / Creating a SQL Server instance inventory, How it works..., There's more...
• SQL Server Instance Object
  • creating / Creating a SQL Server Instance Object, How to do it..., How it works...
• SQL Server Instances
  • listing / Listing SQL Server instances, How to do it..., How it works..., There's more...
• SQL Server Integration Services (SSIS)
  • about / Introduction, How it works..., Introduction
• SQL Server Job
  • running / Running an SQL Server Job, How it works...
  • scheduling / Scheduling a SQL Server Job, How to do it..., How it works..., There's more...
• SQL Server Job class
  • URL / There's more...
• SQL Server Jobs
  • listing / Listing SQL Server Jobs, How to do it..., How it works...
  • creating / Creating a SQL Server Job, How to do it..., How it works...
  • URL / There's more...
• SQL Server log Errors
  • listing / Listing SQL Server log errors, How to do it..., How it works...
• SQL Server Management Objects
  • installing / Installing SQL Server Management Objects, Getting ready, How to do it...
• SQL Server Management Studio
  • about / Getting ready
• SQL Server Management Studio (SSMS)
  • about / Exploring the SQL Server PowerShell hierarchy, How to do it..., Introduction, How it works...
• SQL Server objects
  • URL / There's more...
• SQL Server operator
  • adding / Adding a SQL Server operator, How it works..., There's more...
  • URL / There's more...
• SQL Server PowerShell documentation
  • URL / See also
• SQL Server PowerShell hierarchy
  • exploring / Exploring the SQL Server PowerShell hierarchy, How to do it..., How it works...
• SQL Server Reporting Services (SSRS)
  • about / How it works..., Introduction
• SQL Server service account
  • changing / Changing SQL Server service account, How to do it..., How it works...
• SQL Server service accounts
  • listing / Listing SQL Server service accounts, How it works...
• SQL Server Services
  • discovering / Discovering SQL Server services, How to do it..., There's more...
  • starting / Starting/stopping SQL Server services, How to do it..., How it works..., There's more...
  • stopping / Starting/stopping SQL Server services, How to do it..., How it works..., There's more...
• SQL Server Stored Procedures
  • scripting / Scripting SQL Server Stored Procedures, How to do it..., How it works...
• SQL Server XML support
  • URL / There's more...
• SqlServiceType
  • values / There's more...
• SqlStoreConnection class
  • URL / There's more...
• SSAS cmdlets
  • listing / Listing SSAS cmdlets, How it works...
• SSAS cube
  • processing / Processing an SSAS cube, How to do it..., How it works...
• SSAS database
  • backing up / Backing up an SSAS database, How it works...
  • restoring / Restoring an SSAS database, How it works...
• SSAS instance properties
  • listing / Listing SSAS instance properties, How it works...
• SSDT-BI
  • URL / Getting ready
• SSISDB
  • SSIS package stored, executing / 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..., There's more...
  • URL / There's more...
• SSISDB folder
  • creating / Creating an SSISDB folder, How to do it..., How it works...
  • ISPAC file, deploying to / Deploying an ISPAC file to SSISDB, How to do it..., How it works..., There's more...
• SSIS instance and package store
  • folders, creating / Creating folders in an SSIS package store and MSDB, How to do it..., How it works...
• 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 a package store or filesystem, How to do it..., How it works...
  • downloading, to file / Downloading an SSIS package to a file, How it works...
• SSIS package stored
  • executing, in SSISDB / Executing an SSIS package stored in SSISDB, How to do it..., How it works...
• SSRS data source
  • creating / Creating an SSRS data source, Getting ready, How to do it..., How it works...
• SSRS folder
  • creating / Creating an SSRS folder, How to do it..., How it works...
• SSRS native mode, versus SharePoint integrated mode
  • URL / How it works...
• SSRS report
  • viewing, ReportViewer used / Using ReportViewer to view your SSRS report, How to do it..., How it works...
  • downloading, in Excel / Downloading an SSRS report in Excel and as a PDF, How to do it..., How it works..., There's more...
  • downloading, in PDF / Downloading an SSRS report in Excel and as a PDF, How to do it..., How it works..., There's more...
  • uploading, to Report Manager / Uploading an SSRS report to Report Manager, How it works..., There's more...
  • user, adding with role to / Adding a user with a role to 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 RDL files
  • downloading / Downloading all SSRS report RDL files, How it works...
• SSRS Report Server
  • items, listing / Listing items in your SSRS Report Server, How it works...
  • URL / There's more...
• Stack Overflow
  • URL / There's more...
• stored procedure
  • creating / Creating a stored procedure, How to do it..., How it works...
• supported network protocols
  • URL / There's more...
• symmetric and asymmetric keys
  • references / There's more...
• symmetric key
  • creating / Creating symmetric and asymmetric keys, How to do it..., How it works..., There's more...
• syntax
  • scripting / Scripting syntax
  • statement terminators / Statement terminators
  • escape and line continuation / Escape and line continuation
  • variables / Variables
  • operators / Operators
  • messages, displaying / Displaying messages
  • comments / Comments
  • special variables / Special variables
  • special characters / Special characters
  • conditions / Conditions
  • regular expressions / Regular expressions
  • arrays / Arrays
  • hash tables / Hash tables
  • loops / Loops
  • error handling / Error handling
• SysPrep
  • URL / How it works...
• system and permission requirements, for PowerShell
  • URL / Getting ready

T

• T-SQL
  • using / Introduction
  • URL / How it works...
• table
  • creating / Creating a table, How to do it..., How it works...
  • creating, in Azure SQL database / Creating a table in an Azure SQL database, How to do it..., How it works...
• TCP
  • enabling, in SQL Server / Enabling TCP and named pipes in SQL Server, How to do it...
• Technet Script Center
  • URL / There's more...
• template definition file (TDF)
  • about / Getting ready
• template library, CloudShare
  • URL / Introduction
• terminologies
  • URL / There's more...
  • Virtual machine, or VM / Terminologies
  • ISO file / Terminologies
  • service account / Terminologies
• text file
  • data, importing / Importing data from a text file, How to do it..., There's more...
  • records, exporting / Exporting records to a text file, How it works...
• timestamp
  • obtaining / Getting a timestamp, How it works...
• trace file contents
  • extracting / Extracting the contents of a trace file, How to do it..., How it works...
• transaction log backup
  • creating / Creating a transaction log backup, Getting ready, How it works...
• transaction logs
  • restoring, after differential backup / Restoring the transaction logs taken after your differential backup
• Transparent Database Encryption (TDE)
  • about / Introduction
• Transparent Data Encryption (TDE)
  • setting up / Setting up Transparent Data Encryption, How to do it..., How it works..., There's more...
  • about / Getting ready
  • URL / There's more...
• trigger
  • creating / Creating a trigger, How to do it..., How it works...

U

• Uniform Naming Convention (UNC)
  • about / How it works...
• user-defined assembly
  • creating / Creating a new assembly, How it works..., There's more...
  • listing / Listing user-defined assemblies, How it works...
  • extracting / Extracting user-defined assemblies, How to do it..., How it works...
• user-defined Server role
  • creating / Creating a user-defined server role, Getting ready, How to do it..., How it works...
• users
  • listing / Listing logins, users, and database mappings, How to do it..., How it works..., There's more...

V

• validator
  • URL / How to do it...
• variable expansion, in strings
  • URL / There's more...
• variables
  • here-string data type / Here-string
  • string interpolation / String interpolation
• Very Large Databases (VLDBs)
  • about / How it works...
• view
  • creating / Creating a view, How to do it..., How it works..., There's more...
• VirtualBox
  • URL / Terminologies
• Virtual Machine (VM)
  • about / Getting ready
• Visual Studio
  • URL / Downloading software
• VM
  • defining / VM details and accounts
  • references / VM details and accounts
  • SQL Server 2014, installing on / Installing SQL Server 2014 on a VM
• VMware
  • reference / Making a snapshot as a baseline
• VMware player
  • URL / Downloading software
• VMWare player documentation
  • URL / Downloading software
• VMware Snapshot Best Practices
  • reference / Making a snapshot as a baseline
• VMware tools
  • installing / Installing VMware tools
• VMware Workstation Player
  • URL / Terminologies
• VMware Workstation Pro
  • URL / Terminologies

W

• weather data
  • URL / Getting ready
• Web-based Enterprise Management (WBEM)
  • about / How it works...
  • URL / How it works...
• web service
  • data, extracting from / Extracting data from a web service, How it works...
• Web Services for Management (WSMan)
  • about / How it works...
• Win32_LogicalDisk
  • URL / There's more...
• Win32_Volume class
  • about / How it works...
  • URL / There's more...
• Windows
  • Failover Cluster feature, installing on / Installing the Failover Cluster feature on Windows, How to do it..., How it works..., There's more...
• Windows Azure VM
  • SQL Server, using on / Using SQL Server on a Windows Azure VM
• Windows Data Protection API
  • URL / How it works...
• Windows Management Framework (WMF)
  • about / How to do it...
  • URL / How to do it...
• Windows Management Framework 5 Preview April 2015
  • URL / Downloading software
• Windows Management Framework V5.0
  • URL / Listing notable PowerShell features
• Windows Management Instrumentation (WMI)
  • about / How it works..., How it works...
  • URL / How it works...
• Windows PowerShell Scripts
  • URL / Through shell or through the ISE
• Windows Remote Management (WinRM)
  • about / How it works...
• Windows Server 2012 R2
  • installing, as guest OS / Installing Windows Server 2012 R2 as guest OS
• Windows Server 2012 R2 trial version ISO file
  • URL / Downloading software
• Windows Server Failover Clustering
  • URL / There's more...
  • references / There's more...
• Windows Server Failover Clustering (WSFC)
  • about / Introduction
• Windows Server Hyper-V Server 2012 R2
  • URL / Terminologies
• WMI
  • about / How it works...
• WMI Provider for Server Events
  • URL / There's more...
• WMI Provider for Server Events Classes and Properties
  • URL / There's more...
• WMI Query Language (WQL)
  • about / How it works...
• WMI server event alerts
  • setting up / Setting up WMI server event alerts, Getting ready, How to do it..., How it works..., There's more...
  • values, defining / Getting ready
• WQL e-book
  • URL / There's more...
• Write-related cmdlets
  • defining / Displaying messages

X

• XML
  • inserting, into SQL Server / Inserting XML into SQL Server, How to do it..., How it works...
  • extracting, from SQL Server / Extracting XML from SQL Server, How to do it..., How it works...
  • parsing / Parsing XML, How it works...
• XSL
  • applying, to RSS feed / Applying XSL to an RSS feed, How it works...
• XslCompiledTransform .NET class
  • URL / There's more...
• xSqlPs module
  • about / There's more...
• xSqlServerInstall
  • about / There's more...

Z

• 7-Zip
  • URL / Getting ready