SQL Server 2016 Developer's Guide
Dejan Sarka Milo? Radivojevi? William Durkin更新时间：2021-07-09 19:06:06
最新章节：Summary封面
版权信息
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface
Chapter 1. Introduction to SQL Server 2016
Security
Engine features
Programming
Business intelligence
Release cycles
Summary
Chapter 2. Review of SQL Server Features for Developers
The mighty Transact-SQL SELECT
DDL DML and programmable objects
Transactions and error handling
Beyond relational
Summary
Chapter 3. SQL Server Tools
Installing and updating SQL Server tools
New SSMS features and enhancements
SQL Server Data Tools
Tools for developing R code
Summary
Chapter 4. Transact-SQL Enhancements
New and enhanced functions and expressions
Enhanced DML and DDL statements
New query hints
Summary
Chapter 5. JSON Support in SQL Server
Why JSON?
What is JSON?
JSON in SQL Server prior to SQL Server 2016
Retrieving SQL Server data in the JSON format
Converting JSON data in a tabular format
JSON storage in SQL Server 2016
Validating JSON data
Extracting values from a JSON text
Modifying JSON data
Performance considerations
Summary
Chapter 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
Chapter 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
Chapter 8. Tightening the Security
SQL Server security basics
Encrypting the data
Row-Level security
Exploring dynamic data masking
Summary
Chapter 9. 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
Query Store use cases
Summary
Chapter 10. Columnstore Indexes
Analytical queries in SQL Server
Columnar storage and batch processing
Nonclustered columnstore indexes
Clustered columnstore indexes
Summary
Chapter 11. Introducing SQL Server In-Memory OLTP
In-Memory OLTP architecture
Creating memory-optimized tables and indexes
Querying and data manipulation
Data durability concerns
Database startup and recovery
Management of in-memory objects
Extended Events
Perfmon counters
Summary
Chapter 12. In-Memory OLTP Improvements in SQL Server 2016
Ch-Ch-Changes
Summary
Chapter 13. Supporting R in SQL Server
Introducing R
Manipulating data
Understanding the data
SQL Server R services
Summary
Chapter 14. Data Exploration and Predictive Modeling with R in SQL Server
Intermediate statistics - associations
Advanced analysis - undirected methods
Advanced analysis - directed methods
Advanced graphing
Summary
更新时间：2021-07-09 19:06:06