目錄(75章)
倒序
- 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
推薦閱讀
- Photoshop智能手機APP UI設計之道
- Developing Mobile Web ArcGIS Applications
- Instant 960 Grid System
- Python GUI Programming Cookbook
- Hands-On C++ Game Animation Programming
- Java EE 7 Performance Tuning and Optimization
- Microsoft Azure Storage Essentials
- Yii Project Blueprints
- 微服務從小白到專家：Spring Cloud和Kubernetes實戰
- Babylon.js Essentials
- Red Hat Enterprise Linux Troubleshooting Guide
- Learning VMware vSphere
- Mastering OpenStack
- 3ds Max 2018從入門到精通
- Scratch少兒編程高手的7個好習慣
- PHP典型模塊與項目實戰大全
- Expert Cube Development with SSAS Multidimensional Models
- HTML5+jQuery Mobile移動應用開發
- Learning Java by Building Android Games
- RStudio for R Statistical Computing Cookbook
- ServiceStack 4 Cookbook
- Build Applications with Meteor
- 新時期的Node.js入門
- 區塊鏈技術及應用
- JavaScript深度學習
- Microservices with Azure
- 精通Hibernate
- C++程序設計教程
- Oracle BPM Suite 11g：Advanced BPMN Topics
- 從零開始學C程序設計
