FreeOZ论坛

标题: 想做SQL SERVER 2005 DBA [打印本页]

作者: nowaybutgo 时间: 11-8-2010 01:54
标题: 想做SQL SERVER 2005 DBA
本人仅仅熟练写T-SQL，想MS SQL SERVER DBA，管理方面也精通，各位前辈有无好的，通俗的中文书推荐？

不希望‘砖头书’，看到哪一年去啊？

请讲明作者，书名，出版社。

假如有电子书，请说说下载地址吧？

作者: wukong 时间: 11-8-2010 13:53
没有中文的，而且我觉得好的中文书应该是翻译英文原版的，我提供个英文的电子书，有兴趣你就翻翻。

另外个人觉得
MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft SQL Server 2005 Database Administrator Core Requirements
还不错，可以有选择的看看相关章节，应该有中文的，你找找

作者: wukong 时间: 11-8-2010 13:54
About The Book
Your all-in-one kit for the required MCITP Database Administrator exams.
EXAM PREP GUIDES
Ace your preparation for the skills measured by three core MCITP exams—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises.

PRACTICE TESTS
Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.

Maximize your exam performance with preparation for:

EXAM 70-431
Microsoft SQL Server 2005—Implementation and Maintenance

Install and configure SQL Server

Set up tables, indexes, columns, and constraints

Use Transact-SQL to implement functions, stored procedures, and triggers

Work with relational and XML data

Monitor, troubleshoot, and tune queries

Maintain database availability with log shipping, mirroring, and replication

Prepare a backup strategy and restore a database

EXAM 70-443
Designing a Database Server Infrastructure Using Microsoft SQL Server 2005

Install, consolidate, and configure multiple database instances

Design tables, file groups, and indexes for a physical database

Develop and implement security policies at the server, database, and object levels

Design, implement, and configure clustering, log shipping, mirroring, and replication

Develop plans for data archiving, backups, and disaster recovery

EXAM 70-444
Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005

Monitor and troubleshoot queries, databases, and servers

Manage security strategies and perform audits

Help defend against attacks, worms, and viruses

Detect and resolve data conflicts

Diagnose faults and recover from database failures and disasters

Optimize availability with failover clustering, mirroring, log shipping, and replication

Customize maintenance and automate routine tasks

Build, debug, and deploy SQL Server Integration Services packages

作者: nowaybutgo 时间: 11-8-2010 16:59
谢谢！

作者: Hush 时间: 16-8-2010 22:37
强烈推荐我原来的tech lead，写的这本书
http://www.china-pub.com/196340

作者: wukong 时间: 17-8-2010 14:24

原帖由 Hush 于 2010-8-16 21:37 发表

 登录/注册后可看大图

强烈推荐我原来的tech lead，写的这本书
http://www.china-pub.com/196340

看着介绍，不错，有没电子版先试看一下

作者: nowaybutgo 时间: 19-8-2010 00:10
作者是女人啊，不容易！

作者: Fernando 时间: 19-8-2010 00:28
我手里有本SQL Server 2000 宝典，LZ要看可以奉送

作者: aaaaatoz 时间: 2-9-2010 22:42
实际上DBA这个工作不容易做，特别是tuning，太需要实战经验了。

作者: xincheng 时间: 30-1-2011 20:18
呵呵，想做DBA的人真多，尤其是在国内，是出于兴趣还是别的原因呢，有时候我很好奇的想问问。

作者: 李大锤 时间: 31-1-2011 13:30
DBA和钱途有关。。。

你懂的。。

作者: wanglei 时间: 3-2-2011 19:59

欢迎光临 FreeOZ论坛 (https://www.freeoz.org/forum/)