(Peter Zaitsev) I often need to install a certain version of MySQL, MariaDB, or Percona Server for MySQL to run some experiments, whether to check for behavior differences or to provide tested instructions.
Community
Introducing Oracle Cloud API Gateway – the light weight public or private router to public and private OCI endpoints
(Lucas Jellema) Two days ago, the API Gateway service on Oracle Cloud Infrastructure went live – read the announcement. This is a crucial component for many applications and in many solution designs. This new API Gateway is a prime candidate for example for inclusion in our reference architecture fo
R (ROracle) and Oracle DATE formats
(Brendan Tierney) When you comes to working with R to access and process your data there are a number of little features and behaviors you need to look out for.
Oracle Database 19c Automatic Indexing – Indexed Column Reorder (What Shall We Do Now?)
(Richard Foote) I previously discussed how the default column order of an Automatic Index (in the absence of other factors) is based on the Column ID, the order in which the columns are defined in the table.
SQL Server Function to Measure CPU Usage Per Database
(Eli Leiba) There comes a time when a DBA needs to know how much CPU resources each SQL Server database is using. This comes in handy in cases where you need to investigate high CPU usage on your SQL Servers or when you are just trying to understand the CPU heavy consumers on your server.
Add JavaScript and VBScript to Your .NET Apps
(honey the codewitch) I wanted to take a break from building parsers and such and do something a little different, so here’s a handy little library I’ve whipped up to add scripting support to your .NET applications.
RPG Academy: Database Modernization—Methodology, Part 4
(Rafael Victoria-Pereira) Normalization, explained in the first TechTip of this series, is more than just a theoretical concept. It’s time to put it to work in your database.
Previous SQL Server Updates
Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog about it for everyone. The question of the day is where can I download the previous SQL Server Updates?
Measuring Time: From Java to Kernel and back
(Jaromir Hamala) Even the most basic problems become interesting when you dig deep enough. Today, I would like to do a deep dive into measuring time in Java.
Use an API KEY or ACCESS TOKEN to connect to Db2 on IBM Cloud
(Henrik Loeser) In the past, I have blogged about how to access a Db2 database on IBM Cloud from your local machine. I cataloged the cloud host and its database. Then, connected to it using the command line processor (CLP) by passing a username and password.