| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:30:00 | Gergely Csom | BI Platform Architecture, Development Administration | Building a modern data warehouse and BI solution in Microsoft cloud |
| 09:30:00 | Zoltán Horváth | BI Platform Architecture, Development Administration | Top 10 SSAS Design Best Practice (vagy talán több is) |
| 10:45:00 | Marcin Szeliga | Advanced Analysis Techniques | How to win Kaggle competition and get familiar with machine learning ? |
| 10:45:00 | Satya Jayanty | Cloud Application Development Deployment | Modernise your data migration with Azure Data Migration Service |
| 10:45:00 | Zoltán Hangyál | Application Database Development | A baglyok nem azok amiknek látszanak, avagy mi is az a scan? |
| 13:00:00 | Mihail Mateev | Cloud Application Development Deployment | Dealing with CosmosDB |
| 13:00:00 | Tobias Koprowski | Enterprise Database Administration Deployment | SQL Server Security and Vulnerability Assessment in One Hour |
| 14:15:00 | Tomaž Kaštrun | Advanced Analysis Techniques | SQL Server In-database machine learning with R and Python |
| 14:15:00 | Catalin Gheorghiu | Cloud Application Development Deployment | IoT Circus – deathmatch oops, datematch :) Power Bi vs Time Series Insights |
| 15:30:00 | Liviu Ieran | Enterprise Database Administration Deployment | SQL Server - A Developers vs Admins story |
Event Date: 20-04-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
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:)
Event Date: 20-04-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
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!
Event Date: 20-04-2019 - Session time: 10:45:00 - Track: Advanced Analysis Techniques
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.
Event Date: 20-04-2019 - Session time: 10:45:00 - Track: Cloud Application Development Deployment
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.
Event Date: 20-04-2019 - Session time: 10:45:00 - Track: Application Database Development
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.
Event Date: 20-04-2019 - Session time: 13:00:00 - Track: Cloud Application Development Deployment
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.
Event Date: 20-04-2019 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
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.
Event Date: 20-04-2019 - Session time: 14:15:00 - Track: Advanced Analysis Techniques
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.
Event Date: 20-04-2019 - Session time: 14:15:00 - Track: Cloud Application Development Deployment
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.
Event Date: 20-04-2019 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
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.