INTRODUCING MICROSOFT SQL SERVER 2016
CONTENTS CHAPTER 1 FASTER QUERIES IN-MEMORY OLTP ENHANCEMENTS REVIEWING NEW FEATURES FOR MEMORY-OPTIMIZED TABLES SCALING MEMORY-OPTIMIZED TABLES INTRODUCING NATIVE CLIENT ENHANCEMENTS EXPLORING T-SQL ENHANCEMENTS MANAGING MEMORY-OPTIMIZED TABLES PLANNING DATA MIGRATION TO MEMORY-OPTIMIZED TABLES IN-MEMORY ANALYTICS REVIEWING COLUMNSTORE INDEX ENHANCEMENTS GETTING STARTED WITH IN-MEMORY ANALYTICS USING FILTERED COLUMNSTORE INDEXES ANALYSIS SERVICES ENHANCEMENTS UNDERSTANDING MULTIDIMENSIONAL PERFORMANCE IMPROVEMENTS UNDERSTANDING TABULAR PERFORMANCE IMPROVEMENTS 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 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 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 5 BROADER DATA ACCESS TEMPORAL DATA CREATING A ROWSTORE TEMPORAL TABLE CONVERTING AN EXISTING TABLE TO TEMPORAL UNDERSTANDING THE EFFECT OF DATA CHANGES USING MEMORY-OPTIMIZED TEMPORAL TABLES QUERYING TEMPORAL TABLES SECURING TEMPORAL TABLES MANAGING DATA RETENTION REVIEWING TEMPORAL METADATA JSON GETTING ACQUAINTED WITH JSON STRUCTURES EXPORTING DATA TO JSON IMPORTING JSON DATA CONVERTING JSON DATA TO A TABLE STRUCTURE USING OTHER BUILT-IN JSON FUNCTIONS INDEXING JSON DATA POLYBASE INSTALLING POLYBASE SCALING OUT WITH POLYBASE CREATING POLYBASE DATA OBJECTS VIEWING POLYBASE OBJECTS IN SSMS USING T-SQL WITH POLYBASE OBJECTS TROUBLESHOOTING WITH POLYBASE SYSTEM VIEWS AND DMVS 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 GETTING STARTED WITH R SERVICES USING AN R MODEL IN SQL SERVER CHAPTER 7 BETTER REPORTING REPORT CONTENT TYPES PAGINATED REPORT DEVELOPMENT ENHANCEMENTS INTRODUCING CHANGES TO PAGINATED REPORT AUTHORING TOOLS EXPLORING NEW DATA VISUALIZATIONS MANAGING PARAMETER LAYOUT IN PAGINATED REPORTS MOBILE REPORT DEVELOPMENT INTRODUCING THE MOBILE REPORT DESIGNER CONNECTING DATA TO MOBILE REPORT ELEMENTS REVIEWING MOBILE REPORT ELEMENTS PUBLISHING MOBILE REPORTS 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 CHAPTER 8 IMPROVED AZURE SQL DATABASE INTRODUCTION TO SQL DATABASE REVIEWING THE EVOLUTION OF SQL DATABASE UNDERSTANDING THE PRICING MODEL PROTECTING DATA WITH HIGH AVAILABILITY AND DISASTER RECOVERY SQL DATABASE SECURITY CONFIGURING SECURITY AUDITING SQL DATABASE ENCRYPTING DATA SECURING DATA AT THE ROW LEVEL DEVELOPING SECURE APPLICATIONS ELASTIC DATABASE FEATURES MANAGING ELASTIC SCALE MANAGING PERFORMANCE LEVELS IN ELASTIC DATABASE POOLS USING ELASTIC DATABASE JOBS DISTRIBUTING QUERIES WITH ELASTIC QUERY CHAPTER 9 INTRODUCING AZURE SQL DATA WAREHOUSE INTRODUCTION TO SQL DATA WAREHOUSE SECURITY SCALABILITY SCALING STORAGE AND COMPUTE RESOURCES DECIDING HOW TO SCALE DATA LOADS USING AZURE DATA FACTORY USING POLYBASE USING SSIS STATISTICS FOR SQL DATA WAREHOUSE CREATING STATISTICS MAINTAINING STATISTICS INTEGRATION OPTIONS PREDICTIVE MODELING IN AZURE MACHINE LEARNING WORKING WITH STREAMING DATA IN AZURE STREAM ANALYTICS ANALYZING DATA BY USING POWER BI