(Paul McWilliams) Db2 12 function level 506 is now available. It introduces new alternative spellings for existing SQL built-in functions to improve compatibility with competitive database platforms, the SQL standard, and the Db2 product family.
Other News
Here’s How to Calculate Elapsed Time in Java
(Carlos Schults) Many things in programming sound like they should be easy, but are quite hard. Calculating elapsed time in Java is one of those. How hard could that be? As it turns out, it can be tricky.
TimeZoneNotFoundException in Alpine Based Docker Images
(Steve Gordon) In this post, we’re going to explore the cause of a TimeZoneNotFoundException in a .NET Core application, running on .NET Core 3.0 in an Alpine Linux Docker container.
Single Instance Applications in .NET
(Hannes DuPreez) Knowing when an application is already open is critical for some applications. Look, an application such as Notepad or Microsoft Word does not have to check for multiple instances, but applications working with data or high-memory intensive applications could benefit from a single i
How to Do Naive Bayes with Numeric Data Using C#
(James McCaffrey) The Naive Bayes technique can be used for binary classification, for example predicting if a person is male or female based on predictors such as age, height, weight, and so on), or for multiclass classification, for example predicting if a person is politically conservative, moder
How to integrate ProxySQL in MySQL InnoDB Cluster
(Frederic Descamps) MySQL InnoDB Cluster is the most easy and integrated High Availability solution for MySQL.
How to hang a server with a single ping, and other fun things we learned in a 18c upgrade
(savvinov) Every upgrade is a bit of a lottery. But for a long running, well established system with a lot of legacy code, it can be more of a Russian roulette.
Apache Traffic Server (ATS) Returning 403 For DELETE HTTP Requests
(James Coyle) Here is a quick snippet which solves an issue I ran into today. I’ve recently set up Apache Traffic Server to reverse proxy requests to various Docker containers. It all works great and runs itself in Docker.
Dataguard and LOG_ARCHIVE_MAX_PROCESSES
(Bryan Grenn) Any DBA who has set up Dataguard has seen this diagram of how the sending of logs to standby database works.
Capture Query Plans Using Extended Events and Traces – Analyzing SQL Server Query Plans – Part 1
(Pinal Dave) I recently released a Pluralsight Course Analyzing SQL Server Query Plans, and it is really doing great in terms of viewership and I have received some really great comments and feedback about this course. This week, I will be discussing different aspects of Analyzing SQL Server Query P