(Scott) This is part 2 of Db2 application tuning for Db2 Explains and db2advis. We are on a mission to make Explains and the Db2 Advisor faster and more efficient. PLEASE review PART 1 as a prerequisite so that the information flow is fresh in your mind before continuing.
Community
Java Logs: 4 Types of Logs You Need to Know
(Thorben Janssen) Logging is an important topic in software development, especially if you need to analyze bugs and other unexpected events in your production environment. Implementing your logging often seems easy.
Facade Design Pattern: Still relevant in ASP.NET Core?
(Adam Storr) In this tutorial, I will look to explain one of the simpler patterns – the Facade Design Pattern, how to implement it, and why it’s still relevant in modern development in ASP.NET Core.
Restoring And Resetting The Scroll Position Using The NavigationStart Event In Angular 7.0.4
(Ben Nadel) Earlier this year, I took a stab at making a polyfill for Angular 5 that would record and restore scroll-offsets as a user navigated forwards and backwards through a Single-Page Application (SPA).
Real-time Data Streaming with Event Hubs on Azure Government
(Yujin Hong) Azure Event Hubs is a managed Data streaming and Event Ingestion platform, capable of processing millions of events per second.
A Better Way to Test for Exceptions in Visual Studio
(Peter Vogel) I’ve always argued that the only easier way to test your code than using Visual Studio Test is to not test at all. But that doesn’t mean that I think Visual Studio Test is perfect.
A Tale of Two JSON Implementations – MySQL and MariaDB
(Dave Stokes) JSON has proven to be a very import data format with immense popularity. A good part of my time for the last two or so years has been dedicated to this area and I even wrote a book on the subject.
How do I add an image to a page in Oracle APEX?
(Joel R. Kallman) Preface: Many blog posts about Oracle APEX seem to cover a new feature or something rather obtuse & complex. The sophisticated blog posts have little relevance to someone who is completely new to APEX and Oracle Database. Having worked with APEX since 1999, it’s always difficult
External Tables
(Michael McLaughlin) Oracle Database 9i introduced external tables. You can create external tables to load plain text files by using Oracle SQL*Loader. Alternatively, you can create external tables that load and unload files by using Oracle Data Pump. This article demonstrates both techniques.
Partitioning — 12 : Data Dictionary Queries
(Hemant K Chitale) Here’s a compilation of some useful data dictionary queries on the implementation of Partitioning.