sqlsathistory

Nr: 626

Back to Main list

SQLSaturday #626 - Budapest 2017

Start Time (24h) Speaker Track Title
09:15:00 Karol Papaj BI Platform Architecture, Development Administration SQL Server’s 2016 Hidden Gems for BI Developers
09:15:00 Satya Jayanty Enterprise Database Administration Deployment 2,4,8 16 - Upgrade your journey with SQL Server
09:15:00 LEONEL ABREU BI Platform Architecture, Development Administration Self Service BI Solutions with Analysis Services
09:15:00 Viktor Dudas Strategy and Architecture Microsoft adat platform áttekintés
10:30:00 Catalin Gheorghiu Application Database Development Power Bi for beginner IoT developer
10:30:00 Torsten Strauss Enterprise Database Administration Deployment hash and stream aggregation
10:30:00 Janos Berke Enterprise Database Administration Deployment SQL Server 2016 Availability Group újdonságok
12:30:00 Sergey Olontsev Professional Development Tricky ways to optimize your T-SQL queries
12:30:00 Bob Duffy BI Platform Architecture, Development Administration Complex Tabular Modelling - A Case Study
12:30:00 André Melancia Enterprise Database Administration Deployment Hacking SQL Server
12:30:00 Attila Kővári Analytics and Visualization Önkiszolgáló adatvizualizációs lehetőségek Power BI segítségével a földön, vagy a felhőben
13:45:00 Miroslav Dimitrov Enterprise Database Administration Deployment Performance Tuning for the Transaction Log
13:45:00 Jose Manuel Jurado Diaz Application Database Development SQL SERVER - Next station Azure
13:45:00 Dejan Sarka Advanced Analysis Techniques Introducing R
13:45:00 Zoltán Horváth BI Platform Architecture, Development Administration Analysis Services biztonság
15:00:00 Markus Ehrenmueller-Jensen Application Database Development A Game of Hierarchies: Mastering Recursive Queries
15:00:00 Mikael Wedham Enterprise Database Administration Deployment A Masters view on Locking and blocking
15:00:00 Dejan Pervulov BI Platform Architecture, Development Administration How to use Temporal Tables in SQL Server 2016
15:00:00 Zoltán Hangyál Strategy and Architecture Az eltűnt operátor nyomában

SessionID: 59891

SQL Server’s 2016 Hidden Gems for BI Developers

Back to calendar

Event Date: 06-05-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Karol Papaj

Title: SQL Server’s 2016 Hidden Gems for BI Developers

Abstract:

SQL Server 2016 contains many brand new features, which are important to BI developers, including NUMA support for SSAS Tabular, parallel processing partitions, Tabular Model Scripting language and others. In this session, I will focus to not well known feature enhancements in SSAS 2016, which can developers benefit from, like DAX improvements (DAX variables, new DAX functions), bi-directional cross filtering, translations, calculated tables, consistency checker and extended events for SSAS, and more.

SessionID: 61337

2,4,8 16 - Upgrade your journey with SQL Server

Back to calendar

Event Date: 06-05-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Satya Jayanty

Title: 2,4,8 16 - Upgrade your journey with SQL Server

Abstract:

2,4,8 16 - these aren't just numbers to count or calculate. These are years that how SQL Server evolved as number of years!

Why Upgrade? Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server (2000 to 2012), SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.

What to-do and what not-to-do?

A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.

SessionID: 61417

Self Service BI Solutions with Analysis Services

Back to calendar

Event Date: 06-05-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: LEONEL ABREU

Title: Self Service BI Solutions with Analysis Services

Abstract:

This session covers the aspects to be considered to deploy a Self Service BI Solution, also will be made a comparison between two Analysis Services modes, Tabular and Multidimensional, exploring advantages, features and capabilites, explaining when and why use each model.

SessionID: 63466

Microsoft adat platform áttekintés

Back to calendar

