Index
A
- ADO.NET
- assemblies, SQL Server / SQL Server assemblies
B
- backing up
- about / Backing up
- Backup-SqlDatabase cmdlet / Backing up
- bcp
- used, for exporting data / Exporting data using bcp
- binary module / Modules
C
- -Confirm parameter / Getting help from other cmdlets
- CmdletBinding attribute
- URL / Advanced functions
- cmdlets
- about / Getting to know helpful cmdlets
- Send-MailMessage cmdlet / The Send-MailMessage cmdlet
- ConvertTo-Html cmdlet / The ConvertTo-Html cmdlet
- Export-Csv cmdlet / The Export-Csv cmdlet
- Write-EventLog cmdlet / The Write-EventLog cmdlet
- additional / Additional cmdlets
- comment-based help / Advanced functions
- configurations, changing
- about / Changing configurations
- services, starting / Start or stop services
- service account, changing / Changing a service account
- instance settings, changing / Changing instance settings
- ConvertTo-Html cmdlet / The ConvertTo-Html cmdlet
D
- data
- exporting, bcp used / Exporting data using bcp
- database
- listing / Listing databases and tables
- files, listing / Listing database files and filegroups
- filegroups, listing / Listing database files and filegroups
- attaching / Attaching and detaching databases, Detaching databases
- detaching / Attaching and detaching databases, Detaching databases
- users, adding / Adding database users
- backing up / Backing up and restoring databases
- restoring / Backing up and restoring databases
- database objects
- scripting / Scripting database objects
- disk space
- usage, alterting / Alerting on disk space usage
- dynamic linked libraries (DLLs) / SQL Server snap-ins
- dynamic linked library (DLLs) / Snap-ins and modules
- Dynamic Management Functions (DMFs) / Getting fragmentation data
- Dynamic Management Views (DMVs) / Getting fragmentation data
- dynamic module / Modules
E
- execution policies
- about / The execution policy
- Export-Csv cmdlet / The Export-Csv cmdlet
F
- failed jobs
- monitoring / Monitoring failed jobs
- filegroups
- listing / Listing database files and filegroups
- adding / Adding files and filegroups
- files
- listing / Listing database files and filegroups
- adding / Adding files and filegroups
- fragmentation data
- obtaining / Getting fragmentation data
- functions
- about / Functions
- simple / Simple functions
- advanced / Advanced functions
- best practices / Best practices
G
- Graphical User Interface (GUI) / The PowerShell ISE
H
- hotfixes
- and service packs / Hotfixes and service packs
I
- indexes
- about / Reorganizing or rebuilding indexes
- rebuilding / Reorganizing or rebuilding indexes
- reorganizing / Reorganizing or rebuilding indexes
- Integrated Scripting Environment (ISE) / The PowerShell ISE
- Invoke-Expression cmdlet
- used, for sending queries / The Invoke-Expression cmdlet
- Invoke-Sqlcmd cmdlet
- used, for sending queries / The Invoke-Sqlcmd cmdlet
J
- jobs
- managing / Managing jobs
L
- log blocking processes
- about / Logging blocked processes
- logins
- managing / Managing logins, users, and permissions
- adding / Adding a login
- logman
- logs
- checking / Checking logs
M
- manifest module / Modules
- Microsoft Installer (MSI) / Hotfixes and service packs
- mini-shell (sqlps utility) / Mini-shell (or the sqlps utility)
- modules
- Monad Manifesto
- MSDN
N
- Noun-Verb convention
- URL / Simple functions
O
- Operating System (CmdExec) ste / Scheduling PowerShell scripts
- orphaned users
- fixing / Fixing orphaned users
P
- parameters
- URL / Advanced functions
- Performance Logs and Alerts (PLA) DataCollectorSet object
- URL / Getting performance metrics
- about / Getting performance metrics
- AutoPathFormat enumeration / Getting performance metrics
- CommitMode enumeration / Getting performance metrics
- performance metrics
- obtaining / Getting performance metrics
- permissions
- managing / Managing logins, users, and permissions
- about / Permissions
- values, URL / Adding database users
- pipeline
- about / PowerShell Pipeline
- policies
- about / Policies
- PowerShell
- history / A brief history of PowerShell
- environment / The PowerShell environment
- console / The PowerShell console
- ISE / The PowerShell ISE
- running, as administrator / Running PowerShell as an administrator
- execution, policy / The execution policy
- scripts, URL / The execution policy
- versions / PowerShell versions
- cmdlets / PowerShell cmdlets
- providers / PowerShell providers
- pipeline / PowerShell Pipeline
- scripts, running / Running PowerShell scripts
- help / Getting help
- help, getting from cmdlets / Getting help from other cmdlets
- configurations, changing / Changing configurations
- about / To PowerShell or not to PowerShell
- scripts, scheduling / Scheduling PowerShell scripts
- best practices, URL / Best practices
- PowerShell cmdlets
- naming conventions / Cmdlet naming convention
- parameters / Cmdlet parameters
- aliases / Cmdlet aliases
- URL / Advanced functions
- PowerShell ISE
- about / The PowerShell ISE
- features / The PowerShell ISE
- processes
- listing / Listing the processes
- PSProvider DLLs
- URL / The Invoke-Sqlcmd cmdlet
Q
- queries
- sending, to SQL Server / Sending queries to SQL Server
- simple queries, sending / Sending simple queries to SQL Server – different variations
- queries, sending
- SQL Server Management Objects used / SQL Server Management Objects
- Invoke-Sqlcmd cmdlet / The Invoke-Sqlcmd cmdlet
- ADO.NET used / ADO.NET
- Invoke-Expression cmdlet used / The Invoke-Expression cmdlet
R
- replication
- resources, SQL Server
- current / Current server resources
- processor (CPU) information, obtaining / Getting processor (CPU) information
- memory, checking / Checking server memory
- disk space, checking / Checking disk space
- network settings, checking / Checking network settings
- restoring
- about / Restoring
S
- scripting
- basics / Scripting basics
- components / Scripting basics
- ScriptingOptions object
- script module / Modules
- script modules
- about / Script modules
- Send-MailMessage cmdlet / The Send-MailMessage cmdlet
- service packs
- and hotfixes / Hotfixes and service packs
- services
- and service accounts / Services and service accounts
- error logs / SQL Server error logs
- starting / Start or stop services
- stopping / Start or stop services
- account, changing / Changing a service account
- SMO
- about / SQL Server Management Objects, Creating SMO objects
- objects, creating / Creating SMO objects
- SMO transfer class
- snap-ins
- about / Snap-ins and modules
- URL / Snap-ins and modules
- cmdlets / Snap-ins and modules
- snap-ins, SQL Server
- about / SQL Server snap-ins
- SQL
- enabled features, checking / Checking enabled features
- SQLPS module / The SQLPS module
- SQL Server
- via PowerShell / SQL Server via PowerShell
- snap-ins / SQL Server snap-ins
- assemblies / SQL Server assemblies
- specific cmdlets / SQL Server-specific cmdlets
- instances / Current SQL Server instances
- services and service accounts / Services and service accounts
- error logs / SQL Server error logs
- instance configuration / Current instance configuration
- queries, sending / Sending queries to SQL Server
- SQL Server, via PowerShell
- mini-shell (sqlps utility) / Mini-shell (or the sqlps utility)
- SQLPS module / The SQLPS module
- SQL Server snap-ins / SQL Server snap-ins, SQL Server Management Objects
- SQL Server Management Objects
- used, for sending queries / SQL Server Management Objects
- SQL Server Management Studio (SSMS) / Mini-shell (or the sqlps utility)
- SSMS Query Editor
- URL / The Invoke-Sqlcmd cmdlet
T
- tables
- listing / Listing databases and tables
U
- users
- managing / Managing logins, users, and permissions
V
- Visual Basic Scripting Edition (VBScript) / A brief history of PowerShell
W
- -WhatIf parameter / Getting help from other cmdlets
- Win32_processor WMI class
- Windows Management Instrumentation (WMI)
- Windows Scripting Host (WSH) / A brief history of PowerShell
- Write-EventLog cmdlet / The Write-EventLog cmdlet