The SQL Server Luxembourg User Group has announced that their next event will take place in Docler Holding’s Kirchberg offices (44 Avenue John F. Kennedy) on Thursday 26 April 2018 at 18:00-21:00, for two presentations covering the new features available in SQL Server 2016 and 2017:

- Realtime Analytics: OLAP & OLTP in the mix with Columnstore.

Since SQL Server 2016 it is possible to have an OLTP & OLAP workload together. This can be achieved using columnstore indexes.

The event will start off with a brief history on how the columnstore indexes evolved in the different SQL Server versions. Then it will take a deepdive on how the columnstore works, explaining what a delta store is, how delete and update operations work, what batch mode processing is, what the different kind of segments are and how to maintain columnstore indexes.

The event will conclude by showing attendees how to combine OLTP & OLAP workload on a database as seen in the field. Showing issues one might face and how to make it fit for one's environment

- SQL Operations Studio and Docker

"Let’s have some fun with SQL operations Studio, containers and a possibly bit of Linux!"

A lot of interesting stuff is happening lately. There is a brand new open source tool for connecting to a beloved SQL Server from any platform one wants: Linux, Mac, Windows, … This tool is the SQL Operations Studio.

Frederik Bogaerts will give attendees an introduction to the tool and show you its full potential. And yes, he promises to make a connection from a Linux OS…

Docler Holding will provide refreshments, so the evening will be rounded off with an informal opportunity for members to meet each other and to discuss the topics raised.

This event is free to all registered attendees. Register via https://sqlserver-luxembourg.eventbrite.com or email to: john.marsh@sql.lu​