In this second installment of the Anomaly Detection articles, we will explore another practical way to do Anomaly Detection in Python, and then we'll use what we just learned to do the same in pure SQL that you can insert anywhere.
Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.
You have probably heard about Db2 12 Dynamic SQL plan stability already. However, before you decide to activate it, you should learn more first. This article is going to help you on your journey to stabilize your dynamic world.
Con las funciones de OLAP RANK y DENSE_RANK disponibles en programación SQL desde hace un tiempo, resulta bastante fácil preguntar por las «n» ocurrencias de valor más alto en un conjunto de datos ordenado. Lo que se conoce como «TOP n».
Do you make any New Year's resolutions? In case you don't have any Db2 related, we have a suggestion for you. What if you start the New Year with improving the performance of your SQL queries? Learn more about the advanced query tuning by listening to the presentation by Tony Andrews.