Gerald Venzl

JSON and Relational Tables: How to Get the Best of Both

JSON and relational tables have their strengths and drawbacks. How can you best harness those strengths in your work, while offsetting the drawbacks?

We are pleased to announce the publication of the new SQL Standard version by the International Standards Organization (ISO), SQL:2023,

Yesterday ISO published the new SQL:2023 Standard, making that day a special day for me as this is the first

Last week I got pinged with an interesting question by a user: why do I see kpolnb: Logon failed because

I got a couple of Raspberry Pis lying around at home and thought, what better use for one of them

I got an interesting question the other day: “which Oracle Database Parameters are PDB-modifiable?”, i.e., which parameters can have different

Oracle Database 23c Free – Developer Release is a new, free offering of the industry-leading Oracle Database that enterprises worldwide rely on every

Have you ever encountered a situation when you were in the middle of writing a SQL query and thought, “if

If you have your website running behind an NGINX Reverse Proxy, you may be wondering how you can enable HTTPS

If you want to auto-mount an NFS share during boot time, you may run into the issue that by the

By default, WordPress stores revisions for all your posts when you draft or update them. It’s a useful feature when

About two years ago I introduced a couple of free sample data sets on GitHub (https://github.com/gvenzl/sample-data). You can read the