Oracle Kellyn Pot'Vin-Gorman in Oracle What is Oracle ASM to Azure IaaS? Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS.… 14 September 2020 11 min read
Oracle David Njoku in Oracle Oracle for Absolute Beginners: Problem-Solving as a New Developer Learning programming logic and syntax is just the beginning. In this article, David Njoku talks about how to debug and... 30 April 2019 9 min read
Oracle Cynthia Dzikiti in Oracle Security Considerations for ERP Applications Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the... 01 April 2019 16 min read
Oracle Ben Brumm in Oracle 10 Best Practices for Writing Oracle SQL There is often more than one way to write a query that returns the same results, but some methods may... 30 August 2018 13 min read
Oracle Mike Smithers in Oracle utPLSQL 3.0 – How To Have Your Cake and Eat It This article was originally published on mikesmithers.wordpress.com. “You can’t have your cake and eat it!” This seems to be a regular... 08 May 2018 27 min read
Oracle Samuel Nitsche in Oracle Strongholds of Confidence: Self-Testing Your Database Unit testing and even Test-Driven Development is possible for databases. In this article Samuel Nitsche makes the case for introducing... 04 April 2018 17 min read
Oracle Nick Buytaert in Oracle Validating naming conventions in Oracle Most development teams have agreed upon some sort of naming convention as it typically increases the readability and comprehension of... 20 February 2018 8 min read
Containers and Virtualization Anand Joshi Yogesh Bhate in Containers and Virtualization Overcoming the Challenges of Microservices and Docker Containerisation A microservice architecture can provide great benefits to certain types of applications that have pronounced troughs and peaks in demand,... 19 September 2017 22 min read
David Njoku Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles I accidentally locked myself out of my house this evening, and so I had to climb up the wall like... 01 March 2017 11 min read
Aman Sharma Getting started with Oracle Database 12c Multitenant Architecture Oracle database, since its inception, has always used a very specific and unique architecture which served it very well. In... 22 February 2017 15 min read
David Njoku JSON For Absolute Beginners: Part 6 – Generating JSON post-12c Release 2 In this sixth and final installment in this introductory series on JSON I’d like to revisit the question of generating... 22 February 2017 6 min read
David Njoku Oracle for Absolute Beginners: Data Types All databases stand on a tripod of datatypes: strings, numbers and dates. And so I’d imagine that by Day 2... 15 February 2017 11 min read
Houri Oracle Partitioned Index Efficiency PartitionedIndexEfficiency Although it is generally true that rebuilding an index represents a waste of time and resources, there nevertheless exist... 09 February 2017 10 min read
Anju Garg Policy-Managed Oracle RAC One Node Databases Oracle RAC One Node, introduced in Oracle Database 11g Release 2 (11.2.0.2), is a single instance of an Oracle RAC-enabled... 09 February 2017 13 min read
Aman Sharma Understanding SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking In the 3rd part of this series, I introduced you to the concept of the bind variables. We also learned... 03 February 2017 8 min read
David Njoku Oracle for Absolute Beginners: Date, Timestamp and Interval All databases stand on a tripod of datatypes: strings, numbers and dates. And though they might dress them in fancy... 02 February 2017 12 min read
David Njoku Oracle for Absolute Beginners: Other SQL Functions Here’s a simple trick you can play on your friends. Ask them to pick a number from 1 to 10,... 30 January 2017 8 min read
Anju Garg Duplicate Point-In-Time Recovered PDB Using Backup At times, we might need to duplicate a production pluggable database to a Past Point in Time without disturbing the production... 25 January 2017 9 min read
Jonathan Lewis Snapshots While looking at the results from a query against the dynamic performance view v$active_session_history during a recent trouble-shooting assignment I... 24 January 2017 11 min read
Jonathan Lewis Index Costing Threat In the previous post I described a problem with the strategy that the optimizer uses for costing an index fast... 24 January 2017 9 min read