Level 400

August 4, 2020

Spatial Analysis With SQL Server, R and Power BI

Speaker: Andrea Martorana Tusa Level: 400 Everything in our world is located “somewhere” and is related to other things. Spatial analysis consists of studying these relationships to find out meaningful patterns and behaviors. Figure out, you’re looking for the best position to open a new store. It´s not only a matter of “where”, but also […]

Read More
August 4, 2020

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 4, 2020

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 4, 2020

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 4, 2020

Scaling Databases Using Partitioned Views

Speaker: Ralph Attard Level: 400 The first part of this session will explore how vertical and horizontal partition strategies could be queried, updated, and distributed using database views that unify various tables together. Simple views are updateable however more complex views that include derived or constant fields, aggregates, or target multi-table updates would require instead […]

Read More
August 4, 2020

Dissecting SQL Server Partitioned Tables

Speaker: Ralph Attard Level: 400 A deep dive into SQL Server Partitioned Tables. Introduced with SQL Server 2005 this is a feature that allows one table to be split into smaller parts transparently based on a partitioning key. This session will start off with an introduction and debunk some myths whilst covering the basics of […]

Read More
August 4, 2020

The Language of Graph Databases and SQL Server

Speaker: Andrea Martorana Tusa Level: 400 SQL Server 2017 introduced the extension for graph databases; and with SQL Server 2019, some key feature has been added. As there are millions of SQL Server users worldwide, this release broadens enormously the audience of potential users. Graph databases are born to address the need of handling complex […]

Read More
August 4, 2020

Failure Prediction for Manufacturing Industry with SQL Server & R

Speaker: Andrea Martorana Tusa Level: 400 Working in manufacturing industry means that you must deal with product failures. As a BI and/or Data Scientist developer, your task is not only monitor and report product’s health state during its lifecycle, but also predict the likelihood of a fail in the production phase or when product has […]

Read More

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