Slovak SQL Server & BI

Welcome to the Slovak SQL Server & BI User Group

Next Meeting

Wednesday,

December

06

#1 - SQL Server 2016 and #2 - Windowing Functions

  • In-Person @ Apollo Business Center II, blok E Bratislava, , Slovakia (map)
  • 18:00 - 20:00 (UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
  • Language: English

Session #1 by Marek Chmel, SQL Server 2016 from 18:00 - 19:00
Session #2 by Andrej Zafka, Windowing Functions from 19:00 - 20:00 

https://www.eventbrite.com/e/news-in-sql-server-2016-and-windowing-functions-by-slovak-sql-server-user-group-tickets-39767846700

Featured Presentation:

SQL Server 2016

Marek Chmel, Sr. Technical Team Lead at&t Global Network Services

SQL Server 2016 has introduced many new features, which bring better scalability, performance and security for your environment. Join us on this session where we’ll discuss many of those with practical examples.

About Marek:
I have started working in IT as a consultant and trainer for Microsoft server systems and from the beginning I did focus mainly on SQL Server. Few years back I have joined at&t, where I workin a team responsible for 24/7 operations for large SQL server environments. Our primary focus is architecture, delpoyment, performance tuning and disaster recovery for SQL Server ranging various sizes, versions and editions. If there's any free time left, you can catch me speaking at a conference or teaching a Microsoft or security class in a training center.

Windowing Functions

Andrej Zafka, MS SQL Developer

How to understand OVER() and PARTITION BY in TSQL, examples and benefits of windowing functions – managing heavy aggregations, de-duplicating data, running totals, paging and data islands. What is behind “set theory” of windowing functions.

About Andrej:
MS SQL Developer with 5 years’ experience in BI solutions using SQL Server family - TSQL, MDX, SSRS, SSAS and SSIS. Experienced with in-memory technology, temporal tables and data modeling. Interesting in cutting edge technologies like In-Memory technology and Column Store Indexes.

Supplementary Materials

The following event attachments are available to you:

PASSChapterLogo.jpg

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids