Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 3 of 212

iv Contents Chapter 2 Better security ...................................................................................................................... 14 Always Encrypted .................................................................................................................................................................. 14 Getting started with Always Encrypted ................................................................................................................... 14 Creating a table with encrypted values ................................................................................................................... 20 CREATE TABLE statement for encrypted columns .............................................................................................. 20 Migrating existing tables to Always Encrypted .................................................................................................... 22 Row-Level Security ............................................................................................................................................................... 24 Creating inline table functions .................................................................................................................................... 25 Creating security policies .............................................................................................................................................. 27 Using block predicates ................................................................................................................................................... 28 Dynamic data masking ....................................................................................................................................................... 29 Dynamic data masking of a new table .................................................................................................................... 29 Dynamic data masking of an existing table .......................................................................................................... 30 Understanding dynamic data masking and permissions ................................................................................. 30 Masking encrypted values ............................................................................................................................................ 32 Using dynamic data masking in SQL Database.................................................................................................... 32 Chapter 3 Higher availability ............................................................................................................... 33 AlwaysOn Availability Groups .......................................................................................................................................... 33 Supporting disaster recovery with basic availability groups........................................................................... 34 Using group Managed Service Accounts ............................................................................................................... 36 Triggering failover at the database level ................................................................................................................ 36 Supporting distributed transactions ......................................................................................................................... 37 Scaling out read workloads .......................................................................................................................................... 38 Defining automatic failover targets .......................................................................................................................... 39 Reviewing the improved log transport performance ........................................................................................ 40 Windows Server 2016 Technical Preview high-availability enhancements .................................................... 41 Creating workgroup clusters ....................................................................................................................................... 42 Configuring a cloud witness ........................................................................................................................................ 43 Using Storage Spaces Direct ....................................................................................................................................... 45 Introducing site-aware failover clusters .................................................................................................................. 46 Windows Server Failover Cluster logging .............................................................................................................. 46 Performing rolling cluster operating system upgrades .................................................................................... 46 Chapter 4 Improved database engine ................................................................................................ 48 TempDB enhancements ..................................................................................................................................................... 48 Configuring data files for TempDB ........................................................................................................................... 49 Eliminating specific trace flags .................................................................................................................................... 50 Query Store ............................................................................................................................................................................. 51 Enabling Query Store...................................................................................................................................................... 51

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016