- In order to run all of the demo code in this book, you will need SQL Server 2017 Developer or Enterprise Edition. In addition, you will extensively use SQL Server Management Studio.
- You will also need the RStudio IDE and/or SQL Server Data Tools with R Tools for Visual Studio plug-in
To get the most out of this book
by William Durkin, Milos Radivojevic, Dejan Sarka
SQL Server 2017 Developer's Guide
- Title Page
- Copyright and Credits
- Dedication
- Packt Upsell
- Contributors
- Preface
- Introduction to SQL Server 2017
- Review of SQL Server Features for Developers
- SQL Server Tools
- Transact-SQL and Database Engine Enhancements
- New and enhanced functions and expressions
- Enhanced DML and DDL statements
- New query hints
- Adaptive query processing in SQL Server 2017
- Summary
- JSON Support in SQL Server
- Stretch Database
- Stretch DB architecture
- Limitations of using Stretch Database
- Use cases for Stretch Database
- Enabling Stretch Database
- Querying stretch databases
- SQL Server Stretch Database pricing
- Stretch DB management and troubleshooting
- Summary
- Temporal Tables
- What is temporal data?
- System-versioned temporal tables in SQL Server 2017
- How temporal tables work in SQL Server 2017
- Creating temporal tables
- Altering temporal tables
- Dropping temporal tables
- Data manipulation in temporal tables
- Querying temporal data in SQL Server 2017
- Performance and storage considerations with temporal tables
- Temporal tables with memory-optimized tables
- What is missing in SQL Server 2017?
- Summary
- Tightening Security
- Query Store
- Why Query Store?
- What is Query Store?
- Query Store architecture
- Enabling and configuring Query Store
- Disabling and cleaning Query Store
- Query Store in action
- Query Store reports in SQL Server Management Studio
- Automatic tuning in SQL Server 2017
- Capturing waits by Query Store in SQL Server 2017
- Query Store use cases
- Summary
- Columnstore Indexes
- Introducing SQL Server In-Memory OLTP
- In-Memory OLTP Improvements in SQL Server 2017
- Supporting R in SQL Server
- Data Exploration and Predictive Modeling with R
- Introducing Python
- Graph Database
- Containers and SQL on Linux
- Other Books You May Enjoy
To get the most out of this book
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.