- SQL Server 2016 Developer's Guide
- SQL Server 2016 Developer's Guide
- Credits
- About the Authors
- About the Reviewer
- www.PacktPub.com
- Customer Feedback
- Preface
- 1. Introduction to SQL Server 2016
- 2. Review of SQL Server Features for Developers
- 3. SQL Server Tools
- 4. Transact-SQL Enhancements
- 5. JSON Support in SQL Server
- 6. Stretch Database
- Stretch Database 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
- 7. Temporal Tables
- What is temporal data?
- System-versioned tables in SQL Server 2016
- History table physical implementation
- What is missing in SQL Server 2016?
- Summary
- 8. Tightening the Security
- 9. Query Store
- 10. Columnstore Indexes
- 11. Introducing SQL Server In-Memory OLTP
- 12. In-Memory OLTP Improvements in SQL Server 2016
- 13. Supporting R in SQL Server
- 14. Data Exploration and Predictive Modeling with R in SQL Server
In this chapter, you got a review of the SQL Server features for developers that exist in the previous versions. You can see that this support goes well beyond basic SQL statements, and also beyond pure Transact-SQL.
The recapitulation in this chapter is also useful as an introduction to the new features in SQL Server 2016 covered in Chapter 4, Transact-SQL Enhancements, Chapter 5, JSON Support in SQL Server, Chapter 7, Temporal Tables, and Chapter 13, Supporting R in SQL Server.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.