October 2019

April 1, 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
April 1, 2020

Kick Start! SQL Server 2017/2019 Performance Tips and Tricks

Speaker: Pinal Dave Level: 300 Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 has introduced many new features. This session is carefully crafted to help overcome the beginner’s inertia for DBAs who have been using SQL Server […]

Read More
April 1, 2020

Poor Man’s SQL Server Job Monitoring with R

Speaker: Thomas Hütter Level: 300 Of course SQL Server (Management or Azure Data Studio) offers you a list view of the agent job history. But wouldn’t it be nice to have a graphical overview of job durations and how they develop? This session is for DBAs and R newbies alike: In one hour we’ll develop […]

Read More
April 1, 2020

Can I Join You?, One Table Asked the Other

Speaker: Thomas Hütter Level: 300 So you have your database beautifully set up according to Codd. What do you need when you have to retrieve data from related tables? Most probably a JOIN operator, but which one? From LEFT to RIGHT, when is it INNER and when OUTER? Is a CROSS JOIN something NATURAL? And […]

Read More
April 1, 2020

Exploring the Cosmos DB

Speaker: Ralph Attard Level: 200 Will start off by introducing Cosmos DB as a globally distributed, massively scalable, multi-model database service and utilise a Try Azure Cosmos DB for free subscription to download and demo a sample .NET app. Will then look into Change Feed, Distributed Architecture, Multi-Master, Consistency Models, and a number of use […]

Read More
April 1, 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
April 1, 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
April 1, 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
April 1, 2020

Advanced Analytics with Power BI

Speaker: Andrea Martorana Tusa Level: 300 Power BI makes advanced analytics handy for business users, allowing stakeholders to extract knowledge and insights from data, to solve business problems and make decisions. This session will introduce to the advanced analytics features of Power BI, showcasing some real word areas of application: forecasting, predictive analytics, data streaming […]

Read More
April 1, 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
  • 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