49 articles from my previous blog grouped by theme
Functional Testing (5)
- Oracle PL/SQL API Demos Github Module (2019-11-13)
- Oracle and JUnit Data Driven Testing: An Example (2016-11-13)
- A Note on Dependencies and Database Unit Testing (2016-08-06)
- A Template Script for JDBC Integration Testing of Oracle Procedures (2016-05-14)
- Design Patterns for Database API Testing (2016-05-08)
- DBAPIT 1: Web Service Saving (2016-05-08)
- DBAPIT 2: Views (2016-05-21)
- DBAPIT 3: Batch Loading of Flat Files (2016-09-24)
- DBAPIT 4: REF Cursor Getter (2016-10-01)
Performance Testing (5)
- Dimensional Benchmarking of SQL Performance (2016-11-06)
- DIMBEN 1: Oracle v10-v12 Queries for SQL Bursting Problems (2016-11-06)
- DIMBEN 2: General SQL Bursting Problems (2016-11-26)
- DIMBEN 3: Bracket Parsing SQL (2017-02-05)
- DIMBEN 4: SQL for Fixed-Depth Hierarchies (2017-03-05)
- DIMBEN 5: Hash Join Options in SQL for Fixed-Depth Hierarchies (2017-03-05)
- DIMBEN 6: String Splitting SQL (2017-03-12)
- DIMBEN 7: Oracle DML: A Case Study I - Update vs Merge, An Example (2017-09-24)
- DIMBEN 8: Oracle DML: A Case Study II - Effects of Indexes (2017-09-24)
- A Note on Oracle Join Orders and Hints (2016-07-17)
- Code Timing and Object Orientation and Zombies (2016-05-07)
- Low-Hanging Fruit: The Classic Performance Tuning Anti-pattern (2014-07-28)
- PL/SQL Profiling (2013-03-05)
- PLSPRF 1: Hierarchical Profiler (2020-06-28)
- PLSPRF 2: Flat Profiler (2020-06-28)
- PLSPRF 3: Custom Code Timing (2020-06-28)
Design (11)
- Oracle User Group Ireland Presentations (2023-10-22)
- SQL Developer: Importing Unit Test Repository via Data Modeler (2015-07-11)
- Query Query Query (2014-09-03)
- NoCOUG SQL Challenge 2014 Illustrated (2014-08-25)
- Brendan's 2-Page Oracle Programming Standards (2014-05-24)
- Messages from Outer Space (2013-10-15)
- SQL and Modularity: Patterns, Anti-Patterns and the Kitchen Sink (2013-09-08)
- Query Structure Diagramming (2012-08-11)
- A Layered Approach To Processing XML Web Services (2012-02-05)
- Data Modelling of XML SOAP Documents (2012-01-29)
- Data Structure Diagramming (2012-01-21)
Recursive SQL (11)
- Knapsacks and Networks in SQL (2017-12-03)
- Recursive SQL for Network Analysis, and Duality (2015-09-02)
- PL/SQL Pipelined Function for Network Analysis (2015-05-10)
- SQL for Shortest Path Problems 2: A Branch and Bound Approach (2015-05-04)
- SQL for Shortest Path Problems (2015-04-19)
- SQL for Length-Controlled List Aggregation (2013-08-17)
- SQL for the Travelling Salesman Problem (2013-07-14)
- SQL for the Balanced Number Partitioning Problem (2013-05-25)
- SQL for Network Grouping (2013-03-23)
- An SQL Solution for the Multiple Knapsack Problem (SKP-m) (2013-01-20)
- A Simple SQL Solution for the Knapsack Problem (SKP-1) (2013-01-06)
General SQL (13)
- Analytic and Recursive SQL by Example (2020-02-14)
- A Note on Running Sums and Products in SQL (2020-01-19)
- Extracting Pure Functionality from SQL Queries (2018-10-29)
- On RDBMS, SQL and the DRY Principle, and Query Networks (2018-09-02)
- A Utility for Reading REF Cursors into a List of Delimited Strings (2016-08-09)
- SQL for Continuum and Contiguity Grouping (2013-11-16)
- Design Patterns for Extracting Relational Data from XML (2013-04-21)
- Master-Detail Transaction Reconciliation in SQL (MDTM3) (2012-10-26)
- Holographic Set Matching in SQL (MDTM2) (2012-10-12)
- Master-Detail Transaction Matching in SQL (MDTM1) (2012-10-10)
- List Aggregation in Oracle - Comparing Three Methods (2012-09-30)
- Grouping by Unique Subsequences in SQL (2012-09-08)
- Case Expressions and Ignoring Nulls in Analytic Functions (2012-01-15)
Oracle eBusiness (4)
- Unix Snippets for Handling Duplicate Keys in Delimited Input Files (2014-11-30)
- A Generic Unix Script for Uploading eBusiness Concurrent Programs (2014-09-28)
- Design Patterns for Database Reports with XML Publisher and Email Bursting (2014-09-20)
- A Design Pattern for Oracle eBusiness Audit Trail Reports with XML Publisher (2014-08-31)