Sachin Pawar in Cloud DMS migration failing? How to debug Oracle to Cloud SQL network errors, layer-by-layer (OSI model guide) Debugging Google DMS failures for Oracle to Cloud SQL migrations? Use the OSI model to pinpoint network errors layer by... 01 July 2026 13 min read 21
Chisom Kanu in Databases It’s 2026. Why are databases still failing GDPR compliance audits? GDPR erasure failures are often database engineering problems, not legal ones. Learn how relational schema design, backup retention, and audit... 11 June 2026 13 min read 1
Kellyn Pot'Vin-Gorman in Oracle Why migrating from Oracle is harder than anyone admits – and what you should do instead Oracle-to-Postgres migrations routinely go over budget — not because of schemas, but because of DBMS_* packages. Learn what breaks, why... 03 June 2026 19 min read 32
Simple Talk Editor in Databases What are the top database platforms in 2026? A look at the latest data Explore 2026 database market trends: AWS, Microsoft, Oracle, and Google Cloud Platform remain dominant as MongoDB, Snowflake, and Databricks steadily... 28 April 2026 6 min read 4
Greg Low in Databases How to Create a SQL Server Linked Server to Oracle 26ai Free Easily move data from SQL Server to Oracle 26ai Free with this step-by-step guide. Learn how to set up a... 05 January 2026 4 min read 2
Jim Czuprynski in Databases How to Create Uber-Fast Maps With Oracle 23ai Vector Tiles and H3 Indexes (Part 2) Discover how to build ultra-fast mapping applications using Oracle Database 23ai’s new vector tile and H3 hexagonal indexing features. Part... 17 November 2025 15 min read 21
Jim Czuprynski in Oracle Creating Uber-Fast Maps With 23ai Vector Tiles and H3 Indexes: Part 1 Oracle Database 23ai added 300+ new features like the new VECTOR datatype that get most of the attention, but often... 08 July 2025 13 min read 11
Kellyn Pot'Vin-Gorman in Oracle Oracle ASM: Monitoring and Managing (Part 2) In the first part of this series, we explored the fundamentals of Oracle Automatic Storage Management (ASM)—a powerful volume manager... 20 June 2025 5 min read 1
Kellyn Pot'Vin-Gorman Oracle ASM: A Simple Solution or Another Complexity? (part 1) For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure complexity grows with... 05 June 2025 6 min read
Kellyn Pot'Vin-Gorman in Oracle Oracle’s Limited Cloud Vendor Licensing It’s nothing new for vendors to find ways to lock in customers to their products and cloud services. Oracle recently... 15 April 2025 3 min read 21
Kellyn Pot'Vin-Gorman What is Oracle RAC and Why Use it for Scaling Workloads? Oracle Real Application Clusters (RAC) is a database clustering solution that enables multiple servers to operate as a single, unified... 10 February 2025 6 min read 1
Kellyn Pot'Vin-Gorman in Oracle Oracle Architecture Overview I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but... 02 January 2025 24 min read 331
Kellyn Pot'Vin-Gorman in Oracle Introduction to Oracle: Key features, architecture, and getting started with 23ai Oracle Database is a powerful enterprise RDBMS built for scalability, security, and high availability. Learn its architecture, key features, and... 05 December 2024 12 min read 211
Oracle Jonathan Lewis in Oracle Oracle Or-Expansion Transformation: How the Optimizer Rewrites OR Predicates into UNION ALL for Index Access Oracle's Or-Expansion transformation - how the cost-based optimiser rewrites queries containing OR predicates into UNION ALL branches that can each... 26 October 2022 16 min read
Oracle Jonathan Lewis in Oracle The effects of NULL with NOT IN on Oracle transformations IN and NOT IN subqueries are frequently used in Oracle. Jonathan Lewis explains how the optimizer handles NULL with IN... 22 February 2022 11 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Oracle Text Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in... 30 August 2021 12 min read
Oracle Jonathan Lewis in Oracle Oracle sequences – 12c features including “identity” Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how... 19 August 2021 16 min read
Oracle Jonathan Lewis in Oracle Oracle archived redo size – the research Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes... 11 January 2021 15 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
