Real-World SQL-DMO for SQL Server

Allan Mitchell, Mark Allison

Real-World SQL-DMO for SQL Server
  • 出版商: Apress
  • 出版日期: 2002-10-16
  • 定價: $1,650
  • 售價: 1.8 折 $299
  • 語言: 英文
  • 頁數: 397
  • 裝訂: Paperback
  • ISBN: 1590590406
  • ISBN-13: 9781590590409
  • 相關分類: MSSQL、SQL

    • 立即出貨(限量) (庫存=1)

買這商品的人也買了...

商品描述

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

Chapter 1: Getting Started with SQL-DMO
Chapter 2: Backup and Restore: A DBA’s Bread and Butter
Chapter 3: Managing Users of Your Database and Server
Chapter 4: Using SQL-DMO with OLE Automation
Chapter 5: Jobs, Alerts, and Operators
Chapter 6: Viewing and Setting Server-wide Options
Chapter 7: Replication and SQL-DMO
Chapter 8: QALite
Chapter 9: 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

商品描述(中文翻譯)

SQL-DMO是一個功能豐富的庫，開發人員可以使用它來操作那些使用Microsoft SQL Server標準GUI工具（如Enterprise Manager）無法訪問的困難區域。SQL-DMO庫允許數據庫管理員和SQL Server應用程序開發人員以細微調整的方式來管理複製和安全性方案，這是GUI工具所無法提供的。Allan Mitchell和Mark Allison以簡潔明了的方式解釋了如何做到這一點，以幫助數據庫管理員和SQL程序員提升應用程序開發的水平。

《Real-World SQL-DMO for SQL Server》向開發人員展示如何使用SQL-DMO對Microsoft SQL Server進行管理。這本書充滿了代碼和解釋，介紹了如何充分利用該庫，Allan Mitchell和Mark Allison還提供了關於何時以及何時不應使用SQL-DMO應用程序編程接口（API）的建議。使用SQL-DMO，您可以使用Enterprise Manager的一部分來構建應用程序。例如，在第2章中，作者們構建了一個用於備份和還原數據庫的應用程序。還包括一個免費的SQL實用程序QALite。

《Real-World SQL-DMO for SQL Server》將幫助開發人員和數據庫管理員在管理SQL Server環境方面提升到另一個水平。當處理超過10個服務器時，SQL Server提供的工具集變得繁瑣，而處理超過30個服務器幾乎是不可能的。本書使用的代碼是作者在管理超過50個SQL Server的網站上經過測試和驗證的。

《內容》
第1章：開始使用SQL-DMO
第2章：備份和還原：DBA的基本技能
第3章：管理數據庫和服務器的用戶
第4章：使用SQL-DMO與OLE Automation
第5章：作業、警報和操作員
第6章：查看和設置服務器級選項
第7章：複製和SQL-DMO
第8章：QALite
第9章：使用SQL-DMO對整個服務器進行腳本編寫
附錄A：SQL-DMO對象庫快速參考
附錄B：知識庫文章和其他SQL-DMO資源

類似商品