Live, Rapid Dev Guided by Kscope12 Attendees

All Things Oracle on 17 May 2012 with 0 comments

Attendees to this year’s ODTUG Kscope conference will have the opportunity to get involved in a live software development experience on the Red Gate exhibition stand (stand no. 424 – 425). Attendees will provide input to go from zero to first prototype in 3 days through a series of rapid development sessions live on the stand. Monday’s feedback is Tuesday’s… Continue Reading →

Introduction to Oracle Flashback Technology (Part 1: Application Developers)

David Njoku on 16 May 2012 with 0 comments

Imagine, if you will, that someone invented time travel. What would you do with it? Nip back into the past and fix that error you made? And maybe you’d want to do something about that silly, ill-advised haircut you had when you were 17. Well, the good news is that, in a manner of speaking, time travel has been invented…. Continue Reading →

Oracle Heap Tables or SQL Server Clustered Indexes? Jonathan Lewis and Grant Fritchey Live Debate

Jonathan Lewis on 30 April 2012 with 0 comments

This webinar is being broadcast by Red Gate on 7 June 2012. Oracle and SQL Server may both share a common language, but certain things are handled quite differently. Jonathan Lewis (OakTable Network, Oracle Ace Director) is used to seeing heap tables (almost) everywhere, but Grant Fritchey (Microsoft SQL Server MVP) is used to seeing clustered indexes (almost) everywhere. But… Continue Reading →

How to Gather SQL Resource Consumption Metrics in Oracle

Karen Morton on 26 April 2012 with 4 comments

The following video and set of resources are from the webinar broadcast by Red Gate on 8 May 2012. The video above is accompanied by the following downloadable resources: Presentation slides (.pdf) Resource Consumption Metrics Examples (.txt) Workload Repository SQL Report (awrsqlrpt_1_16411_16412.html) SQL Monitoring Report (0-6x2sh0kvzac0t-2.html) ASH Report for BIUAT/biuat1 (ashrpt_1_0505_1117.html) Download all resources (.zip) SQL is utilized to return… Continue Reading →

Free eBook: Expert Oracle Database Architecture

All Things Oracle on 23 April 2012 with 0 comments

Download your FREE eBook Expert Oracle Database Architecture (Apress Media) provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world’s foremost Oracle experts, Thomas Kyte. This fully revised second edition covers the developments up to Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only… Continue Reading →

Real Developers DO use Tools

Cary Millsap on 19 April 2012 with 0 comments

This video is a recording from the webinar broadcast by Red Gate on 24th January 2012. You may’ve heard the idea that real developers don’t need tools, and the mark of a good developer is someone who can hand-code everything. But there are certain tasks where it doesn’t make sense to disregard using tools. In particular, critical tasks that need… Continue Reading →

Migrating Oracle Single Instance to RAC

Syed Jaffer Hussain on 17 April 2012 with 0 comments

This video is a recording from the webinar broadcast by Red Gate on 29th March 2012. Oracle Database administrators have to cope with numerous challenges when migrating an existing non-cluster environment to a cluster environment. One of the most significant challenges a DBA faces is to migrate/convert an existing single instance to RAC. Oracle provides several easy methods to carry… Continue Reading →

Oracle Cost-Based Optimizer Basics

Randolf Geist on 10 April 2012 with 0 comments

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 11 Apr 2012. The video above is accompanied by the following downloadable resources: Read me Presentation slides – PDF version Presentation slides – PowerPoint version Screenshots – Demo 1 (.pdf) Screenshots – Demo 2 (.pdf) Screenshots – Demo 3 (.pdf) optimizer_basics_inter_table_clustering_testcase.sql optimizer_basics_join_cardinality_testcase.sql… Continue Reading →

Building Apex Plugins 101

Martin Giffy DSouza on 28 March 2012 with 0 comments

Martin Giffy D’Souza has created some of the most popular plug-ins available on the APEX plug-in community page. He has learned a lot about the architecture and what it takes to make a robust plug-in. In this video, Martin will help get you started with creating your first APEX plug-in. He will also provide you with some tips and useful… Continue Reading →

APEX Plugin Competition

Peter Raganitsch on 28 March 2012 with 0 comments

The first ODTUG APEX Plugin Competition was launched on Tuesday March 27th 2012). This is a chance for everybody to submit their self created Plugins to get reviewed, judged and maybe win one of the many Prizes available. Plugins will be judged upon skill level of its creator. That means beginners and experts will not be in the same category,… Continue Reading →