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.

• 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

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.

• 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

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.

• 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