SQL Server 2017 Developer’s Guide

Build smarter and efficient database application systems for your organization with SQL Server 2017 Microsoft SQL Server 2017 is a milestone in Microsoft's data platform timeline, as it integrates the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. This book starts with a quick introduction to the new features of SQL Server 2017 to help you get up and running with its latest features. You’ll be introduced to the enhancements in Transact-SQL and new database engine capabilities before advancing to JSON support. This guide will also take you through security improvements and enable you to work efficiently with temporal tables. You’ll then delve into advanced topics such as Query Store, columnstore indexes, and In-Memory OLTP. Toward the end of the book, you'll delve into R and discover how to use the R language with Transact-SQL for data exploration and analysis. You'll also learn how to integrate Python code into SQL Server, understand graph database implementations, and explore the flexibility of containers for development and testing. By the end of this book, you’ll have learned how to design efficient high-performance database applications with SQL 2017 easily. Database developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book useful. Also, if you’re an advanced analysis practitioner, business intelligence developer, or a database consultant dealing with performance tuning, this book is for you. Basic understanding of database concepts and T-SQL will assist with understanding key concepts covered in this book.