With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this Preview 2 ebook, we introduce three new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TempDB configuration, query store, and Stretch Database; review several improvements to Reporting Services; and also describe AlwaysOn Availability Groups, tabular enhancement, and R integration. This book is a preview edition because it s not complete; the final edition will be available Spring of 2016."
Author(s): Stacia Varga; Denny Cherry; Joseph D'Antoni
Edition: Preview Edition
Publisher: Microsoft Press
Year: 2016
Language: English
Pages: 65
Cover
Title page
Contents at a glance
Contents
Chapter 2: Better security
Always Encrypted
Getting started with Always Encrypted
Creating a table with encrypted values
CREATE TABLE statement for encrypted columns
Migrating existing tables to Always Encrypted
Row-Level Security
Creating inline table functions
Application using one login per user
Application using one login for all users
Creating security policies
Using block predicates
Dynamic data masking
Dynamic data masking of a new table
Dynamic data masking of an existing table
Understanding dynamic data masking and permissions
Masking encrypted values
Using dynamic data masking in SQL Database
Chapter 3: Higher availability
AlwaysOn Availability Groups
Supporting disaster recovery with basic availability groups
Using group Managed Service Accounts
Triggering failover at the database level
Supporting distributed transactions
Scaling out read workloads
Defining automatic failover targets
Reviewing the improved log transport performance
Windows Server 2016 Technical Preview high-availability enhancements
Creating workgroup clusters
Configuring a cloud witness
Using Storage Spaces Direct
Introducing site-aware failover clusters
Windows Server Failover Cluster logging
Performing rolling cluster operating system upgrades
Chapter 4: Improved database engine
TempDB enhancements
Configuring data files for TempDB
Eliminating specific trace flags
Trace flag 1117
Trace flag 1118
Query Store
Enabling Query Store
Understanding Query Store components
Reviewing information in the query store
Using Force Plan
Managing the query store
Tuning with the query store
Stretch Database
Understanding Stretch Database architecture
Security and Stretch Database
Identifying tables for Stretch Database
Configuring Stretch Database
Monitoring Stretch Database
Backup and recovery with Stretch Database
Chapter 6: More analytics
Tabular enhancements
Accessing more data sources with DirectQuery
Modeling with a DirectQuery source
Working with calculated tables
Bidirectional cross-filtering
Writing formulas
Introducing new DAX functions
Using variables in DAX
R integration
Installing and configuring R Services
Server configuration
Client workstation
Getting started with R Services
User permissions
Compute context
Data source
Data exploration
Data transformation
Predictive model creation
Model usage
Model accuracy
Using an R Model in SQL Server
Model deployment
Batch mode invocation of a model
Individual scoring mode invocation of a model
Chapter 7: Better reporting
Report content types
Paginated report development enhancements
Introducing changes to paginated report authoring tools
Report Designer
Report Builder
Exploring new data visualizations
Tree map
Sunburst
Managing parameter layout in paginated reports
Mobile report development
KPI development
Report access enhancements
Accessing reports with modern browsers
Viewing reports on mobile devices
Printing without ActiveX
Exporting to PowerPoint
Pinning reports to Power BI
Managing subscriptions
Subscription description
Subscription owner change
Interface support for changing subscription status
File share credentials
Blank Page
Blank Page
Blank Page
Blank Page
Blank Page
About the authors
Free ebooks
Microsoft Press newsletter
Microsoft Press store
Tell us what you think!
