Microsoft SQL Server 2014 Unleashed

This is an in-depth informational book about SQL Server, based upon the real-world experience of the authors - a book of applied technology.

Emphasis is placed 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.Microsoft SQL Server 2014 Unleashed is presented in a format that is suitable for those who are already familiar with prior versions of SQL Server.

At the beginning of each chapter is a brief summary of the major changes or new features or capabilities of SQL Server related to that topic.

If you are already familiar with SQL Server, you can use this section to focus on the information in the chapters that covers the new features and capabilities in more detail.The book provides a behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools.

You'll learn what the underlying SQL commands are, to allow them to fully unlock the power and capabilities of SQL Server.

All SQL code examples, sample databases, and application code are included with the book to enable you to rapidly learn from live examples and create viable solutions from these samples themselves.Specific to this edition:SQL Server 2014 has advanced to new levels of capabilities that include further enhancements to high availability, cloud options via Azure, and further performance enhancements provided via major database engine features such as memory optimized tables, Buffer Pool Extension and delayed durability.

The updates and changes from the 2012 version reflect expanded capabilities in the most critical areas of the product (High Availability, BI/DW, Integration, Performance, Master Data services, Data Quality services, and DB Administration).