| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:45:00 | Markus Ehrenmueller-Jensen | Analytics and Visualization | Create Stunning Visualizations with The Help of R |
| 09:45:00 | Torsten Strauss | Enterprise Database Administration Deployment | Database tuning advisor vs. dynamic management views |
| 09:45:00 | Eugene Polonichko | Cloud Application Development Deployment | Azure Databricks for Data Engineering |
| 10:55:00 | André Melancia | Application Database Development | Hacking? Mission Possible! |
| 10:55:00 | Michal Sadowski | Enterprise Database Administration Deployment | Encryption in SQL Server |
| 10:55:00 | Maryna Popova | BI Platform Architecture, Development Administration | AWS Redshift Introduction |
| 12:50:00 | Grzegorz Stolecki | BI Platform Architecture, Development Administration | Predictive Reporting Services Performance Monitoring |
| 12:50:00 | Marcos Freccia | Enterprise Database Administration Deployment | 10 Alerts that you should have it running in your SQL Server! |
| 12:50:00 | Denis Reznik | Application Database Development | SQL Server Performance Tuning Nowadays |
| 14:00:00 | Jan Mulkens | Advanced Analysis Techniques | Practical SQL Server Machine Learning Services |
| 14:00:00 | Erland Sommarskog | Application Database Development | Dynamic Search Conditions |
| 14:00:00 | Andrii Zrobok | Application Database Development | MS SQL: Worst Practices |
| 15:10:00 | Mikael Wedham | Application Database Development | A Masters view on Query plans and indexing |
| 15:10:00 | Jose Manuel Jurado Diaz | Cloud Application Development Deployment | Back to the future - Migrating our SQL Server OnPremise Database to Azure |
| 15:10:00 | Satya Jayanty | Cloud Application Development Deployment | Azure Cosmos DB - What you need to know to build globally distributed apps? |
| 15:10:00 | Yevhen Nedashkivskyi | Enterprise Database Administration Deployment | ДБА мимоволі – що робити? (українською) |
| 16:20:00 | Andriy Pogorelov | Enterprise Database Administration Deployment | SQL Server Transaction Log: internals |
| 16:20:00 | Catalin Gheorghiu | Application Database Development | SQL database on IoT devices, could you? should you? would you? |
| 16:20:00 | Vitalii Bondarenko | Strategy and Architecture | Data Migration Project for over 200 TB: Pre-sale, Architecture, PoC and Delivery |
Event Date: 29-09-2018 - Session time: 09:45:00 - Track: Analytics and Visualization
Event Date: 29-09-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
SQL Server mainly offers two different tools we can use for this purpose: DTA Database Tuning Advisor and Missing Index Dynamic Management Views. But what are the differences in terms of reliability, usage, limitations and tuning recommendations? So, we will try to answer these questions in this deep dive session (300-400).
Event Date: 29-09-2018 - Session time: 09:45:00 - Track: Cloud Application Development Deployment
Event Date: 29-09-2018 - Session time: 10:55:00 - Track: Application Database Development
This is a security "worst" practices session for developers (yes, yes, the boring "best" practices are also included). As always, should you or any of your colleagues be hacked or exploited, the Demo Gods will disavow any knowledge of the speakers' actions. This session will self-destruct in 60 minutes. Luck has nothing to do with it, Jim…
Event Date: 29-09-2018 - Session time: 10:55:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 10:55:00 - Track: BI Platform Architecture, Development Administration
Will give the overview of the architecture and important details
Event Date: 29-09-2018 - Session time: 12:50:00 - Track: BI Platform Architecture, Development Administration
During my session you will learn how to monitor Reporting Services with the Execution Log. I will show the structure of the log and some useful queries to get precise insights into report generating process. Analysing the log gives you a quick way to find bottlenecks and sources of your problems. Especially when you use a tool like Power BI or Excel to create a functional dashboard. You also will learn how to use R powered models in Power BI to predict problems with your reports execution.
Event Date: 29-09-2018 - Session time: 12:50:00 - Track: Enterprise Database Administration Deployment
By the end of this session, your life as a DBA will be much easier with those alerts in place!
Event Date: 29-09-2018 - Session time: 12:50:00 - Track: Application Database Development
In this session, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. On this way, we will learn performance tuning practical techniques and solve a bunch of issues in real-time. And despite I'm a big fan of Profiler and old-fashioned tools and technics, new, more interesting and useful instruments are available nowadays, so will use them to find the bottleneck and tune performance. Minimum of theory and a lot of practice.
Event Date: 29-09-2018 - Session time: 14:00:00 - Track: Advanced Analysis Techniques
Enough of that, in this session we'll walk through a real SQL Server Machine Learning Services scenario from idea to code and from deployment to monitoring maintenance. Learn how you can easily roll out your own Data Science projects or support the data scientists and analysts at your company.
Event Date: 29-09-2018 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 29-09-2018 - Session time: 14:00:00 - Track: Application Database Development
Sunstroke. Butterfly effect (How optimizer allocates memory for different operations? Is it possible to change allocated memory in-fly (without query recompilation)? Some data types save disk space and what about memory?) Sequence (is it good or bad), Silver bullet (not only SQ-92)
Event Date: 29-09-2018 - Session time: 15:10:00 - Track: Application Database Development
You will se how queries are run, how indexes are used and get an insight into what query plans tell you. Further on you'll be introduced to In-Memory and Column Store indexing to get a fair chance of selecting appropriate indexing for your query load.
Event Date: 29-09-2018 - Session time: 15:10:00 - Track: Cloud Application Development Deployment
This session consists of: -> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse. -> Best Practices and best tools for our migration process depending on the platform chosen. -> After the migration, we have several outstanding questions: Can I keep both environments synchronized? How is the performance of my database?
Event Date: 29-09-2018 - Session time: 15:10:00 - Track: Cloud Application Development Deployment
Event Date: 29-09-2018 - Session time: 15:10:00 - Track: Enterprise Database Administration Deployment
Доповідач, в стислій, але доступній формі на прикладі СУБД Microsoft SQL Server розповість і покаже, що необхідно робити новоспеченим адміністраторам баз даних, навіть якщо ця роль дісталася їм мимоволі.
У цій сесії:
Доповідь призначений для широкої кола в тому числі і для тих, хто не має досвіду в адмініструванні баз даних, а також тим, кому роль ДБА дісталася за сумісництвом.
Українською мовою.
Event Date: 29-09-2018 - Session time: 16:20:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 16:20:00 - Track: Application Database Development
It would be a good idea? What will be the use of it? How to make it work and make the most of it? How does all fit with the field gateway concept? During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions
Event Date: 29-09-2018 - Session time: 16:20:00 - Track: Strategy and Architecture