(lukaseder) When using jOOQ to create dynamic SQL statements (one of jOOQ’s core value propositions), it is often necessary to add query elements conditionally, with a default “No-op” behaviour.
Author: SSWUG Research
PART 4: Implementing Oracle Database Single Sign-On Using Kerberos, Active Directory, And Oracle CMU
(Simon Pane) This is the fourth and final article in a four-part series related to testing Oracle Database 18c Centrally Managed Users (CMU) by leveraging the Oracle Cloud Infrastructure (OCI) for Oracle DBAs to create a lab or testbed.
network ip calculation with ifconfig
(Laurent Schneider) Most *nix are different. I’ll start with a plain Linux output
12.2.0.1 vs. 18.9 Data Dictionary Changes
(Liron Amitzi) In this post I’ll compare the Data Dictionary tables and columns between 12.2.0.1 and 18.9.
Change the size of the grid results view in SSMS
(Kenneth Fisher) After my post last month about configuring your tools I’ve been on a make my life easier kick and one of the things that gives me grief every day is that my eyesight is at best mediocre and some days it’s worse than others.
Collation Conflict with Extended Events
(Jason Brimhall) Have you ever run into an error like this? Cannot resolve the collation conflict between “pick a collation” and “pick another collation” in the equal to operation.
Dealing with a No NULL Requirement for Data Modeling in SQL Server
(K. Brian Kelley) I am working with a system that doesn’t allow for NULLs in the SQL Server data model. However, I have clear cases where I’m missing information. For instance, I’m dealing with building out our academic system into a new platform and we have columns for final grade in a course as we
MySQL Group Replication and its Memory consumption (troubleshooting).
(Vignesh Prabhu) This blog is about one of the issues encountered by our Remote DBA Team in one of the production servers. We have a setup of MySQL 5.7 Single Primary (Writer) GR with cluster size of 3 .
Using Subtraction To Power The Array Sort Comparison Operator In Lucee CFML 5.2.9.31
(Ben Nadel) Yesterday, while looking at generating color histograms using GraphicsMagick and Lucee CFML, I had to sort of an Array of colors based on their frequency distribution within an image.
GitHub to acquire NPM JavaScript package registry
(Paul Krill) Microsoft-owned GitHub has signed an agreement to purchase JavaScript package registry provider NPM, with plans to integrate the two platforms and move the private NPM packages of paying NPM customers to the GitHub Packages registry.