Real-World SQL-DMO for SQL Server - Allan Mitchell, Mark Allison

Real-World SQL-DMO for SQL Server

Buch | Softcover
432 Seiten
2002 | Softcover reprint of the original 1st ed.
Apress (Verlag)
978-1-59059-040-9 (ISBN)
46,00 inkl. MwSt
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.

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.

1 Getting Started with SQL-DMO.- 2 Backup and Restore: A DBA’s Bread and Butter.- 3 Managing Users of Your Database and Server.- 4 Using SQL-DMO with OLE Automation.- 5 Jobs, Alerts, and Operators.- 6 Viewing and Setting Server-wide Options.- 7 Replication and SQL-DMO.- 8 QALite.- 9 Using SQL-DMO to Script an Entire Server.- Appendix A SQL-DMO Object Library Quick Reference.- SQLServers Collection.- Databases Collection.- DatabaseRoles Collection.- FileGroups Collection.- DBFiles Collection.- FullTextCatalogs Collection.- StoredProcedures Collection.- Tables Collection.- Columns Collection.- Users Collection.- Views Collection.- Triggers Collection.- Jobs Collection.- JobSchedules Collection.- JobSteps Collection.- Operators Collection.- Logins Collection.- Replication Object.- The SQL-DMO Object Model.- Appendix B Knowledge-Base Articles and Other SQL-DMO Resources.- Bugs.- Fixes.- Problems.- Information and How-To’s.- Useful URLs.

Zusatzinfo 174 Illustrations, black and white; XXVII, 432 p. 174 illus.
Verlagsort Berkley
Sprache englisch
Maße 191 x 235 mm
Themenwelt Informatik Datenbanken SQL Server
Mathematik / Informatik Informatik Programmiersprachen / -werkzeuge
Mathematik / Informatik Informatik Software Entwicklung
Schlagworte Database Programming • Microsoft SQL Server 2000
ISBN-10 1-59059-040-6 / 1590590406
ISBN-13 978-1-59059-040-9 / 9781590590409
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Der schnelle Einstieg

von Klemens Konopasek

Buch (2018)
Carl Hanser (Verlag)
40,00
Das umfassende Handbuch. Inkl. Analysis und Reporting Services

von Daniel Caesar; Michael R. Friebel; Hans Georg Selent-Knips

Buch | Hardcover (2020)
Rheinwerk (Verlag)
49,90