Real-World SQL-DMO for SQL Server

The expert's voice

Allan Mitchell, Mark Allison

424 pages, parution le 04/11/2002

Ajouter à une liste

Indisponible

Résumé

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.

Real-World SQL-DMO for SQL Server 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.

Real-World SQL-DMO for SQL Server 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.

Contents

Getting Started with SQL-DMO
Backup and Restore: A DBA's Bread and Butter
Managing Users of Your Database and Server
Using SQL-DMO with OLE Automation
Jobs, Alerts, and Operators
Viewing and Setting Server-wide Options
Replication and SQL-DMO
QALite
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

L'auteur - Allan Mitchell

Allan Mitchell - Allan Mitchell is a Microsoft Certified, columnist in SQL Server Professional Magazine and is a regular presenter at SQL Server User Group meetings in the United Kingdom. Allan is currently a DBA lead for a multinational media company in the UK providing support for over 400 databases. In the course of his career, he has primarily worked on Microsoft based solutions using SQL Server from Version 6.5 to Version 2000.

L'auteur - Mark Allison

Mark Allison - Mark Allison is a Microsoft Certified, columnist in SQL Server Professional Magazine and is a regular presenter at SQL Server User Group meetings in the United Kingdom. In the course of his career, he has primarily worked on Microsoft based solutions using SQL Server from Version 6 to Version 2000.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Allan Mitchell, Mark Allison
Parution	04/11/2002
Nb. de pages	424
Format	18,8 x 23,3
Couverture	Broché
Poids	860g
Intérieur	Noir et Blanc
EAN13	9781590590409
ISBN13	978-1-59059-040-9