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
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).
Sessions
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:)
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- Zoltán Hangyál
Track and Room: Application Database Development - Neumann
Speakers
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.
Sponsors
The following is a list of sponsors that helped fund the event: