November 2019

August 5, 2021

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
August 5, 2021

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
August 5, 2021

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
August 5, 2021

Working with Azure Database Services Platform

Speaker: Roberto Freato Level: 200 Azure SQL Database has been one of the first Platform-as-a-Service offering of the Azure ecosystem in the early stages of the platform. Now is one of the most advanced managed RDBMS in the cloud, actually very different from the competition. In this session, inspired by the chapter 1 of the […]

Read More
August 5, 2021

Multi-tenant Full-Text Search and Data Consolidation With Azure

Speaker: Roberto Freato Level: 400 For many years we used SQL and FTS to extend the features of the frontends which need a good search solution. Despite it is a valid approach, it is often unoptimal, since there are products that do this as their first purpose. One of that is Azure Search, which is […]

Read More
August 5, 2021

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
August 5, 2021

Understanding Parameter Sniffing

Speaker: Benjamin Nevarez Level: 400 Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will […]

Read More
August 5, 2021

Dive Into the Query Optimizer – Undocumented Insight

Speaker: Benjamin Nevarez Level: 400 This session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted […]

Read More
August 5, 2021

Azure Databricks from SQL Server Developer Point of View

Speaker: Paweł Potasiński Level: 200 Azure Databricks has a strong position in modern data platform architecture in Azure. It has many different use cases – from data transformations, through streaming, up to machine learning. The purpose of this demo-full session is to show how SQL Server developer can benefit having some skills required to work […]

Read More
August 5, 2021

Secrets of SQL Server – Database Worst Practices

Speaker: Pinal Dave Level: 200 “Oh! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to […]

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