Event Date: 06-05-2017 - Session time: 09:15:00 - Track: Strategy and Architecture

Speaker: Viktor Dudas

Title: Microsoft adat platform áttekintés

Abstract:

Nem csak a felhőben készülnek rohamtempóban az új adatos funkciók, hanem hamarosan megjelenik az SQL Server következő verziója is. Az előadás során ezekből az új fejlesztésekből mutatunk be párat.

SessionID: 61151

Power Bi for beginner IoT developer

Back to calendar

Event Date: 06-05-2017 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Catalin Gheorghiu

Title: Power Bi for beginner IoT developer

Abstract:

You have IoT solutions, and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast. You would also love to have these data is available on mobile devices.

Solutions to this problem is the Power BI these especially if you are already using Azure or Office 365. In this presentation I will try to introduce you to Power BI with at least enough information to know where to start. All with the demo, from hardware, to the cloud, to Power BI.

SessionID: 61381

hash and stream aggregation

Back to calendar

Event Date: 06-05-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Torsten Strauss

Title: hash and stream aggregation

Abstract:

The session (level 300) will introduce the differences between the hash and stream aggregation.

You will see the differences in terms of the internal algorithm, performance, scalability, hardware consumption and understand the limitations. In the end of the session you will able to predict which physical aggregate operator SQL Server will implement to run the query and you have learned to implement the right index strategy to boost the query execution.

SessionID: 63154

SQL Server 2016 Availability Group újdonságok

Back to calendar

Event Date: 06-05-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Janos Berke

Title: SQL Server 2016 Availability Group újdonságok

Abstract:

SQL Server 2016 Availability Group nagyon sok újdonságot hozott, illetve a vNext már Linux-ra is elérhető. a CTP1.3 verzióval már lehet Win-Linux AG-t is készíteni.

SessionID: 62417

Tricky ways to optimize your T-SQL queries

Back to calendar

Event Date: 06-05-2017 - Session time: 12:30:00 - Track: Professional Development

Speaker: Sergey Olontsev

Title: Tricky ways to optimize your T-SQL queries

Abstract:

Curious about optimizing your queries? Have you already know how to catch and analyse query plans? Do you think you did all your best to achieve maximum performance? If yes, come to this session. No slides, but only practical examples. I will show you some real tasks that I came across, some almost perfect query plans, but we will go a little bit further, when knowing our data will help us to achieve better results.

SessionID: 62459

Complex Tabular Modelling - A Case Study

Back to calendar

Event Date: 06-05-2017 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bob Duffy

Title: Complex Tabular Modelling - A Case Study

Abstract:

While building of Tabular Models may be straight forward it rapidly becomes more complex when you steer off-piste and into more complex design pattern such as:

This one hour session will walk through an actual case study of a tabular model and discuss the pain points we encountered on the way, along with solutions and workarounds.

SessionID: 62730

Hacking SQL Server

Back to calendar

Event Date: 06-05-2017 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: André Melancia

Title: Hacking SQL Server

Abstract:

How easy is it to hack a SQL Server?

In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, and more. Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants.

SessionID: 63482

Önkiszolgáló adatvizualizációs lehetőségek Power BI segítségével a földön, vagy a felhőben

Back to calendar

Event Date: 06-05-2017 - Session time: 12:30:00 - Track: Analytics and Visualization

Speaker: Attila Kővári

Title: Önkiszolgáló adatvizualizációs lehetőségek Power BI segítségével a földön, vagy a felhőben

Abstract:

A legújabb SQL Server Reporting Services és Analysis Services segítségével akár helyi környezetben is publikálhatunk gyönyörű irányító pultokat, amiket tetszőleges mobil eszközről is elérhetünk. Az előadás során bemutatásra kerül a Power BI felhős szolgáltatás használata, valamint az új SQL Server nyújtotta riporting lehetőség is.

SessionID: 59888

Performance Tuning for the Transaction Log

