SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Spring into the Latest Features at the Luxemborg User Group

By Additional Articles,

The SQL Server Luxembourg User Group invites you to join us at our next event, in Docler Holding’s Kirchberg Offices, 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.

We will start off with a brief history on how the columnstore indexes evolved in the different SQL Server versions. Then we 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 & how to maintain your columnstore indexes.

We will conclude by showing you how to combine OLTP & OLAP workload on a database as seen in the field. Showing you issues you might face & how to make it fit for your environment

Stijn Wynants: https://kohera.be/blog/author/stijn-wynants/

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. We’ve got a brand new open source tool for connecting to our beloved SQL Server from any platform we want: Linux, Mac, Windows, … This tool is the SQL Operations Studio.

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

Frederik Bogaerts: https://kohera.be/blog/author/frederik-bogaerts/

Docler Holding have kindly offered to 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

 
Total article views: 74 | Views in the last 30 days: 1
 
Related Articles
BLOG

Columnstore Indexs

Columnstore Indexes for Fast DW The SQL Server 11.0 release (2012) introduces a new data warehouse...

ARTICLE

Learning Columnstore Indexes

References and links to learn more about columnstore indexes.

BLOG

SQL Server 2014: Columnstore Index improvements

In SQL Server 2012, a new feature was added called Columnstore Indexes that resulted in huge query p...

ARTICLE

Columnstore Index Changes in SQL Server 2014

SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP ...

BLOG

xVelocity Columnstore Indexes in SQL Server 2012

With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xV...

Tags
user groups    
 
Contribute