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

The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer.

Knowledge and ability to apply XML are de rigueur in today’s world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server’s built–in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database...

The process of disaster recovery involves mitigating the likelihood of a disaster and returning the system to a normal state. This book shows you how to implement an effective disaster recovery strategy for SQL Server 2005 databases. With the arrival of SQL Server 2005, you have access to enhanced existing features and powerful new tools, like database snapshots and mirroring, for data backup and disaster recovery. The book also covers fundamental changes to disaster recovery capabilities, an...

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