Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference....

Microsoft SQL Server 2005 Management and Administration, based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators—from simple tips to tactical solutions. M...

Get complete coverage of all three Microsoft Certified IT Professional database administration exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.

Pro SQL Server 2005 Integration Services contains everything you could ever hope to know about this exciting new development from Microsoft: developer insight, Microsoft group manager--level access, personal experience of using the technology in the real-world, and fine-grained analysis. If you want to rapidly gain...

Maintaining SQL Server 2005 high availability in a global information environment is the database administrator's greatest practical challenge. Availability is as much about people and processes as it is about technology. Pro SQL Server 2005 High Availability covers the technology, people, processes, and real-world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances.

With years of experience as a database consultant and p...

SQL Server is the perfect product for the How to Cheat series. It is an ambitious product that, for the average SysAdmin, will present a difficult migration path from earlier versions and a vexing number of new features. How to Cheat promises help in order to get SQL Server secured as quickly and safely as possible.

Today's DBAs need to know how to work with users, management, and key stakeholders to identify organizational needs and leverage the technology to meet them. Covering intermediate to advanced subjects, such as performance tuning, this book shows you how to build a reporting infrastructure that can be used in any environment.

Focusing on six key principles simplicity, clarity, generality, automation, and communication...

Pro SQL Server 2005 Service Broker, by Klaus Aschenbrenner, an international expert on Service Broker, explains why Microsoft introduced Service Broker and describes its big advantages over prior message technologies.

Rich with practical examples, this is the most complete and incisive book on this important new technology, an invaluable resource for all serious database and web developers. Focused on best practices, it explains in detail how Service Broker supports and enhances da...

SQL Server Reporting Services 2005 is the latest version of the reporting technology from Microsoft, providing the means to design, author, render, and deploy business reports to users, customers, and employees, via the web or the company intranet. The reporting engine is built in to the SQL Server 2005 database (and provided as a free add-on with SQL Server 2000) and the report manager is integrated with Visual Studio 2003, providing an effective and familiar environment for all SQL Server a...

While building on the skills you already have, Expert SQL Server 2005 Development will help you become an even better developer by focusing on best practices and demonstrating how to design high-performance, maintainable database applications.

This book starts by reintroducing the database as a integral part of the software development ecosystem. You'll learn how to think about SQL Server development as you would any other software development. For example, there's no reason you can...