Video

Category

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 30 August 2012. Watch video The video above is accompanied by the following downloadable resources: Presentation slides Scripts featured during the presentation (uploaded to dbakevlar.com) Summary Since their introduction with Oracle 10g, AWR and ASH data has offered the Database professional enhanced… Continue Reading →

Database Administration, Database Development, Oracle Database, Video, Webinar

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 01 August 2012. You may want to watch Oracle Cost-Based Optimizer Basics before you view this video Watch video The video above is accompanied by the following downloadable resources: Read me Presentation slides – PDF version Presentation slides – PowerPoint version concurrent_execution_inserts_check_results.sql… Continue Reading →

Database Development, Oracle Database, Performance Tuning, Video, Webinar

The following video and set of resources are from the webinar broadcast by Red Gate on 03 July 2012. Watch video Key performance analysis and tuning principles apply regardless of the version of Oracle you’re using, but the Oracle 10g Diagnostics Pack instrumentation and related OEM Performance Pages built on these principles to offer a new, more visual, performance analysis… Continue Reading →

Application Development, Database Administration, Database Development, Oracle Database, Video, Webinar

The following video and set of resources are from the webinar broadcast by Red Gate on 21 June 2012. Watch video SQL and PL/SQL are deceptively simple, user-friendly languages, which is great for productivity, but also makes it relatively easy to write bad, non-scalable code. Certain features, in particular, seem to sound an irresistible siren call into a world of… Continue Reading →

Database Administration, Database Development, Oracle Database, Performance Tuning, Video, Webinar

The following video and set of resources are from the webinar 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… Continue Reading →

Database Administration, Database Development, Video, Webinar

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 →

Database Development, Oracle Database, Performance Tuning, PL/SQL, Video, Webinar

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 →

Database Development, Performance Tuning, Video, Webinar

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 →

Database Administration, Database Development, Oracle Database, Troubleshooting, Video, Webinar

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 11 Apr 2012. Watch video 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)… Continue Reading →

Database Administration, Database Development, Oracle Database, Performance Tuning, Video, Webinar

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, Application Development, Database Development, Oracle Database, Video