Speaker: Grzegorz Stolecki Level: 300 Tell us what happened yesterday between 2 and 3 pm? Server was almost dead, a simple report took 20 minutes to execute. Nightmare. As DBA you hear such questions very often. So you start to work.. You take tools like Data Collector or Query Store (maybe their databases, because you […]

Speaker: Grzegorz Stolecki Level: 300 Tell us what happened yesterday between 2 and 3 pm? Server was almost dead, a simple report took 20 minutes to execute. Nightmare. As DBA you hear such questions very often. So you start to work. You take tools like Data Collector or Query Store (maybe their databases, because you […]

Speaker: Damian Widera Level: 300 Every developer and DBA should know way more beyond how the default transaction isolation level to make sure they know what to expect when working with them. I will present all of the levels and show you some surprising facts about them. We will go through various if deep demos […]

Speaker: Damian Widera Level: 300 Adaptive or Intelligent? Maybe both? SQL Server 2017 has come into the light packed with automated query tuning based on the Query Store and Plan Cache. SQL Server 2019 has a lot more important features like =batch mode on rowstore, memory grant feedback, interleaved execution, adaptative joins, deferred compilation and […]

Speaker: Damian Widera Level: 300 This is a session about practical approach to the data analysis. I do not know much about mushrooms but I know that some of them could be poisonous. But what about other mushrooms? Should I eat them or not? If you have the same doubts than you should attend the […]

Speaker: Uwe Ricken Level: 300 Change data capture records insert, update, and delete activity that is applied to a SQL Server table. This makes the details of the changes available in an easily consumed relational format. Column information and the metadata that is required to apply the changes to a target environment is captured for […]

Speaker: Uwe Ricken Level: 300 SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. This session takes you behind […]

Speaker: Uwe Ricken Level: 300 Have you ever been in the situation that an application performed well the last day and – suddenly – you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 […]

Speaker: Maciej Pilecki Level: 300 The freshly released SQL Server 2019 comes with a bunch of really cool performance improvements which fall into the “it just works” category. Just by upgrading your databases to SQL Server 2019, both performance and scalability can improve dramatically for certain types of workloads – come to this session to […]

Speaker: Pinal Dave Level: 300 DBAs and Developers often work across multiple versions of the SQL Server. It is not possible for to know every single configuration settings introduced in the new version of SQL Server. To keep the predictable behavior SQL Server many of the newly introduced settings are kept off or disabled. In […]