The philosophy behind black books is to conduct extensive research before writing and editing by experienced professionals to provide a plethora of useful tips for transcending global programming and administrative challenges. The Black Book's unique format helps to complete specific tasks, especially critical ones, solve problems, and quickly master complex technical issues to become an expert.
The “SQL Server 2005 Black Book” written by Patric Dalton & Paul Whitehead and published by Dreamtech Press has been presented as support package and insightful reference for utilizing the full power and flexibility of SQL Server 2005. The book caters to the requirements of both - the intermediate and advanced database administrators and programmers. It helps to leverage full potential of relational database technology to create a state-of-art database solution with reporting services. While the comprehensive references help developers and administrators learn SQL Server 2005 quickly and easily.
Title - SQL Server 2005 Black Book Author - Patric Dalton, Paul Whitehead & Kogent Solutions Inc. Publisher - Dreamtech Press
This book's format of breaking down complex topics into easily manageable components helps in quickly finding what one is looking for. Each chapter has been divided into two sections; The 'In Depth' section, written in the standard textbook format, presents explanatory material and covers the chapter topics inside out, while the 'Immediate Solution' section provides step-by-step instructions for performing specific tasks & quick solutions to a large number of commonly occurring problems. In addition, the book is filled with hundreds of ready-to-use examples covering the entire SQL Server 2005 programming area. These example are precise and to the point.
The book covers the entire spectrum of Structured Query Language from syntax to Common Language Runtime (CLR), to a detailed overview of SQL server tools, from Management Studio to Business Intelligence Development Studio (BIDS), Database Design, SQL Server Mobile Edition, Data Warehouse & Reporting Services, development chapters are provided on Server Maintenance, Security, Integrating .NET with SQL Server, performance tuning and optimization, error handling, and using SQL with XML.
SQL Server 2005 is an enhancement over its predecessor SQL Server 2000. Many new features have been added to improve the development productivity, transaction processing and security. A host of functional enhancements such as Dedicated Administration Connection (DAC), Deadlock Virtualisation and SQL Server Agents have made SQL Server more scalable and efficient and an excellent platform for e-governance & e-commerce applications, On-Line transaction Processing (OLTP), and Data Warehousing.
The 2007 Edition of SQL Server 2005 black book addresses all these enhancements and features of SQL in a simple but comprehensive manner. The chapter on .NET integration needs a special mention as it allows the Visual Studio .NET developers to understand the functionality of SQL Server within the IDE (Integrated Development Environment) of Visual Studio 2005. The book is designed to give you exactly what you want, and when you want it