Develop the skill you need in the real world. Hit the ground running with the street-smart training you'll find in this practical book. Using a "Year in the life" approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including: * Installing and configuring SQL Server * High availability and disaster recovery * Maintenance and automation * Monitoring and troubleshooting An Invaluable study tool This no-nonsense book also maps to the common tasks and objectives for Microsoft's MCTS SQL Server (TM) 2005 Implementation and Maintenance exam (70-431). So whether you're preparing for certification or seeking practical skills to break into the field, you'll find the instruction you need, including: * Upgrading from a previous version of SQL Server * Configuring an operating mode * Restoring a database * Creating a Transact-SQL user-defined type * Using Windows(r) System Monitor to Monitor performance THE STREET SMARTS SERIES is designed to help current or sparing IT professionals put their certification to work for them. Full of practical, real world scenarios, each book features actual tasks from the field and then offers step-by-step exercises that teach the skills necessary to complete those tasks. And because the exercises are based upon exam objectives from leading technology certifications, each Street Smarts book can be used as a lab manual for certification prep.

SQL Server 2005 DBA Street Smarts

Computers & Technology

Jorden, Joseph L.

Certification

Sybex

<ul>
<li>Reporting Services is a powerful tool for SQL Server 2005 database administrators, developers, and other IT professionals, enabling them to make sense of the immense amount of data generated by enterprises of all sizes</li> <li>Shows readers how to create, manage, and distribute information as well as how to design, produce, and distribute reports that meet the needs of the stakeholder</li> <li>Contains practical insights and real-world solutions not found in other books</li> <li>Bridges the gap between those who manage data and those who need it</li> </ul>

Mastering SQL Server 2005 Reporting Services Infrastructure Design

Programming Languages

Complete. Authoritative. Practical. The only SQL Server book you need. Mastering SQL Server 2000 is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced. Coverage includes: <ul>
<li>Understanding SQL Server architecture</li> <li>Designing an efficient normalized database</li> <li>Writing Transact-SQL statements and batches</li> <li>Creating databases</li> <li>Creating tables and views</li> <li>Creating stored procedures and triggers</li> <li>Administering SQL Server</li> <li>Managing SQL Server security</li> <li>Designing applications using ADO, SQL-DMO, and SQL-NS</li> <li>Using Data Transformation Services</li> <li>Integrating SQL Server with the Internet</li> <li>Optimizing SQL Server performance</li> <li>Understanding and managing replication</li> <li>Using Analysis Services to analyze data</li> <li>Using Microsoft English Query</li> <li>Troubleshooting common problems</li> </ul>

Mastering SQLServer 2000

Study guide for the MCSE SQL Server 2000 Administration exam, number 70-228. Includes full coverage of every exam objective and numerous challenging review questions. The CD-ROM also contains review questions, a testing engine, electronic flashcards, and other aids. System requirements not listed. Also includes a companion Web site.

McSe SQL Server 2000 Administration: Study Guide

et.al.

Sawtell, Rick

Mortensen, Lance

Jorden, Joseph

Programming

Sybex, Inc.

Here's the book you need to prepare for Exam 70-228, Installing, Configuring, and Administering Microsoft SQL Server 2000. This Study Guide provides: 
<ul>
<li>In-depth coverage of every official exam objective</li> <li>Practical information on installing, configuring, and administering SQL Server 2000</li> <li>Real-world insights, advice, and recommendations</li> <li>Hundreds of challenging practice questions, in the book and on the CD</li> <li>Leading-edge exam preparation software, including a test engine and electronic flashcards</li> </ul>
Authoritative coverage of all exam objectives, including: <ul>
<li>Installing and configuring SQL Server 2000</li> <li>Creating SQL Server 2000 databases</li> <li>Managing, monitoring, and troubleshooting SQL Server 2000 databases</li> <li>Extracting and transforming data with SQL Server 2000</li> <li>Managing and monitoring SQL Server 2000 security</li> <li>Managing, monitoring, and troubleshooting SQL Server 2000</li> </ul>
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide, 2nd Edition (70-228)