HAPPY HOLIDAYS: Get a special discount on Apress Access! Subscribe today >>

Real-World SQL-DMO for SQL Server

Authors: Mitchell, Allan, Allison, Mark

Download source code

Buy this book

eBook $39.99
price for USA
  • ISBN 978-1-4302-1108-2
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $49.99
price for USA
  • ISBN 978-1-59059-040-9
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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 database administrators routinely manage more than 50 SQL Servers, ensuring that the techniques can be implemented on environments of almost any scale.

Whether youre a developer or a database administrator, this book will take you to the next level in SQL Server administration.

About the authors

Allan Mitchell works as a lead data architect for a multinational media company in the United Kingdom. He provides developer and user support for all the company's SQL Servers, and he designs data solutions as well. He is an MCSE and an MCDBA, and in 2002 he was awarded the title of "Most Valuable Professional" by Microsoft. His interests include mountain biking and rugby. You can find Allan on the Microsoft public newsgroups and on the SSWUG list answering questions on a variety of topics. Allan is cofounder of Allison Mitchell Database Consultants Ltd., a successful database-consulting firm based in southeast England.

Table of contents (9 chapters)

  • Getting Started with SQL-DMO

    Mitchell, Allan (et al.)

    Pages 1-44

  • Backup and Restore: A DBA’s Bread and Butter

    Mitchell, Allan (et al.)

    Pages 45-97

  • Managing Users of Your Database and Server

    Mitchell, Allan (et al.)

    Pages 99-153

  • Using SQL-DMO with OLE Automation

    Mitchell, Allan (et al.)

    Pages 155-178

  • Jobs, Alerts, and Operators

    Mitchell, Allan (et al.)

    Pages 179-246

Buy this book

eBook $39.99
price for USA
  • ISBN 978-1-4302-1108-2
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $49.99
price for USA
  • ISBN 978-1-59059-040-9
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Real-World SQL-DMO for SQL Server
Authors
Copyright
2003
Publisher
Apress
Copyright Holder
Allan Mitchell and Mark Allison
eBook ISBN
978-1-4302-1108-2
DOI
10.1007/978-1-4302-1108-2
Softcover ISBN
978-1-59059-040-9
Edition Number
1
Number of Pages
XXVII, 432
Number of Illustrations and Tables
174 b/w illustrations
Topics