SQLSaturday #850 - Budapest 2019

Event Date: 04/20/2019 00:00:00

Event Location:

  • Gábor Dénes Főiskola
  • Mérnök utca 39
  • Budapest, , Hungary

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Building a modern data warehouse and BI solution in Microsoft cloud

Abstract: Data warehouse and BI market is evolving rapidly with the appearance of new cloud born technologies. We might assume, that moving an existing Microsoft based DWH to the cloud is an easy step, but when we dig a little bit deeper, we will see, there are many-many new technological choices and aspects on how to modernize an existing dwh/bi system in the cloud. Not to mention if we start everything from scratch in a new project designed specifically to the cloud to utilize cloud flexibility and innovation as much as possible. Which ETL tool should I use? Data factory v2 with SSIS and BIML, or Azure Databricks powered Dataflows? Or Power BI Dataflow? Which is the right decision to run OLAP workloads? Azure AS? Or simply Power BI? When do I need Azure SQL DWH? In the last couple years I helped many customers to modernize their DWH landscape partially or fully in the cloud and during my presentation I will share my findings and recipes for the most common situation I met. You will have fun:)


  • Gergely Csom

Track and Room: BI Platform Architecture, Development Administration - Neumann

Title: Dealing with CosmosDB

Abstract: CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema. In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.


  • Mihail Mateev

Track and Room: Cloud Application Development Deployment - Neumann

Title: IoT Circus – deathmatch oops, datematch :) Power Bi vs Time Series Insights

Abstract: Or how to visualize your data and find insights for beginner IoT developer If you create an IoT solution today, you have a variety of components available to mix and match to make your solution, akin LEGO. You get your hardware and firmware right and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast, and of course you would like to learn something from that data easy and fast. And it would be nice to have the results available on mobile devices, yes, yes easy and fast. Now enter our two titan technologies in a match to the death oops data trying to achieve these goals, you guess it easy fast (and cheap). And we will see them clash, from real hardware, to the big Azure cloud, to mobile devices, trying to outmatch each other.


  • Catalin Gheorghiu

Track and Room: Cloud Application Development Deployment - Room 2

Title: Implementing Supertypes and Subtypes in SQL Server

Abstract: A common problem in database design is the implementation of entities that are different physically (for instance, they share some attributes but have additional, specific, attributes), but should logically participate in the same relationships as one and the same. For instance, the customer can either be a natural person (a person, for short), or a legal person (an organization or a company). The majority of the attributes of a natural person are, of course, different from the majority of the attributes of a legal person; however, from the perspective of how they participate in business operations, they need to be considered as equal. In this session you will learn how to use specific native SQL Server functionalities to solve this particular problem: sparse columns, XML, JSON, and/or even User-defined CLR types – in an OLTP database, as well as in a star (or snowflake) schema data warehouse.


  • Matija Lah

Track and Room: Application Database Development - Neumann

Title: SQL Server Security and Vulnerability Assessment in One Hour

Abstract: Security. We are taking it seriously. But as DBA, we are not always up-to-date with all kind of information which we store in our databases. We know that our database and some tables, even some specific columns when we have multiple types of data, users, permissions and so on need to be protected even more than others.

But we need to know. We have GDPR, ISO2700, SOC compliance around us. And nobody tells us what it exactly means. We ‘simply’ need to be compliant (which is not simple). But we can use the power of SSMS together with Vulnerability Assessment and Security Center to collect all necessary information which we can use later to improve security, as well as decrease risks for our databases. Even better it will cost us (almost) nothing.

We will look for a hybrid environment when our data are on-premises and in the cloud, but we use security tools for both.


  • Tobias Koprowski

Track and Room: Enterprise Database Administration Deployment - Room 3

Title: Top 10 SSAS Design Best Practice (vagy talán több is)

Abstract: Az adatkockák, dimenziók, hierarchiák és attribútumok helyes tervezése létfontosságú az SSAS megoldások teljesítményének fenntartásában.

Jó pár best practice-t összegyűjtöttem az OLAP-kockák építésével és üzemeltetésével töltött évek alatt. Ebben az előadásban végigmegyünk a tíz legfontosabb ilyen gyakorlaton, hogy beépíthesd ezeket a mindennapi munkádba, amikor te építed saját OLAP-kockáidat az Analysis Services platformon. Ülj be erre az előadásra, és nézd meg, hogyan segíthetnek ezek a tippek és best practice-ek időt spórolni neked is!


  • Zoltán Horváth

Track and Room: BI Platform Architecture, Development Administration - Room 2

Title: SQL Server - A Developers vs Admins story

Abstract: When a query runs slow we have debates between developers and admins on “who’s fault it is”. Is the server too slow or badly configured - admins fault. Is the query written badly or the design of the database very poor - developers fault. During this presentation we will learn how to determine if a query can perform better and where to start looking for improvements based on the findings. It will include demo’s which will hopefully engage the audience in debates and see that working together (devs and admins) is the best option.


  • Liviu Ieran

Track and Room: Enterprise Database Administration Deployment - Room 2

Title: Modernise your data migration with Azure Data Migration Service

Abstract: A simple and straightforward solution/process is always helpful when a database migration is planned, irrespective whether it is on-premise or cloud.

Azure Data Migration Service (DMS) is here to perform, lift and shift migrations to Azure SQL Database Managed Instance. Not just with migration using GUI, you can perform scripting to scale migration and plan minimal downtime migrations from different data sources to SQL Server.

