Synopses & Reviews
SQL-DMO is a feature rich library that developers can manipulate to get into those hard-to-reach corners that simply are inaccessible using Microsoft SQL Server's standard GUI tools such as Enterprise Manager. The SQL-DMO library allows DBAs and SQL Server application developers to manage replication and security scenarios, for example, with the kind of fine-tuning they just don't get with GUI tools. Allan Mitchell and Mark Allison explain how to do this in a straightforward, concise manner that simply explains the points necessary to help DBAs and SQL programmers advance to the next level of application development. AReal-World SQL-DMO for SQL ServerA shows developers how to administer Microsoft SQL Server using the SQL-DMO object library. This book is packed with code and explanations on how to use the library to its full potential, and Allan Mitchell and Mark Allison offer advice about when--and even when not--to use the SQL-DMO application programming interface (API). With SQL-DMO, you can take a piece of Enterprise Manager and build an application around it. For example, in Chapter 2, the authors build an application to back up and restore a database. Also included is a freeware SQL utility, QALite. AReal-World SQL-DMO for SQL ServerA will take developers and DBAs alike to another level in administering their SQL Server environments. The toolset that's provided with SQL Server becomes cumbersome when dealing with more than 10 servers and next to impossible when dealing with more than 30 servers. This book uses code tried and tested by the authors at sites where DBAs routinely manage more than 50 SQL Servers. Allan Mitchell and Mark Allison are longtime DBAs and cofounders of the successful UK-based consultancy Allison Mitchell (www.allisonmitchell.com). They are regular contributors at SQL Server user group meetings and were both recently honored as Microsoft SQL Server MVPs.
Synopsis
SQL-DMO is a feature rich library that can be manipulated to do things that simply are not possible using the standard toolset of Microsoft SQL Server, and Mitchell and Allison show developers how to do it in a way that is not masked by techno-babble. Instead, they write in a manner that is easy to understand and clearly explains the points necessary to advance in programming SQL Server.
Synopsis
Includes bibliographical references (p. 371-376) and index.
Synopsis
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.