8:00am - 9:00am

Keynote Address

Greg Keller & David Intersimone - Embarcadero

9:00am - 9:15am BREAK

9:15am - 10:00am

CASE STUDY: Establishing Data Modeling as a Service in BP
BP is a large federated organization with a diverse set of systems and data. This case study describes the four year journey BP embarked upon (and is still on) when establishing Data Modeling as a Service (DMaaS).

DOWNLOAD REPLAY NOW            WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Chris Bradley – IPL

10:00am -10:15am BREAK

10:15am - 11:00am

Sybase ASE Performance & Tuning: Best Practices
This session covers the fundamental concepts, recommendations, and problems of performance monitoring in Sybase ASE and how to utilize Embarcadero tools to facilitate the process.

DOWNLOAD REPLAY NOW            WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Harry Helal – Embarcadero

11:00am -11:15am BREAK

11:15am -12:00pm

Evolve or Die: Modeling Isn't Just for DBMS’s Anymore
Data Modeling has been around for 30 years. Its roots were firmly in the DBMS world. How many of you can remember implementing a DBMS on a tape-based system? But, in the intervening three decades the World has moved on.

DOWNLOAD REPLAY NOW            WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Chris Bradley – IPL

MID DAY BREAK

12:30pm -1:15pm

A Simple Approach to DB2 Index Redesign
This presentation reviews index structure and discusses a number of ways to redesign indexes without affecting application integrity. This presentation applies to all DB2 platforms and examples come from the presenter’s experience. The use of IBM’s Explain is also shown.

DOWNLOAD REPLAY NOW                                     WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Martin Hubel - Martin Hubel Consulting Inc.

1:15pm - 1:30pm BREAK

1:30pm -2:15pm

Bridging the Gap between Application and Database Developers
Most applications interact in some way with a database. This presentation demonstrates how Change Manager, RapidSQL and ER/Studio can help Delphi developers understand interactions between an application and a database and make it easy to quickly find and fix bugs in application code.

DOWNLOAD REPLAY NOW                                     WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Pawel Glowacki – Embarcadero

2:15pm - 2:30pm BREAK

2:30pm -3:15pm

Jumpstart your SOA Infrastructure with Data Models
The backbone of any SOA implementation requires defining, building, and managing XML schemas. Often times, this is done with very little visibility of the back end databases which ultimately results in a huge chasm between the data represented in the service bus and what is persisted in the database. This session shows you how to reverse that trend and drive XML schemas from your data models so they’re built with the same standards as your databases.

DOWNLOAD REPLAY NOW                                     WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Jason Tiret - Embarcadero

3:15pm - 3:30pm BREAK

3:30pm -4:15pm

Adding Content to the Enterprise Portal
Extend the capabilities of the Enterprise Portal with new reports and charts. The Enterprise Portal provides a great set of reports out of the box, but how do you extend this to satisfy you ever changing needs of users? During this session, learn how to create new reports and integrate them into the Enterprise Portal by using the same tools that were used to build the Enterprise Portal itself.

DOWNLOAD REPLAY NOW                                     WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Andy Grohe - Project Leadership Associates

4:15pm - 4:30pm BREAK

4:30pm -5:15pm

Building Database Applications with Delphi
This session shows database architects, database developers, and database administrators how simple it is to create database applications using Delphi 2009.

David Intersimone - Embarcadero

8:00am - 8:45am

Building a Repository of Database Changes
Learn to write a plug-in for Change Manager to populate a database repository of comparison results when running schema and configuration comparisons. See how to setup comparisons, schedule them, and then query a repo to see what’s changed and see example views to get useful and concise difference information.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Gordon Lucas - Embarcadero

8:45am - 9:00am BREAK

9:00am - 9:45am

Integrating Advanced Model Lifecycle Management with the Enterprise Repository & MS SharePoint
In large environments, the integration of data modeling into the entire life cycle is important. The intellectual knowledge that is invested in well designed data models is not simply of use by database developers. When enterprise, conceptual, and logical data models are used in an effective information management framework, business users and technical users can leverage the information contained within them.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Nic Paul – IPL

9:45am -10:00am BREAK

10:00am - 10:45am

Comparing Generalized and Detailed Approaches to Data Modeling
Some data modelers prefer large models with many, highly detailed entities. Others prefer small models with a handful of highly generalized entities. Each approach has merit, but combining them in a best-of-both-worlds approach is so difficult, most modelers give up and declare themselves to be in one camp or the other. In this presentation, Burton Group Senior Analyst catalogs the relative merits of the two approaches and describes why one approach is highly desirable, but the other approach is absolutely indispensible.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Joe Maguire - Burton Group

10:45am -11:00am BREAK

11:00am -11:45am

Managing Reference Data and Codes with ER/Studio & Change Manager
In this presentation, Karen Lopez demonstrates tools and techniques for managing reference data and codes using ER/Studio and Change Manager, including 10 success tips for keeping models and code values in sync.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Karen Lopez - InfoAdvisors

MID DAY BREAK

12:30pm -1:15pm

MassMutual's SQL Preprocessing Efficiencies
Dan Lukasik of MassMutual explains the efficiencies that have been realized using preprocessor directives in SQL Code. He reviews how MassMutual uses the directives and provides examples that have been proven to not only save developers time, but also result in error-free code.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Dan Lukasik – MassMutual

