IT Tage 2018 in Frankfurt

We spoke during the Frankfurt IT Tage 2018 about SQL Query Performance Monitoring and Analysis under Oracle and Microsoft SQL Server.

The “IT Tage 2018”, the annual conference of the journal Informatik Aktuell, took take place in Frankfurt am Main for the fourth time in this format. From December 10th to 13th, 2018, more than 800 participants from software development, architecture and management will met at Messe Frankfurt’s Congress Center.

Visitors had the opportunity to take part in three enthralling conference days with 7 parallel tracks: more than 160 lectures and workshops on innovations and trends. One of the points of the program was our talk from Michael Roedeske on “Query Performance Monitoring and Analysis on Oracle and Microsoft SQL Server” on Thursday, December 13, 2018.

Further information at: www.ittage.informatik-aktuell.de

Michael Roedeske

DBPLUS Regional Manager D/A/CH

How can you speed up database read queries

Before getting into the technicalities of speeding up your database read queries, the first step is always to have a clear understanding of what exactly you need. This might sound straightforward, but inefficient queries often begin with uncertainty about the data requirements. Knowing exactly what information is necessary for your application or analysis not only helps in crafting precise queries but also prevents the database from retrieving extraneous information, which can significantly slow down performance.

Data Observability

Too often when looking at the data we see just numbers – columns and rows that might seem meaningful on the surface but lack depth without proper context. Data observability changes this perspective. This approach is about understanding what the numbers really tell us about the health, accuracy, and vitality of our data systems.

Data observability isn’t just one thing – it’s an ability, or rather a way of monitoring your data’s health, accuracy, and overall usefulness. It’s what equips data teams with the essential tools they need in order to make sure that the data that’s driving business decisions is not only there but also high-quality, well-structured, and up-to-date.

14/12/2018