Binding: Paperback Dewey Decimal Number: 005.7585 EAN: 9781861002808 ISBN: 1861002807 Label: Wrox Press Manufacturer: Wrox Press Number Of Items: 1 Number Of Pages: 743 Publication Date: 1999-12 Publisher: Wrox Press Sales Rank: 1924333 Studio: Wrox Press
Editorial Review:
Amazon.com ReviewDespite its acronym-laden title, Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NS & DTS is actually a very readable and approachable guide to programming administrative modules for SQL Server 7.0. Aimed at the Visual Basic or C++ programmer, this book delivers a fine guide to the objects, API, and programmer strategies you'll need to do more with Microsoft databases.
Any database administrator uses the powerful SQL Server Enterprise Manager for a variety of database tasks, whether designing new databases, tables, and indexes, or backing-up, replicating, and copying data. The goal of this text is to let you perform these tasks programmatically by using the SQL Distributed Management Framework (DMF). After reading this book, you should be able to write programs that automate common database administration tasks.
This title begins with the objects that Enterprise Manager uses to do its work, known as the SQL Distributed Management Objects (SQL-DMO). The authors walk through the object model here and show off common tasks, such as configuring SQL Server 7.0, creating indexes, and doing backups programmatically. There's also good coverage of role-based security through objects, as well as a later section that explores your options for managing replication in your own programs. While SQL-DMO exposes much of the underlying functionality of Enterprise Manager, the SQL Namespace (SQL-NS) objects let you borrow the actual dialog boxes and wizard screens in custom applications.
A final group of objects, the Data Transformation Services (DTS), lets you copy and transform data between one data source and another. The authors look at both the wizard-based DTS tools and the underlying objects for use within your own code.
Besides a tutorial to some of the tasks that can be automated by using SQL-DMF, this volume doubles as a reference, listing over 60 objects and 1,000 methods. This surprisingly useful and accessible title can get you started thinking on how to simplify database administration in custom programs by using these powerful SQL Server APIs, both in stand-alone applications and ASP-based Web pages. --Richard Dragan
Topics covered: Introduction to SQL Server 7.0 administration with SQL Distributed Management Framework (SQL-DMF), overview of Windows Distributed interNet Applications Architecture (DNA), SQL Distributed Management Objects (SQL-DMO), starting, stopping and configuring servers; querying database and table information, building indexes, role-based security and user management, backup and restore with SQL-DMO, scheduling jobs with the SQL Agent, SQL Namespace (SQL-NS) objects for accessing Enterprise Manager dialog boxes and wizards, deploying SQL-DMF applications, replication management, Data Transformation Services (DTS): wizards, tools, and programmatic access; installing and using the Microsoft Data Engine (MSDE), tutorial for using SQL-DMO with Visual C++, complete SQL-DMF object and method reference.
Customer Reviews
Average Rating:
Rating: - ALL I needed to know about DMO
I had to write some programs for work that involved getting into the DMO objects of SQL Server, and this book was simply invaluable to me in understanding the objects better and helping me to produce a program that I am really proud of.
I have not checked out the other sections of this book, however the books from this lot (wrox) tend to be very good, with useful, real-life examples and detailed explanations. I also used a similar book from them to learn ASP.
Rating: - Good book. Does just what it says it does.
I was discouraged from getting this book for a while because of the other reviews on this page, but when I really needed an additional reference for SQL-DMO, I went ahead for whatever I could get from the book. I have read through the portion of the book (The chapters, not the appendices - they are more for reference). First, the book is not just a rehash of the SQL SBO, nor of the reference on MSDN. It was my frustration with searching through them, getting explanations that did not always offer ... Read More
Rating: - Crash course in SQL DMO SQL NS
I found this book to be a big help in creating SQL DMO applications. I got some ideas for incorporating server and application roles via DMO, automating free log space counting and archiving via detach and attach, a way to limit extending the server's context for xp_cmdshell and ways to produce lists for users that are absent from EM (it may be simple, but there *is* no list of triggers for example, and the DMO EnumXXXX methods are a lot easier to deal with than ado's moreresults, when queries return ... Read More
Rating: - Professional SQL Server SQL-DMO, SQL-NS and DTS
This is an absolute rehash of the SQL Server Books Online, the samples are too. It is very light on DMO, SQL Namespace Objects and DTS. It is all very basic, does not explain the main concepts of SQL-DMO, does not explain the meta data cache for example. The biggest part of the book are the Appendix which are object models and rehashes of Microsoft matrials.
Rating: - Very VB oriented -- Pretty light on DTS
I bought this book to assist me with a project that required moving and manipulating data between heterogeneous data sources. DTS seemed to be the right tool to do this and that proved to be true in the end.
However, this book was not a great assistance. The authors fill the book with various VB examples, which would be great, if I was augmenting my DTS packages with VB - but I wasn't. Rather, what would have been of great, are examples of raising errors, handling non-tabular input and output, ... Read More
- ALL I needed to know about DMO
- Good book. Does just what it says it does.
- Professional SQL Server SQL-DMO, SQL-NS and DTS
- Very VB oriented -- Pretty light on DTS
