The Developer-DB Love-Hate Relationship
There’s a reason why database administration or engineering remains a separate specialty. There are a large number of rabbit holes…
Accelerating Your Db2 Database
Your Db2 database The IBM mainframe and its Db2 database is the transaction processing workhorse for the world’s biggest banks,…
Db2 for z/OS EXPLAIN: What an Access Path Is, and What it Would Be
The EXPLAIN functionality of Db2 for z/OS, by which the query optimizer’s access path determinations are externalized, has been around…
Db2 12 for z/OS Buffer Pools – Recommendations for PGSTEAL, PGFIX and FRAMESIZE
Not too long ago, I received a note from the leader of a Db2 for z/OS database administration team, asking…
Removing Duplicates From a List in Elixir
Thanks to the Enum module, in Elixir we can trivially remove duplicates from a list. In the following example, we…
Developing with Elixir/OTP Course Review
Ruby was the first programming language I truly fell in love with. Yes, I had used several others before (and…
Sorting Results by Specific Values in SQL with CASE
Recently I rewrote the backend for my service, Any New Books, due to an Amazon API change. Generally speaking, rewriting…
4 Tech Innovations That Could Change Smartphones
Smartphones have gotten so advanced today that it can almost be hard to tell the difference between the top options.…