| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Tomaž Kaštrun | Analytics and Visualization | Common Data Science Mistakes |
| 09:00:00 | Slaven Šola | Enterprise Database Administration Deployment | SQL Server - automatska optimizacija upita |
| 10:15:00 | Mladen Prajdić | Enterprise Database Administration Deployment | Getting To Know SQL Server Encryption Capabilities |
| 11:30:00 | Uwe Ricken | Application Database Development | Mastering DML Operations like a master |
| 11:30:00 | Kevin Boles | Other | Common TSQL Mistakes |
| 13:30:00 | Hugo Kornelis | Application Database Development | Execution plans ... where do I start? |
| 13:30:00 | Marcelo Fernandes | Strategy and Architecture | Architecting SQL Server environments for Mission Critical and High Performance |
| 14:45:00 | Dejan Sarka | Application Database Development | Temporal Data in SQL Server |
| 14:45:00 | Gianluca Sartori | Application Database Development | SQL Server Infernals - A Beginner’s Guide to Worst Practices |
| 16:00:00 | Miloš Radivojević | Enterprise Database Administration Deployment | Cardinality Estimation Issues with Large Tables |
| 16:00:00 | Aleksandar Talev | Application Database Development | How to choose the right data model: SQL Server or Azure Cosmos DB. Which, When and Where ? |
Event Date: 06-04-2019 - Session time: 09:00:00 - Track: Analytics and Visualization
Event Date: 06-04-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Cilj ovoga predavanja je odgovoriti na pitanje koliko nam umjetna inteligencija može olakšati svakodnevne izazove vezane za održavanje performansi sustava na optimalnom nivou. Kroz primjere ćemo pokušati odgovoriti i na pitanje koliko je realno očekivati da umjetna inteligencija u potpunosti preuzme brigu o performansama sustava.
Event Date: 06-04-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
In this session we'll look at what SQL Server offers in this area:
Event Date: 06-04-2019 - Session time: 11:30:00 - Track: Application Database Development
Come and learn the differences of space allocation/deallocation between Clustered Indexes and Heaps in this demo oriented session. It will answer these questions:
What is the difference of data page allocation for heaps and clustered indexes? What is the amount of transaction log when you update data in a heap and/or in a clustered index? What are the differences when data are delete from a heap and clustered index? Can ETL processes be improved by usage of the right strategy for INSERTS and DELETES? What performance drawbacks will Page Splits and Forwarded Records have for my application design?
Event Date: 06-04-2019 - Session time: 11:30:00 - Track: Other
Event Date: 06-04-2019 - Session time: 13:30:00 - Track: Application Database Development
But sometimes it doesn't. Sometimes a query takes too much time. You need to find out why, so you can fix it. That's where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it's slow.
However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?
In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
Event Date: 06-04-2019 - Session time: 13:30:00 - Track: Strategy and Architecture
Event Date: 06-04-2019 - Session time: 14:45:00 - Track: Application Database Development
This session introduces the temporal problems, deals with solutions that go beyond SQL Server 2016 and 2017 support, and shows out-of-the-box solution in SQL Server 2016 and 2017, including: • Defining temporal data • Application versioned tables • System versioned tables • What kind of temporal support is still missing
Event Date: 06-04-2019 - Session time: 14:45:00 - Track: Application Database Development
You are probably thinking: “Hey, wait, what about Best Practices?”. Sometimes Best Practices are not enough, especially for beginners, and it is not always clear what happens if we fail to follow them. Worst Practices can show the mistakes to avoid. I have made lots of mistakes throughout my career: come and learn from my mistakes!
Event Date: 06-04-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
You’ll see how developer usually workaround this issue, when this is a good idea and when it’s not, and we’ll consider which technical and logical mistakes are made in the process of solving this issue.
Of course, you’ll see why this happens only when working with large tables, what is different in the world of large tables, and how to solve this issue by identifying and eliminating the root cause and not dealing with consequences only.
Attendees should be familiar with the process and components involved in the generation of an execution plan in SQL Server.
Event Date: 06-04-2019 - Session time: 16:00:00 - Track: Application Database Development