| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:00:00 | Denis Reznik | Application Database Development | Hidden gems of SQL Server 2017 |
| 10:00:00 | Mihail Mateev | Application Database Development | Build Modern Cloud Applications with Net Core 3.0, entity framework and CosmosDB. |
| 10:00:00 | Ruslan Zolotukhin | Advanced Analysis Techniques | Hidden force of the PowerQuery. Powerful ETL AI integration |
| 11:10:00 | Sergey Syrovatchenko | Professional Development | SQL Server Columnstore Indexes: Practical recipes |
| 11:10:00 | Artur Konstantynov | Analytics and Visualization | Power BI. Benefits and Pitfalls of DAX. |
| 11:10:00 | Yevhen Nedashkivskyi | Application Database Development | Узгодженість, паралелізм та блокування в сучасних базах даних |
| 13:30:00 | Taras Kloba | Enterprise Database Administration Deployment | What is CI/CD for databases or how to automate DB changes |
| 13:30:00 | Erland Sommarskog | Application Database Development | Don't Use Cursors or Why You Maybe Should Use a Cursor After All |
| 13:30:00 | Eugene Polonichko | BI Platform Architecture, Development Administration | Architecture of modern data warehouse |
| 14:40:00 | André Melancia | Enterprise Database Administration Deployment | Hacking SQL Server Is Not Enough |
| 14:40:00 | Erland Sommarskog | Application Database Development | Don't Bite Off More Than You Can Chew - Take It in Chunks |
| 14:40:00 | Dmytro Polishchuk | BI Platform Architecture, Development Administration | Slowly Changing Dimensions types 0 through 7 and their ETL implementation (SSIS exmples) |
| 16:00:00 | André Melancia | Enterprise Database Administration Deployment | SQL Curiosities: Цікавість згубила кішку |
| 16:00:00 | Andrii Zrobok | Application Database Development | MS SQLServer 2019 Intelligent Query Processing |
| 16:00:00 | Catalin Gheorghiu | Application Database Development | SQL database on IoT devices, could you? should you? would you? |
Event Date: 28-09-2019 - Session time: 10:00:00 - Track: Application Database Development
In this session, we will learn a lot about these features and improvements. Which features? This is a secret :) Come to the session and discover them with me!
Event Date: 28-09-2019 - Session time: 10:00:00 - Track: Application Database Development
What this will bring us? Let's look the possible architectures of modern cloud applications and the impact of the different database solutions.
Event Date: 28-09-2019 - Session time: 10:00:00 - Track: Advanced Analysis Techniques
Event Date: 28-09-2019 - Session time: 11:10:00 - Track: Professional Development
In this session, we will look at several tips how to improve performance of our work scenarios with using columnstore indexes. Also will discover in this session how to make incredible magics with data storage.
Event Date: 28-09-2019 - Session time: 11:10:00 - Track: Analytics and Visualization
Event Date: 28-09-2019 - Session time: 11:10:00 - Track: Application Database Development
Спробуємо розібратися та обійти потенційні проблеми та на прикладі Microsoft SQL Server. Під час доповіді ми торкнемось тем паралелізму, затримок, блокувань та взаємоблокувань, а також різних рівнів ізоляції.
Event Date: 28-09-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
In this session, I will show how to build a deployment pipeline capable of delivering database and application changes. The pipeline includes the following steps: source control, continuous integration and continuous delivery. I will share methods and strategies that allow bringing together databases and applications in the delivery process reducing the delivery pain. The main goal is to understand that applications and databases can and should share the same deployment pipeline and that this pipeline will allow you not be afraid of making database changes.
Event Date: 28-09-2019 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 28-09-2019 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Microsoft Azure provides a set of fully managed services, which allow you to build modern DWH in a few minutes. All Azure services support a fully cloud based solution, or a mix of cloud and on-premise based solutions, to meet the business need. A modern Data Warehouse can be designed to meet business need and accommodate change in data behavior using the latest technology components such as cloud based scalable data storage for big data, real time analytics, predictive analysis and machine learning, global distribution of data, high availability, etc.
Event Date: 28-09-2019 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Event Date: 28-09-2019 - Session time: 14:40:00 - Track: Application Database Development
You can solve this by operating on the data in chunks. Implementing chunking is not that difficult, but there are still pitfalls you can run into. In this session, I will discuss in what situations you may want to use chunking. I will give some best practices for how to implement chunking for good performance and I will highlight some things you need keep in mind, for instance, recovering from interruptions.
I will also look at how you can use chunking for error handling: You want process many rows and you want the good rows to succeed even if some rows yield errors – something you cannot do in a single set-based statement.
Event Date: 28-09-2019 - Session time: 14:40:00 - Track: BI Platform Architecture, Development Administration
Explanation of every SCD type. Analytical value, pros and cons of each will be investigated, SSIS package examples provided. Power BI will be used as a client application to demonstrate the results.
Event Date: 28-09-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Disclaimer: No feline was harmed in the making of this session. Please do not report it to the Kyiv Society for the Protection of Animals...
Event Date: 28-09-2019 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 28-09-2019 - Session time: 16:00: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