(Joel R. Kallman) Firstly, this post has nothing to do specifically with APEX. It has everything to do with date conversions in Oracle SQL and how to convert them to a different time zone.
Author: SSWUG Research
APEX 19.2 upgrade quick tip: run check_lovs_for_errors.sql
(Sven Weller) The APEX 19.2 readme includes info about a small script check_lovs_for_errors.sql that one should run after the upgrade. It is very easy to overlook this in the readme files.
Never Concatenate Strings With jOOQ
(lukaseder) jOOQ supports a vast amount of SQL syntax out of the box. As such, most users will not think of resorting to string concatenation like in the old days when writing dynamic SQL with JDBC.
#PowershellBasics: Run a file and pass it a parameter.
(Kenneth Fisher) I realized in my last #PowershellBasics post that I was talking about running a file and passing in an optional parameter but I didn’t describe how to do it. I decided that it was a distinct enough task that I’d make it it’s own post, so here we go.
SQL AS keyword overview and examples
(Esat Erkec) SQL AS keyword is used to give an alias to table or column names in the queries. In this way, we can increase the readability and understandability of the query and column headings in the result set.
Throttling Outgoing Requests in Node.js
(Kamran A) Coordinating counting requests within a time window across a cluster can’t be done in-memory, you need a backing store and this article walks through using Node.js and RavenDB to accomplish throttling client-side requests to an API so you don’t exceed rate limits.
SQL Server Attach and Detach Database Examples
(Dinesh Asanka) How do you attach and detach databases in SQL Server? What is the difference between a SQL Server backup and restore vs. detach and attach?
How to Measure MySQL Performance in Kubernetes with Sysbench
(Vadim Tkachenko) As our Percona Kubernetes Operator for Percona XtraDB Cluster gains in popularity, I am getting questions about its performance and how to measure it properly.
SQL 101: Using ILE RPG Programs and Procedures as SQL Stored Procedures, Part 1
(Rafael Victória-Pereira) PSM stands for Persistent Storage Module. In short, it’s the language used to write “SQL programs.” I’ll delve into PSM with much greater detail later in this series, but for now, let’s just focus on what forms these SQL programs, or SQL routines as they are more commonly c
Exploring The Triple Equals (===) Operator In Lucee CFML 5.3.4.77
(Ben Nadel) A few weeks ago, I created a function that proxies the dump() function, making it safe for complex objects that may include circular-references.