(Dave Stokes) Constraint Checks that actually checked the constraints were introduced last year with MySQL 8.0.16 and they really do help you keep bad data out of your database.
Author: SSWUG Research
Data Prep for Machine Learning: Missing Data
(James McCaffrey) Preparing data for use in a machine learning (ML) system is time consuming, tedious, and error prone. A reasonable rule of thumb is that data preparation requires at least 80 percent of the total time needed to create an ML system.
Every Line Of Code That You Write Is An Explicit Decision To Make The Application Better Or Worse
(Ben Nadel) The other day, I was watching the new Hannah Gadsby comedy special (which is great, by the way), when something she said about Art got me thinking about Programming.
It’s all in the Host Class – Part 2: Configuration
(Christian Nagel) In part 1 of this article series Dependency Injection was covered – one of the features of the Host class. This article shows another aspect that’s needed by nearly every application: configuration.
Datafile in a PDB added but not backed up
(Hemant K Chitale) (I think I’ve covered this with a pre-12c non-PDB example earlier, but this demo is with a 12c PDB)
An Introduction to the io_uring Asynchronous I/O Framework
(Bijan Mottahedeh) This blog post is a brief introduction to the io_uring asynchronous I/O framework available in release 6 of the Unbreakable Enterprise Kernel (UEK).
Redo Copy Latch Contention 2: MTTR Advisor
(Nenad Noveljic) In the previous blog post I showed how a DML can hold a redo copy latch for a very long time if private strands aren’t used. Since recursive statements during logon bypass private strands, this can cause serious latch wait cascades.
TornadoVM: Accelerating Java with GPUs and FPGAs
(Juan Fumero) Last March, I gave a talk at QCon-London about TornadoVM, where I provided an introduction to TornadoVM and explained how it works.
Db2 12 for z/OS Function Level 507
(Craig S. Mullins) This month, June 2020, IBM introduced a new function level, FL507, for Db2 12 for z/OS. This is the first new function level this year, and the first since October 2019.
Upload files to ADLS Gen2
(James Serra) I discover a small new feature the other day, but a very useful one. Previously, there was no way to upload files to an ADLS Gen2 storage account via the Azure portal.