book

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud

Name: Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud
ISBN: 9781509301959

by Stacia Varga, Denny Cherry, Joseph D’Antoni

June 2016

Intermediate to advanced

214 pages

7h 29m

English

Microsoft Press

Read now

Unlock full access

Cover
Title Page
Copyright Page
Contents
Introduction
Who should read this bookAssumptionsThis book might not be for you if...Organization of this bookConventions and features in this bookSystem requirementsPrerelease softwareAcknowledgmentsErrata, updates, & book supportFree ebooks from Microsoft PressWe want to hear from youStay in touch
Chapter 1. Faster queries
In-Memory OLTP enhancementsReviewing new features for memory-optimized tablesScaling memory-optimized tablesIntroducing native client enhancementsExploring T-SQL enhancementsManaging memory-optimized tablesPlanning data migration to memory-optimized tablesIn-memory analyticsReviewing columnstore index enhancementsGetting started with in-memory analyticsUsing filtered columnstore indexesAnalysis Services enhancementsUnderstanding multidimensional performance improvementsUnderstanding tabular performance improvements
Chapter 2. Better security
Always EncryptedGetting started with Always EncryptedCreating a table with encrypted valuesCREATE TABLE statement for encrypted columnsMigrating existing tables to Always EncryptedRow-Level SecurityCreating inline table functionsCreating security policiesUsing block predicatesDynamic data maskingDynamic data masking of a new tableDynamic data masking of an existing tableUnderstanding dynamic data masking and permissionsMasking encrypted valuesUsing dynamic data masking in SQL Database
Chapter 3. Higher availability
AlwaysOn Availability GroupsSupporting disaster recovery with basic availability groupsUsing group Managed Service AccountsTriggering failover at the database levelSupporting distributed transactionsScaling out read workloadsDefining automatic failover targetsReviewing the improved log transport performanceWindows Server 2016 Technical Preview high-availability enhancementsCreating workgroup clustersConfiguring a cloud witnessUsing Storage Spaces DirectIntroducing site-aware failover clustersWindows Server Failover Cluster loggingPerforming rolling cluster operating system upgrades
Chapter 4. Improved database engine
TempDB enhancementsConfiguring data files for TempDBEliminating specific trace flagsQuery StoreEnabling Query StoreUnderstanding Query Store componentsReviewing information in the query storeUsing Force PlanManaging the query storeTuning with the query storeStretch DatabaseUnderstanding Stretch Database architectureSecurity and Stretch DatabaseIdentifying tables for Stretch DatabaseConfiguring Stretch DatabaseMonitoring Stretch DatabaseBackup and recovery with Stretch Database
Chapter 5. Broader data access
Temporal dataCreating a rowstore temporal tableConverting an existing table to temporalUnderstanding the effect of data changesUsing memory-optimized temporal tablesQuerying temporal tablesSecuring temporal tablesManaging data retentionReviewing temporal metadataJSONGetting acquainted with JSON structuresExporting data to JSONImporting JSON dataConverting JSON data to a table structureUsing other built-in JSON functionsIndexing JSON dataPolyBaseInstalling PolyBaseScaling out with PolyBaseCreating PolyBase data objectsViewing PolyBase objects in SSMSUsing T-SQL with PolyBase objectsTroubleshooting with PolyBase system views and DMVs

Chapter 6. More analytics
Tabular enhancementsAccessing more data sources with DirectQueryModeling with a DirectQuery sourceWorking with calculated tablesBidirectional cross-filteringWriting formulasIntroducing new DAX functionsUsing variables in DAXR integrationInstalling and configuring R ServicesGetting started with R ServicesUsing an R Model in SQL Server
Chapter 7. Better reporting
Report content typesPaginated report development enhancementsIntroducing changes to paginated report authoring toolsExploring new data visualizationsManaging parameter layout in paginated reportsMobile report developmentIntroducing the mobile report designerConnecting data to mobile report elementsReviewing mobile report elementsPublishing mobile reportsKPI developmentReport access enhancementsAccessing reports with modern browsersViewing reports on mobile devicesPrinting without ActiveXExporting to PowerPointPinning reports to Power BIManaging subscriptions
Chapter 8. Improved Azure SQL Database
Introduction to SQL DatabaseReviewing the evolution of SQL DatabaseUnderstanding the pricing modelProtecting data with high availability and disaster recoverySQL Database securityConfiguring securityAuditing SQL DatabaseEncrypting dataSecuring data at the row levelDynamic data maskingDeveloping secure applicationsElastic database featuresManaging elastic scaleManaging performance levels in elastic database poolsUsing elastic database jobsDistributing queries with elastic query
Chapter 9. Introducing Azure SQL Data Warehouse
Introduction to SQL Data WarehouseSecurityScalabilityScaling storage and compute resourcesDeciding how to scaleData loadsUsing Azure Data FactoryUsing PolyBaseUsing SSISStatistics for SQL Data WarehouseCreating statisticsMaintaining statisticsIntegration optionsPredictive modeling in Azure Machine LearningWorking with streaming data in Azure Stream AnalyticsAnalyzing data by using Power BI
About the authors
Visit us today at
Hear about it first
Survey
Free ebooks
Code Snippets

Overview

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 ebook, we introduce new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TemDB configuration, query store, and Stretch Database; review several improvements to Reporting Services; and also describe AlwaysOn Availability Groups, tabular enhancements, and R integration.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781509301959

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills