(Henrik Loeser) The SQL Query service on IBM Cloud allows to process data stored on Cloud Object Storage (COS) by writing SQL queries. So far, results were either shown in the console and / or written back to files on COS.
Other News
Microsoft Releases ‘Small and Short’ .NET Core 3.1
(David Ramel) Microsoft shipped .NET Core 3.1, described as a “small and short release” that focuses on two of the big features highlighting the Sept. 23 release of .NET Core 3.0: Blazor (for C# Web development instead of JavaScript) and desktop development (Windows Forms and Windows Presentation Fo
System Testing a REST API using C# and DalSoft Rest Client
(Darran Jones) In this post, we’re going to cover the recent extensions to the DalSoft RestClient library which allows you to easily test a REST API using C#.
Using MySQL’s Null-Safe Equality Operator With CFQueryParam’s Null Option In Lucee CFML 5.3.3.62
(Ben Nadel) The other day, I was in the middle of writing a “typical” conditional MySQL query that had special handling for NULL values when it suddenly occurred to me that I was doing more work than I had to. I don’t work with NULL values very often in SQL and ColdFusion; so, I fear that my instinc
Get started with method references in Java
(Jeff Friesen) Along with lambdas, Java SE 8 brought method references to the Java language. This tutorial offers a brief overview of method references in Java, then gets you started using them with Java code examples.
Managing Big Data with MySQL Can be Challenging
(Robert Agar) MySQL is an extremely popular open-source database platform originally developed by Oracle. It currently is the second most popular database management system in the world, only trailing Oracle’s proprietary offering.
Demographics vs Psychographics for Machine Learning
(Brendan Tierney) When preparing data for data science, data mining or machine learning projects you will create a data set that describes the various characteristics of the subject or case record. Each attribute will contain some descriptive information about the subject and is related to the targe
Oracle Database: Write arbitrary log messages to the syslog from PL/SQL
(Maarten Smeets) Syslog is a standard for message logging, often employed in *NIX environments. It allows separation of the software that generates messages, the system that stores them, and the software that reports and analyzes them.
My APEX and ATP Journey
(Debra Lilley) The big message from OOW was the Always Free Autonomous Database. Not normally of interest to me but I thought, I love the APEX community, (they were my first call out on community appreciation day in 2016).
SQL SERVER – Recompile Stored Procedures Two Easy Ways
(Pinal Dave) Recently while working with a large financial organization on Comprehensive Database Performance Health Check, I found an instance where stored procedure had a very incorrect execution plan cache. I told the DBA who was working with me to recompile the stored procedure so we have to bra