Oracle Cynthia Dzikiti in Oracle Why choose Oracle? Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career... 28 September 2020 11 min read
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
Tools Dino Esposito in Tools How We Ended up with Git Git is used by many teams for version control. In this article, Dino Esposito takes a look back at the history of source control and... 10 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 troubleshoot errors as a new... 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 security aspects of ERP systems... 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 perform better than others. In... 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 refrain from the EU in... 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 unit tests to your database... 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 the source code. Defining these... 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, such as web-based shopping apps.... 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 a burglar and clamber in... 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 earlier forms of this architecture,... 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 JSON from your Oracle database.... 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 or so of dabbling with... 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 situations where degenerated indexes might... 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 database running on one node... 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 their importance in regard to... 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 clothing – varchar2, clob, float,... 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, and tell them you’ll read... 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 database itself, in order to:... 25 January 2017 9 min read
