|
Real World SQL-DMO for SQL Server
Real-World SQL-DMO for SQL Server delves into the details of administering Microsoft SQL Server using the SQL-DMO object library. Authors Allan Mitchell and Mark Allison have packed the book with explanations and working code that will help you use the library to its full potential. Additionally, Mitchell and Allison offer advice about when (and when
not) to use the SQL-DMO application programming interface (API).
The code in this book has been tried and tested at sites where DBAs routinely manage more than 50 SQL Servers, ensuring that the techniques can be implemented on environments of almost any scale.
Whether you're a developer or a DBA, this book will take you to the level in SQL Server administration.
Chapter 1: Getting Started with SQL-DMO
Chapter 2: Backup and Restore: A DBA?s Bread and Butter
Chapter 3: Managing Users of Your Database and Server
Chapter 4: Using SQL-DMO with OLE Automation
Chapter 5: Jobs, Alerts, and Operators
Chapter 6: Viewing and Setting Server-wide Options
Chapter 7: Replication and SQL-DMO
Chapter 8: QALite
Chapter 9: Using SQL-DMO to Script an Entire Server
Appendix A SQL-DMO Object Library Quick Reference
Appendix B Knowledge-Base Articles and Other SQL-DMO Resources
|
