PASS Austria SQL Server Community SPECIAL: SQL Server 2016

Am Donnerstag, 25. Juni 2015 findet ein SQL Server Community SPECIAL zu SQL Server 2016 ab 14:00 bei bwin.party (Marxergasse 1B, 1030 Wien) statt. Das Programm im Detail:

14:00 Doors opening
14:15 Keynote or few words from the Event Organizer
14:30 First Session by Milos Radivojevic: SQL Server 2016 – What’s New for Developers?
- Temporal Tables in SQL Server 2016
- JSON Support in SQL Server 2016
- In-Memory OLTP from Developer Perspective
- Dynamic Data Masking
- Query Store and Live Query Statistics
16:00 Break
16:30 Second Session by Rick Kutschera: SQL Server 2016 – What’s New for Database Administrators?
- Columnstore Indexes in SQL Server 2016
- In-Memory OLTP from DBAs Perspective
- Polybase
- Row-Level Security and Security Enhancements
- High Availability Enhancements
18:00 End of the program and get together

Abstract:

SQL Server 2016 CTP2 First Impressions
On 27th May Microsoft announced the first public Community Technology Preview (CTP2) for SQL Server 2016. This versions brings a number of new features and a lot of enhancements for existing ones.
In our sessions we'll present and demonstrate new features and enhancements in SQL Server 2016.

What’s New for Developers?
In this session we'll talk about features for developers: JSON support, Temporal Tables, Dynamic Data Masking, Query Store and Live Query Statistics and In-Memory OLTP enhancements from developer perspective.
JSON support in SQL server is one of the most highly ranked requests on the Microsoft connect site (1050 votes) and we'll see how SQL Server supports JSON from language and storage point of view.
With temporal tables a new SQL Server version brings (finally) a database design feature. We'll see which type of temporal tables are supported and how they are implemented. In-Memory OLTP implementation in SQL Server 2014 came with a few very painful limitations that reduce use cases for them. In this version a lot of limitations are eliminated (ALTER TABLE, foreign keys...) and the feature is ready for use!
Query Store is another great feature that can save you time and money by allowing you to choose a good execution plan from past for your query and force it in case that the plan has been changed and you are not happy with new one.
We'll also mention (if time permits) several small features that can make your developer life easier and more productive.

What’s New for DBAs?
Huge and important improvements for columnstore indexes including updateable nonclustered columnstore indexes, columnstore indexes on in-memory tables, and many more new features for operational analytics allow us to optimize existing and implement new scenarios in SQL Server OLTP/OLAP applications.
In SQL Server 2016 CTP2, improvements to In-Memory OLTP enable scaling to larger databases and higher throughput in order to support bigger workloads. In addition, a number of limitations concerning tables and stored procedures have been removed to make it easier to migrate your applications to and leverage the benefits of In-Memory OLTP.
A few very important security enhancements came with this release and we'll demonstrate why and where they can be important: Row-Level Security, Always Encrypted, Dynamic Data Masking, Transparent Data Encryption…
As in each version several new options are available in the High Availability area. Finally, a completely new feature, actually new approach is PolyBase. It allows us to use T-SQL statements to access data stored in Hadoop or Azure Blob Storage and query it in an adhoc fashion.
And of course, if time permits, we'll touch several small features that can be useful for DBAs daily work.

presented by
Milos Radivojevic & Rick Kutschera, Database Gurus @ bwin.party