PASS Austria

Willkommen bei der PASS Austria

Die PASS Austria ist eine unabhängige Interessengemeinschaft von SQL Server Anwendern und behandelt in regelmäßigen Treffen, in technischen Konferenzen und im Web unterschiedliche Themen rund um Microsoft SQL Server. Die PASS Austria ist ein gemeinnütziger Verein und Teil der internationalen Professional Association for SQL Server (PASS) Organisation.

Sie ist für jedermann und –frau offen und soll als Informations- und Diskussionsforum sowohl für Anfänger als auch für Experten geeignet sein.

Interessierte sind herzlich willkommen sich auf kostenfrei zu registrieren und als Mitglieder des "Austrian Chapters" einzutragen.

Next Meeting




SQL Server 2016 CTP2 First Impressions

  • In-Person @ Marxergasse 1B, 1030 Wien, Austria (map)
  • 14:00 - 20:00 W. Europe Daylight Time
  • Language: German

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.


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

Anmeldungen unter

Featured Presentation:

SQL Server 2016 CTP2 First Impressions: What’s New for Developers?

Miloš Radivojević, Principal Database Consultant bwin GVC

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.

SQL Server 2016 CTP2 First Impressions: What’s New for DBAs?

Wolfgang Rick Kutschera

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.

Wir unterstützen ... Informatik Aktuell




Back to Top