目錄(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
推薦閱讀
- 深入核心的敏捷開發：ThoughtWorks五大關鍵實踐
- 計算機網絡
- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Visual Basic程序設計教程
- 編寫高質量代碼：改善C程序代碼的125個建議
- 新編Premiere Pro CC從入門到精通
- Microsoft Azure Storage Essentials
- Scratch3.0趣味編程動手玩：比賽訓練營
- SciPy Recipes
- Getting Started with Polymer
- Web編程基礎：HTML5、CSS3、JavaScript（第2版）
- The Statistics and Calculus with Python Workshop
- 量子計算機編程：從入門到實踐
- 例解Python：Python編程快速入門踐行指南
- Magento 2 Developer's Guide
- PHP典型模塊與項目實戰大全
- Java項目驅動開發教程
- 軟件定義存儲：原理、實踐與生態
- 微信小程序開發零基礎入門
- 微機原理與接口實驗指導
- Build Applications with Meteor
- Java高級特性編程及實戰
- 研發質量保障與工程效率
- Java 9 Data Structures and Algorithms
- C#程序設計教程
- 從零開始學Python數據分析（視頻教學版）
- Access 2010基礎教程
- Python 網絡爬蟲實戰
- Learning Shell Scripting with Zsh
- 狼書（卷3）：Node.js高級技術
