coverpage
PowerShell for SQL Server Essentials
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Started with PowerShell
A brief history of PowerShell
The PowerShell environment
PowerShell versions
PowerShell cmdlets
PowerShell providers
Snap-ins and modules
PowerShell Pipeline
Scripting basics
Running PowerShell scripts
Getting help
Summary
Chapter 2. Using PowerShell with SQL Server
SQL Server via PowerShell
SQL Server-specific cmdlets
SQL Server Management Objects
Summary
Chapter 3. Profiling and Configuring SQL Server
Current server resources
Hotfixes and service packs
Current SQL Server instances
Services and service accounts
SQL Server error logs
Current instance configuration
Changing configurations
Summary
Chapter 4. Basic SQL Server Administration
Listing databases and tables
Adding files and filegroups
Checking enabled features
Scripting database objects
Attaching and detaching databases
Backing up and restoring databases
Reorganizing or rebuilding indexes
Managing logins users and permissions
Policies
Managing jobs
Summary
Chapter 5. Querying SQL Server with PowerShell
To PowerShell or not to PowerShell
Sending queries to SQL Server
Fixing orphaned users
Getting fragmentation data
Backing up and restoring databases
Exporting data using bcp
Summary
Chapter 6. Monitoring and Automating SQL Server
Getting to know helpful cmdlets
Scheduling PowerShell scripts
Checking logs
Monitoring failed jobs
Alerting on disk space usage
Logging blocked processes
Getting performance metrics
Summary
Appendix A. Implementing Reusability with Functions and Modules
Functions
Modules
Summary
Index
更新时间：2021-07-23 20:32:40
完结共75章
倒序