29
Digicomp Microsoft Evolution Day 2015 1 What's new in SQL Server 2016? Dieter Rüetschi Partner:

What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

  • Upload
    others

  • View
    4

  • Download
    0

Embed Size (px)

Citation preview

Page 1: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

Digicomp Microsoft Evolution Day 2015 1

What's new in SQL Server 2016?

Dieter Rüetschi

Partner:

Page 2: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

3Digicomp Microsoft Evolution Day 2015

Vorstellung Referent

Ability Solutions

Kurse

Coachings

Projekte

25 Jahre Softwareentwicklung, Softwarearchitekt, ALM Manager

18 Jahre Kursleitungen und Fachbereichsleitung in der Digicomp

Seit 2001 auf der .NET Plattform mit SQL Server und Oracle

SQL Server seit 1990

Und ein paar Dinge mehr

Page 3: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

4Digicomp Microsoft Evolution Day 2015

Die Datenplattform von Microsoft 1/2

Page 4: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

5Digicomp Microsoft Evolution Day 2015

Die Datenplattform von Microsoft 2/2

Page 5: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

6Digicomp Microsoft Evolution Day 2015

Performance Tool

Page 6: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

7Digicomp Microsoft Evolution Day 2015

Always Encrypted

End to End Verschlüsselung von Columns

Applikationstransparenz

Clientseitige Ver- und Entschlüsselung

Weder Schlüssel noch Daten erscheinen klar auf dem Server

Page 7: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

8Digicomp Microsoft Evolution Day 2015

Always Encrypted

Page 8: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

9Digicomp Microsoft Evolution Day 2015

Die Definition von Always Encrypted Columns

Page 9: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

10Digicomp Microsoft Evolution Day 2015

Der Wizzard für Always Encrypted

Page 10: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

11Digicomp Microsoft Evolution Day 2015

Polybase

Page 11: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

12Digicomp Microsoft Evolution Day 2015

Built In Advanced Analysis

Page 12: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

13Digicomp Microsoft Evolution Day 2015

Stretch DB – verteilte DB in On Premise <-> Azure

Page 13: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

14Digicomp Microsoft Evolution Day 2015

Wie einstellen?

Page 14: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

15Digicomp Microsoft Evolution Day 2015

Azure Data Warehouse

Page 15: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

16Digicomp Microsoft Evolution Day 2015

Über Azure Portal

Page 16: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

17Digicomp Microsoft Evolution Day 2015

Machine Learning

Page 17: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

18Digicomp Microsoft Evolution Day 2015

In-Memory OLTP

Page 18: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

19Digicomp Microsoft Evolution Day 2015

Schlechte Performance

Page 19: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

20Digicomp Microsoft Evolution Day 2015

Query Store

Page 20: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

21Digicomp Microsoft Evolution Day 2015

Query Store so funktionierts

Page 21: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

22Digicomp Microsoft Evolution Day 2015

Performance Optimierungsprozess mit Query Store

Page 22: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

23Digicomp Microsoft Evolution Day 2015

Infos über Standard Views

Page 23: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

24Digicomp Microsoft Evolution Day 2015

Aktivieren

Page 24: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

25Digicomp Microsoft Evolution Day 2015

Temporal Tables

Page 25: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

26Digicomp Microsoft Evolution Day 2015

Umgang mit der Temporal DB

Page 26: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

27Digicomp Microsoft Evolution Day 2015

Besteht aus zwei Tabellen

Page 27: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

28Digicomp Microsoft Evolution Day 2015

Für bestehende Tabellen

Page 28: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

29Digicomp Microsoft Evolution Day 2015

F&A

Page 29: What's new in SQL Server 2016? Dieter Rüetschidigiblog.s3-eu-central-1.amazonaws.com/app/1446644383/32...Die Definition von Always Encrypted Columns Digicomp Microsoft Evolution Day

30Digicomp Microsoft Evolution Day 2015

Weiterführende Kurse

SQL Server 2016 What’s new? («SQLWN»)https://www.digicomp.ch/weiterbildung/it-professionals/microsoft/microsoft-sql-server/sql-server-2016-whats-new