SQL Server 2017 Developer’s Guide

This guide offers insights into SQL Server 2017's features, helping developers create efficient database applications and leverage advanced analytics.

The SQL Server 2017 Developer’s Guide serves as a comprehensive resource for developers looking to harness the full potential of SQL Server 2017. This book begins by introducing the new features of SQL Server 2017, including advanced capabilities in data modeling and the integration of R and Python for enhanced analytics. Readers will learn how to effectively manage complex relationships within their data while also exploring the performance and troubleshooting aspects necessary for developing efficient database applications.

As the book progresses, it delves into the enhancements of the Transact-SQL language and new database engine capabilities, including support for JSON data. It also covers advanced topics such as Query Store and In-Memory OLTP, ensuring that developers are well-equipped to handle modern database challenges. By integrating R and Python, the SQL Server 2017 Developer’s Guide prepares readers for data exploration and analysis, while also addressing deployment options on various platforms, including Linux.

By the end of the book, readers will have gained the knowledge needed to design high-performance database applications with ease. This guide is particularly beneficial for database developers, solution architects, and business intelligence professionals who wish to leverage SQL Server 2017's capabilities for building smarter, more efficient database systems in their organizations.