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.
2026-01-26
Oracle
Oracle Performance Tuning: Practical Techniques Every DBA Should Master
Here are a few things every Oracle DBA should know about performance in their databases.
2025-10-03
1,627 reads
Oracle Architecture Overview
In this document I will share an overview of Oracle’s architecture that isn’t complete, but it will give you a basic understanding of how the architecture works, especially if you are coming from other database platforms.
2025-01-24
SQL Server vs Oracle Query Statistics to Improve Performance
In this article, learn how to query cached query statistics and execution plans for Oracle or SQL Server to identify code that can be optimized to improve performance.
2023-07-21
The SELECT Statement in Oracle
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of criteria. In this article, I will introduce the basic SELECT statement fetching data from just one table.
2023-06-21
Oracle optimizer removing or coalescing subqueries
The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations involving subqueries.
2022-05-25
Why your PL/SQL needs to be testable – and how to do it: Part 1
Part 1: What is testable code, why is it important, and first glimpses on practices that can help
2022-04-27
Oracle subquery caching and subquery pushing
In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how to control where the optimizer positions each subquery.
2022-04-11
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 and NOT IN.
2022-03-18
Oracle ASM: Migrating from UDEV devices to the ASM Filter Driver
This article looks at the way in which you can convert unmanaged devices to the ASM filter drive in an Oracle system.
2022-03-04
4,535 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers