Nick Celis

A valuable component in your APEX ECO-System

When working with APEX, you also need a number of tools to improve the efficiency of your work. It isn’t...

26 March 2013 2 min read

Dominic Delmolino

Bridging the Developer/DBA Divide: Advances in Database Source Control

For over 10 years now, I’ve been a huge advocate of integrating database development, design and architecture practices into application...

13 March 2013 7 min read

Jan Leers

Introduction to Table Partitioning

Divide and conquer is what Oracle was thinking with this one. Table partitioning is about optimizing “medium selectivity queries”. The...

07 March 2013 8 min read

Satishbabu Gunukula

Oracle Database Source Control made easy using Red Gate’s new tool

Red Gate is launching new tool “Source Control for Oracle tool” on March 12, 2013. How this tool can help...

01 March 2013 2 min read

Jonathan Lewis

Compression in Oracle – part 5: Costs of Index Compression

In the previous article in this series we looked at index compression, and the way in which Oracle stored index...

27 February 2013 13 min read

Jonathan Lewis

Compression in Oracle – part 4: Basic Index Compression

In the first three parts (Part 1: Basic Table Compression, Part 2: Read-Only Data, Part 3: OLTP Compression) of this...

13 February 2013 13 min read

Tim Gorman

What makes a DBA?

What skills set the database administrator (DBA) apart from other technologists? Of the many responsibilities laid upon a DBA, which...

07 February 2013 3 min read

Jonathan Lewis

Compression in Oracle – Part 3: OLTP Compression

In part two of this series we examined the effect of updates on compressed data when using basic compression, and...

31 January 2013 14 min read

Neil Anderson

Jonathan Lewis helps to optimize Red Gate’s Oracle tools

Speed, performance, optimization: time is of the essence when you’re waiting for an operation to complete. Our Oracle tools — Schema...

28 January 2013 7 min read

Jonathan Lewis

Compression in Oracle – Part 2: Read-Only Data

In part one of this series we saw that the mechanics of basic table compression came in to play only...

24 January 2013 13 min read

Randolf Geist

HAVING Cardinality

When performing aggregate GROUP BY operations an additional filter on the aggregates can be applied using the HAVING clause. Usually aggregates are one of...

21 January 2013 2 min read

Jonathan Lewis

Compression in Oracle – Part 1: Basic Table Compression

In this short series on compression in Oracle, we will be looking at the various types of compression used by...

15 January 2013 12 min read

Patrick Barel

Custom Authentication in APEX

Trust is a great force multiplier. – Tom Ridge When you build a web application you have two choices for...

09 January 2013 6 min read

Steve Harville

Automating and delegating datapump imports with PL/SQL

We recently bought another company and we are in the process of integrating our systems with theirs. One requirement was...

20 December 2012 2 min read

Marco Gralike

Solving VMware network problems on Linux VMware guests

When you use VMware Server software to move or clone VMware Linux guest machines, you are asked by the VMware...

19 December 2012 1 min read

Kellyn Pot'Vin-Gorman

Enterprise Manager Command Line Interface for EM12c

This video is a follow up to the webinar broadcast by Red Gate on 12 December 2012. Please leave a...

14 December 2012 2 min read

Wissem El Khlifi

11g Sql Plan Management

I have recently published an article about SQL Plan Management and some of its capabilities in 11g version of the...

10 December 2012 1 min read

Jonathan Lewis

Statistics in Oracle and SQL Server

This video is a follow up to the webinar broadcast by Red Gate on 12 December 2012. Please leave a...

10 December 2012 2 min read

Jan Leers

Code Instrumentation

Whenever we execute a procedure, it’s out of our hands. We expect it to do what it was designed to...

04 December 2012 5 min read

Gert Poel

Generating XML from SQL and PL/SQL – Part 2

In this second part I’ll show you how you can generate XML from table data in PL/SQL. …

29 November 2012 10 min read