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 Database for Database Professionals Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used relational database management... 05 December 2024 12 min read 11
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
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
Oracle Aman Sharma in Oracle Understanding Oracle SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking Learn all about Oracle SQL bind variables: the potential issues surrounding bind variables and how to handle them.… 03 February 2017 8 min read
Oracle Aman Sharma in Oracle Understanding Oracle SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing In this third article, we will look at the issue of duplicate SQL statements and how Bind Variables can help... 20 January 2017 9 min read
