Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 20
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: May 06

Time: 9:15 AM - 10:15 AM

Room: 1-es terem

Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
* Product Categories
* Sales Territories
* Calendar and Time
Even when there is a big need from a business perspective, the solutions in relational databases are still sort of awkward. The most flexible hierarchies are modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. You will learn how to master both and will learn how make them fast.
Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: May 06

Time: 3:00 PM - 4:00 PM

Room: Kalmár terem

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 06

Time: 3:00 PM - 4:00 PM

Room: 1-es terem

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 elott 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 eloadá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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 06

Time: 1:45 PM - 2:45 PM

Room: GDF terem

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

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: May 06

Time: 3:00 PM - 4:00 PM

Room: GDF terem

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:
- Non Star Schema Data Warehouses 
- Many to Many/Parent Child/Versioned relationships
- DAX Calculations: semi additive and various flavours of last non empty.
- Events in Progress
- Versioned Fact Tables
- XML Fact Tables
- Real Time update requirements

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 06

Time: 12:30 PM - 1:30 PM

Room: Kalmár terem

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 06

Time: 12:30 PM - 1:30 PM

Room: 1-es terem

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 06

Time: 10:30 AM - 11:30 AM

Room: 1-es terem

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 06

Time: 3:00 PM - 4:00 PM

Room: Kemény terem

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: May 06

Time: 1:45 PM - 2:45 PM

Room: Kalmár terem

Nem csak a felhoben készülnek rohamtempóban az új adatos funkciók, hanem hamarosan megjelenik az SQL Server következo verziója is. Az eloadás során ezekbol az új fejlesztésekbol mutatunk be párat.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: May 06

Time: 9:15 AM - 10:15 AM

Room: GDF terem

A legújabb SQL Server Reporting Services és Analysis Services segítségével akár helyi környezetben is publikálhatunk gyönyöru irányító pultokat, amiket tetszoleges mobil eszközrol is elérhetünk. Az eloadás során bemutatásra kerül a Power BI felhos szolgáltatás használata, valamint az új SQL Server nyújtotta riporting lehetoség is.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 06

Time: 12:30 PM - 1:30 PM

Room: GDF terem

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: May 06

Time: 1:45 PM - 2:45 PM

Room: 1-es terem

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 06

Time: 10:30 AM - 11:30 AM

Room: Kemény terem

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 06

Time: 9:15 AM - 10:15 AM

Room: Kalmár terem

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 06

Time: 1:45 PM - 2:45 PM

Room: Kemény terem

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 06

Time: 10:30 AM - 11:30 AM

Room: GDF terem

SQL Server 2012 introduced an important extension to its integrated Full-text Search, namely the Statistical Semantic Search. In this session you will learn how to install and configure this new functionality, how to use it to extend your existing full-text search capabilities, and how to utilize it properly to improve your information management solutions. You will learn how to automatically extract key phrases from your documents, and how to find similarities between individual documents of your information corpus based on the key phrases that they contain.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: May 06

Time: 9:15 AM - 10:15 AM

Room: Kemény terem

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 06

Time: 9:15 AM - 10:15 AM

Room: Kalmár terem

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Advanced

Session Code:

Date: May 06

Time: 12:30 PM - 1:30 PM

Room: Kemény terem

Sessions Found: 20
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids