SQL Server 2016 Developer's Guide

This guide provides a thorough introduction to the features of SQL Server 2016, helping developers create efficient database applications.

The SQL Server 2016 Developer's Guide serves as an extensive resource for developers looking to harness the new capabilities of SQL Server 2016. This book emphasizes the enhancements in Transact-SQL and security features that allow for the creation of efficient database applications. With a focus on temporal tables, readers will learn how to retrieve historical data effectively, gaining insights into the data stored at any given moment. The guide not only covers new features but also revisits familiar concepts, ensuring a smooth transition for those upgrading from previous SQL Server versions.

In addition to covering the basics, the SQL Server 2016 Developer's Guide delves into advanced topics such as In-Memory OLTP technology, columnstore indexes, and the integration of R with SQL Server. These features are designed to improve performance and scalability, making it easier for developers to build robust applications. The book also highlights the importance of security enhancements, providing strategies for encrypting data and controlling access at a granular level.

By the end of this comprehensive guide, developers will be equipped with the knowledge necessary to design high-performance database applications. The practical, learn-as-you-do approach ensures that readers can apply concepts directly to their work, making the SQL Server 2016 Developer's Guide an invaluable tool for both novice and experienced developers alike.