Let us jump into Database Migration Service, and how you can utilize and modernize your data estate to fully managed services in Azure.


  • Satya Jayanty

Track and Room: Cloud Application Development Deployment - Room 2

Title: How to win Kaggle competition and get familiar with machine learning ?

Abstract: Have you heard that knowing machine learning is the easiest way to get rich quickly? Let’s test this statement. Kaggle is the place to do data science projects, why not to start there? During this session we will solve simple Kaggle competition. Actually, we will submit two solutions. The first made with super-duper deep neural network (black-box approach). Then we will follow proven ML methodologies and solve the problem methodically. All that using SQL Server Machine Learning Services. Minimum slides and maximum fun guaranteed.


  • Marcin Szeliga

Track and Room: Advanced Analysis Techniques - Room 3

Title: SQL Server In-database machine learning with R and Python

Abstract: Get your fundamental knowledge and insights on how to establish and create your machine learning project with SQL Server 2016 or SQL Server 2017 using R or Python.

From retrieving data from SQL Server to providing data insights with different data exploration techniques to data operationalization and completing the journey with predictive modeling and data visualization and presentation.


  • Tomaž Kaštrun

Track and Room: Advanced Analysis Techniques - Neumann

Title: A baglyok nem azok amiknek látszanak, avagy mi is az a scan?

Abstract: Az SQL Serverrel való ismerkedés úgy kezdödik, hogy az utasításkészlet csupán a SELECT, INSERT, UPDATE és DELETE négyes. Mennyire egyszerü, ehhez mindenki ért.

Aztán ahogy hízik az adatbázis, nagyságrendekkel több tranzakció történik másodpercenként úgy jönnek a meglepetések is. Például mi is az az index scan, hol fordul elö, tényleg végigolvassa-e a teljes táblát? Mi az a scan count, mit jelent ha 0, ha 1, vagy ha több?

Ebben az elöadásban scan-elés témakörét járjuk körbe.


  • Zoltán Hangyál

Track and Room: Application Database Development - Neumann


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Matija Lah

Twitter: - @MatijaLah

LinkedIn: Matija Lah

Contact: http://milambda.blogspot.com

Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.

Marcin Szeliga

LinkedIn: Marcin Szeliga

Data Philosopher. Since 2006 invariably awarded Microsoft Most Valuable Professional title in the Data Platform category. A speaker at numerous conferences across Europe, as well as at user groups meetings. The author of many books and articles devoted to Microsoft Data Platform. An independent consultant, database-centric application practitioner and architect totally focused on SQL Server and Azure. Huge fan of Data Science and Machine Learning.

Matija Lah

Twitter: - @MatijaLah

LinkedIn: Matija Lah

Contact: http://milambda.blogspot.com

Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.

Tobias Koprowski

Twitter: - @KoprowskiT

LinkedIn: Tobias Koprowski

Contact: http://koprowskit.eu/geek/

Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.

Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.

Traveler. Coffee Addicted.

Gergely Csom

Twitter: - https://twitter.com/CsomGergely

LinkedIn: Gergely Csom

Data and AI expert with 15+ years of experience in various data warehousing, BI and AI projects in FSI, OilGas, Energy and Transportation. Experienced trainer, mentor, regular public speaker in various events. Nowadays building the best in class data team for helping our customers in their digital transformation journey in the super exciting Data AI driven revolution. Running cloud IoT pet projects nowadays in his free time:)

Tomaž Kaštrun

Twitter: - @tomaz_tsql

LinkedIn: Tomaž Kaštrun

Contact: http://www.tomaztsql.wordpress.com

Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.

Liviu Ieran

Twitter: - @Liviu_Ieran

LinkedIn: Liviu Ieran

More than 9 years of SQL Server experience working for Microsoft currently as a Support Escalation Engineer. My main area of expertise is SQL Server Performance where I helped optimize numerous query’s and environments.

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

Zoltán Hangyál

1998 óta próbálom megérteni, hogy miért az adott végrehajtási tervet választja az SQL Server. MCT és MCM minősítésekkel rendelkezem, előző életemben évekig tartottam SQL tanfolyamokat az egyik neves oktatóközpontban.

Mihail Mateev

Twitter: - mihailmateev

LinkedIn: Mihail Mateev

Contact: https://mmateev.wordpress.com/

Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.

Catalin Gheorghiu

Twitter: - MrSmersh

LinkedIn: Catalin Gheorghiu

Contact: http://ronua.ro/author/catalin/

Catalin Gheorghiu is a solution architect from Romania. He has more than 15 years of experience in developing solutions, especially on Microsoft technologies in very demanding environments. Is contributing articles and blogs to several user groups (MrSmersh), lecturing all over Romania and abroad, is also RONUA Timisoara (PASS Chapter) user group leader. Since 2011, every year he was awarded the Microsoft MVP Award.

Zoltán Horváth

Twitter: - @zoltanhorvath

LinkedIn: Zoltán Horváth

Contact: http://addictivemeasures.blogspot.com

Zolt#225;n is a BI specialist with more than a decade of expertise. He leads the Hungarian User Group of Microsoft SQL Server (HUG-MSSQL), the Hungarian Chapter of PASS. MCSE: BI and MCSE: Data Platform. SQL Server MVP since 2015.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page