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 →

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 →

Security in the Database is more than Just Granting Access

Michelle Malcher on 06 March 2012 with 2 comments

Michelle Malcher (Oracle Ace Director and a representative on the Oracle Security Customer Advisor Council for the Independent Oracle User Group) presents practical ways to look at security and implementing standards and procedures around the database environment to account for the security outside of the users, including secured environments for regulations and compliance. Oracle 11g provides transparent data encryption at… Continue Reading →

Upgrading to Oracle 11gR2

Syed Jaffer Hussain on 05 March 2012 with 0 comments

It has been a common practice and relatively a tough task for almost every individual Oracle DBA to decide whether to proceed or not with the upgrade whenever Oracle releases new version. The core objective of this presentation is to share my experience of upgrading 4 Cluster environments with nearly 200 databases to Oracle 11gR2. The presentation is best suited… Continue Reading →

Applied Rapid Development Techniques for Database Engineers

Dominic Delmolino on 31 January 2012 with 2 comments

This article is based on the webinar delivered on 22 Nov 2011. You can read the full article below including the Q+A or: Download a PDF version Watch a video recording: Applied Rapid Development Techniques for Database Engineers In this article, Dominic Delmolino describes his experience in implementing a rapid refactoring and professional schema management process using standard software development… Continue Reading →

Webinars for Oracle Developers and DBAs

All Things Oracle on 29 September 2011 with 0 comments

Red Gate Software is working with a number of Oracle experts to develop a comprehensive webinar program to help support Oracle developers and DBAs. Five sessions have been confirmed, with topics ranging from performance tuning, database security, data encryption and APEX, giving you one session per month up until February 2012. But sessions won’t be limited to one per month;… Continue Reading →

My Case for Agile Development, Cary Millsap

Cary Millsap on 17 August 2011 with 2 comments

Cary Millsap (Oracle Ace Director, co-founder of the OakTable) explains how the principles of the Agile Manifesto have defined his most commercially and technically successful projects (specifically, the implementation of the Agile Manifesto called Extreme Programming (XP), as explained by Kent Beck). Watch a full video recording of the session, including the Q+A. Visit the Red Gate website for more… Continue Reading →