1:15pm - 1:30pm BREAK

1:30pm -2:15pm

Using Database Tools to Meet Information Security Requirements
This session covers tagging of data assets per regulatory requirements (for example: FISMA, HIPAA, etc.) and shows how DSAuditor reports on who accessed the data.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Raul Gutierrez - Embarcadero & Ron Lewis - CDO Technologies, Inc.

2:15pm - 2:30pm BREAK

2:30pm -3:15pm

Getting the Most from JBuilder and Rapid SQL Developer
You are a Java developer and you need to write or work with SQL. What tools can help you get your job done faster and better than before? What about JBuilder 2008 R2 and Power SQL 2.0 -- Two products that work well together and add great value to the developer's tool chest? Learn how to use these two products together successfully.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Michael Rozlog – Embarcadero

3:15pm - 3:30pm BREAK

3:30pm -4:15pm

Intermediate SQL
Just beyond the basics of SQL, this session covers views, constraints, functions, aggregates and more. Nothing too advanced, but a good building on the basics.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Jim McKeeth - WideOrbit / Podcast at Delphi.org

4:15pm - 4:30pm BREAK

4:30pm -5:15pm

Using InterBase Encryption
This session covers how to use the new encryption feature of InterBase using IBConsole and ISQL.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Jerry Barnes – Embarcadero

8:00am - 8:45am

Multi-tier Database Applications with Delphi 2009
This session provides an introduction to the Delphi 2009 renewed DataSnap architecture that let's you create multi-tier applications in an easy, RAD way delivering power and flexibility for your remote, zero-configuration, client applications.

DOWNLOAD REPLAY NOW                                  WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Marco Cantu - WinTech Italia Srl

8:45am - 9:00am BREAK

9:00am - 9:45am

Writing Unit Tests for SQL Databases using Delphi
Writing unit tests for client/server applications accessing a database on a SQL server is more complex than writing tests for stand-alone applications due to the fact that the resulting state of the system is not a value returned by every function, but it is stored in the database and must be retrieved in a more complex way. Even if Delphi does not ship with a tool specifically designed to test SQL databases, with some coding work it is possible to use DUnit framework to write, not only tests for classes working on the DB, but also for stored procedures on the server. It is also possible to extend DUnit so that DB developers and testers can effectively write tests without the need for deepening their knowledge of Delphi syntax and class libraries, focusing on their main task of writing SQL code.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Giacomo Degli Esposti - Optima s.r.l

9:45am -10:00am BREAK

10:00am - 10:45am

ER/Studio Macro Mania
Ever wondered what all those macros do, but never had time to investigate? This session provides detailed explanations and examples of each macro available in ER/Studio 8.0. Join us and watch the macro madness unfold!

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Brent Hansen – Embarcadero

10:45am -11:00am BREAK

11:00am -11:45am

Managing Database Security and Compliance
This session showcases Embarcadero’s product to assist users in managing database security and compliance. In speaking with customers today, the reoccurring theme of consolidation managing complex environments a #1 priority. These complex environments represent multiple OS, database platforms, third party applications, and ever evolving data warehouses. Although the paradigm is mind boggling, Embarcadero offers tools that can assist to simply automate and report on these strict rules and regulations.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Brent Hansen – Embarcadero

MID DAY BREAK

12:30pm -1:15pm

Five Classic Data Modeling Mistakes & How to Avoid Them
We’ve all been there: a shortcut here, a compromise there, an overmodeling over there. In this presentation, Karen Lopez demonstrates five classic and all-too-common data modeling mistakes that are easy to make and yet just as easy to avoid.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Karen Lopez - InfoAdvisors

1:15pm - 1:30pm BREAK

1:30pm -2:15pm

The DBX Architecture in Delphi
This session covers the basics of the TClientDataSet Provider Architecture and how it's used by DBX. Learn how to use the components both visually and in code. The session also covers the common needs of a database application and how DBX provides solutions to meet these needs.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Robert Love - State of Utah

2:15pm - 2:30pm BREAK

2:30pm -3:15pm

Data Mashups in Web 2.0
How do we make data available to the Web 2.0 world? Come and see database data surfacing in Google Maps, home page gadgets and widgets, Google Apps spreadsheets, and even Facebook.

DOWNLOAD REPLAY NOW                                      WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Marco Cantu - WinTech Italia Srl

3:15pm - 3:30pm BREAK

3:30pm -4:15pm

Working with Data Using ADO.NET
Microsoft documentation for ADO.NET 2.0 (and later versions) emphasizes the use of data source objects for data access. These objects, however, hide the real worker classes in ADO.NET, including connections, commands, data readers, command builders, and data tables. This presentation discusses the roles of these important classes and demonstrates how to use them directly in your .NET applications.

DOWNLOAD REPLAY NOW                                     WATCH REPLAY NOW

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!!

Cary Jensen - Jensen Data Systems

4:15pm - 4:30pm BREAK

4:30pm -5:30pm

Closing Keynote

Greg Keller, Michael Swindell, Jan Liband, & David Intersimone – Embarcadero

Change Manager™

DBArtisan®

DB Optimizer™

ER/Studio®

Performance Center™

Rapid SQL®

Delphi®

InterBase®

JBuilder®