This is an in-depth informational book about SQL Server, placing emphasis on the more complex aspects of the product, including using the new tools and features, administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning SQL Server performance. Each chapter begins with a brief summary of the major changes or new features or capabilities of SQL Server related to that topic,...
More Description
This is an in-depth informational book about SQL Server, placing emphasis on the more complex aspects of the product, including using the new tools and features, administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning SQL Server performance. Each chapter begins with a brief summary of the major changes or new features or capabilities of SQL Server related to that topic, then provides a behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. Students will learn what the underlying SQL commands are, to allow them to fully unlock the power and capabilities of SQL Server.