Level 300

September 28, 2020

Why DBA Should Become a Power BI Ninja? Part 1

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 […]

Read More
September 28, 2020

Why DBA Should Become a Power BI Ninja? Part 2

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 […]

Read More
September 28, 2020

Transaction Isolation Levels – That Could Be Funny

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 […]

Read More
September 28, 2020

Query Optimization on Steroids With SQL Server 2017/2019

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 […]

Read More
September 28, 2020

Data Science for Everybody. Beware of What You Are Eating

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 […]

Read More
September 28, 2020

CDC – Change Data Capture in Detail

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 […]

Read More
September 28, 2020

Internals of System Versioned Temporal Tables

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 […]

Read More
September 28, 2020

Solving Daily Indexing Problems

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 […]

Read More
September 28, 2020

Performance Improvements in SQL Server 2019

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 […]

Read More
September 28, 2020

Turbo Boost Performance by 3 Configurations Changes in 60 Seconds

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 […]

Read More
  • 1
  • 2

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close