Back to calendar

Event Date: 06-05-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Miroslav Dimitrov

Title: Performance Tuning for the Transaction Log

Abstract:

SQL Server transaction log is one of the most critical components of the database and in the same time one of the most misunderstood. While being neglected it can easily become a bottleneck for our system. Are you interested in learning how to avoid issues with the transaction log and streamline its work? In these sessions we will explore how to optimize it, configure it and keep it under control.

SessionID: 61025

SQL SERVER - Next station Azure

Back to calendar

Event Date: 06-05-2017 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Jose Manuel Jurado Diaz

Title: SQL SERVER - Next station Azure

Abstract:

This session will cover the main aspects to start or migrate from an OnPremise model to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment for our requirements.

We will cover:

  1. Red pill or blue pill SQL Server on Azure VM (IaaS) vs SQL Azure DB (PaaS) Which one?
  2. Always available. High availability in Azure
  3. Now what ... Best practices and configuration connectivity.

SessionID: 61485

Introducing R

Back to calendar

Event Date: 06-05-2017 - Session time: 13:45:00 - Track: Advanced Analysis Techniques

Speaker: Dejan Sarka

Title: Introducing R

Abstract:

R is a free software programming language and software environment for statistical computing, data mining, and graphics. R is extensively supported in SQL Server 2016 suite, in Power BI, and in Azure ML. In order to use it, you have to learn the language. After attending this session, you should be able to write simple R code and use it in the products and services mentioned.

SessionID: 63142

Analysis Services biztonság

Back to calendar

Event Date: 06-05-2017 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Zoltán Horváth

Title: Analysis Services biztonság

Abstract:

Már nyilván tisztában vagy vele, hogy a vállalati adataitok értékesek - minden nap ezek adnak hátteret a cégetek döntéseinek. De sajnos ezen adatok valódi értéke akkor derül ki, ha már a rosszfiúk szeme előtt vannak a felösszegzett számaitok. Vagy még rosszabb: a multidimenzionális elemzések is.

Nos, annyira nem kell aggódnotok: üljetek be erre az előadásra, és vegyetek részt az Analysis Services biztonsági funcionalitásainak és technikáinak egy egyórás áttekintésén, hogy ti is meg tudjátok védeni a cégetek kockákba töltött adatait.

SessionID: 61059

A Game of Hierarchies: Mastering Recursive Queries

Back to calendar

Event Date: 06-05-2017 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Markus Ehrenmueller-Jensen

Title: A Game of Hierarchies: Mastering Recursive Queries

Abstract:

Hierarchies are the bread and butter of most business applications and you find them almost everywhere:

SessionID: 62608

A Masters view on Locking and blocking

Back to calendar

Event Date: 06-05-2017 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Mikael Wedham

Title: A Masters view on Locking and blocking

Abstract:

How do the wait stats show you that you have a locking issue?

This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.

SessionID: 63076

How to use Temporal Tables in SQL Server 2016

Back to calendar

Event Date: 06-05-2017 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dejan Pervulov

Title: How to use Temporal Tables in SQL Server 2016

Abstract:

If analysis of historical data is part of your everyday activities or you simply need to revert your database table to a state before unwanted change there is a new feature in SQL Server 2016 that will allow you to work efficiently with historical data. During this session we will talk about different usage scenarios for Temporal Tables and demonstrate how to use them through examples.

SessionID: 63164

Az eltűnt operátor nyomában

Back to calendar

Event Date: 06-05-2017 - Session time: 15:00:00 - Track: Strategy and Architecture

Speaker: Zoltán Hangyál

Title: Az eltűnt operátor nyomában

Abstract:

Az SQL Server Query Optimizer a kedvenc adatbáziskezelőnk lelke. Nagyon sok minden múlik rajta. Ebben az előadásban belesünk a színfalak mögé. Mi a feladata, milyen varázslatokat is csinál pontosan?