Real-World SQL-DMO for SQL Server / Edition 1

Real-World SQL-DMO for SQL Server / Edition 1

by Allan Mitchell, Mark Allison
     
 

ISBN-10: 1590590406

ISBN-13: 9781590590409

Pub. Date: 10/15/2002

Publisher: Apress

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

Overview

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. 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.

Product Details

ISBN-13:
9781590590409
Publisher:
Apress
Publication date:
10/15/2002
Edition description:
2003
Pages:
432
Product dimensions:
7.52(w) x 9.25(h) x 0.04(d)

Table of Contents

Forewordxi
Forewordxv
About the Authorsxix
About the Technical Reviewerxx
About the Foreword Writersxxi
Acknowledgmentsxxiii
Introductionxxv
Benefits to Programming in SQL-DMOxxv
What This Book Coversxxvi
How This Book Is Organizedxxvi
What You Should Know Before Reading This Bookxxvii
Additional Resourcesxxvii
Chapter 1Getting Started with SQL-DMO1
What Is SQL-DMO and Where Can I Get It?2
Creating a Database on a Server3
Setting Database Options9
Creating Database Objects19
Summary44
Chapter 2Backup and Restore: A DBA's Bread and Butter45
Types of Backup Available46
Sample Backup Scenarios and Methods48
Considerations for Choosing Your Backup Method50
Using Backup Devices53
Performing the Backup56
The 15-Minute Database Checker93
Summary97
Chapter 3Managing Users of Your Database and Server99
Database Terminology100
The Applications114
Summary153
Chapter 4Using SQL-DMO with OLE Automation155
Using OLE156
Summary178
Chapter 5Jobs, Alerts, and Operators179
Defining General Concepts179
Adding an Operator to SQL Server181
Viewing Your Jobs190
Adding a Job214
Creating an Alert242
Summary246
Chapter 6Viewing and Setting Server-wide Options247
Viewing Server Options248
Extracting Enterprise Management Server Properties249
Creating Your Own Enterprise Manager Tabs270
Setting Server-wide Options272
Summary280
Chapter 7Replication and SQL-DMO281
Types of Replication281
Installing Merge Replication Using SQL-DMO284
Installing Merge Replication Using Enterprise Manager288
Generating Replication Scripts Using SQL-DMO306
Scripting Replication Using SQL-DMO308
Summary308
Chapter 8QALite309
The QALite Application309
Summary321
Chapter 9Using SQL-DMO to Script an Entire Server323
What Scripter Does325
What Scripter Doesn't Do326
Overview of Scripter's Structure328
Summary344
Appendix ASQL-DMO Object Library Quick Reference345
SQLServers Collection345
Databases Collection347
DatabaseRoles Collection348
FileGroups Collection349
DBFiles Collection350
FullTextCatalogs Collection351
StoredProcedures Collection351
Tables Collection352
Columns Collection354
Users Collection355
Views Collection356
Triggers Collection357
Jobs Collection358
JobSchedules Collection359
JobSteps Collection360
Operators Collection361
Logins Collection361
Replication Object365
The SQL-DMO Object Model367
Appendix BKnowledge-Base Articles and Other SQL-DMO Resources371
Bugs371
Fixes373
Problems374
Information and How-To's374
Useful URLs375
Index377

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >