DataRage 2009 Replays

By: Michael Findling

Abstract: DataRage is three days of 100% online technical sessions focused on database development and data management issues which you can attend from wherever you like to log in. It’s bringing you top industry speakers, technologists, and industry practitioners to present on a wide variety of database-related topics, a raging confluence of conveniently-delivered information you can’t get anywhere else.

    DataRage Sessions & Replays

AM USCA 0903 REG DATARAGE FUP HEADER


Now that you’ve seen all the sessions, check out our products by downloading a 
Free Trial or Buying Online.

    Watching Session Replays:

Click on any “WATCH REPLAY NOW” links in order to view them. Don’t have an EDN Account? Sign Up now! It’s easy and FREE!

ERStudio ER/Studio

ERStudio

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!

With Brent Hansen of Embarcadero Technologies

WATCH REPLAY NOW

 

ERStudio

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).

With Chris Bradley of IPL

WATCH REPLAY NOW

 

ERStudio

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.

With Chris Bradley of IPL

WATCH REPLAY NOW

 

ERStudio

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.

With Jason Tiret of Embarcadero Technologies

WATCH REPLAY NOW

 

ERStudio

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.

With Andy Grohe - Project Leadership Associates

WATCH REPLAY NOW

 

ERStudio

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.

With Nic Paul of IPL

WATCH REPLAY NOW

ERStudio

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.

With Joe Maguire of the Burton Group

WATCH REPLAY NOW

 

ERStudio

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.

With Brent Hansen of Embarcadero Technologies

WATCH REPLAY NOW

 

ERStudio

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.

With Karen Lopez of InfoAdvisors

WATCH REPLAY NOW

 

ERStudio

Universal Data Models and Patterns: Developing Higher Quality Data Models in Less Time

Learn how Universal Data Models and Universal Patterns can help your organization reduce development time on new projects and facilitate standardization of existing data models, presented by renowned author and data modeling expert, Len Silverston.


WATCH VIDEO NOW

ERStudioExploring the Data Dictionary in ER/Studio Enterprise

This session will take an in depth look into the data dictionary system of ER/Studio and how it can benefit data architects and their models.  The attendees will come out of this session with a deeper understanding of domains, attachments, reference values and the enterprise data dictionary system as a whole.  They’ll be able to take their modeling to an entirely new level of productivity.

With Jason Tiret of Embarcadero Technologies


WATCH VIDEO NOW

 

ERStudioMaking Sense of the Mess: Building & Publishing a Data Dictionary

Standardizing data across the organization lowers the cost and effort of data integration, reporting, and warehousing tasks and raises the reliability (i.e., the validity of) data sets and report data. But, how do you ensure that in today’s world of fast paced, distributed development, data definitions are consistent, valid, and reliable? The answer lies in creating a data dictionary. In order to be successfully adopted, the data dictionary must not only be complete and specific to the organization, but must be easy to access and search. This session describes the process of analyzing existing data structures, of integrating stakeholders in order to agree upon a common set of definitions, and of publishing a data dictionary in an easily accessed, Web format.

With Solomon Waters of Embarcadero Technologies
WATCH VIDEO NOW

 

ER/Studio and Change Manager

Change ManagerERStudio

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.

With Karen Lopez of InfoAdvisors

WATCH REPLAY NOW

Change Manager and JBuilder

JBuilder Change Manager

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.

With Gordon Lucas of Embarcadero Techologies

WATCH REPLAY NOW

 

DBArtisanDBArtisan

DBArtisan

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.

With Martin Hubel of Martin Hubel Consulting Inc.

WATCH REPLAY NOW

DBArtisan Short Subject Videos:

 

DB Optimizer DB Optimizer

DB OptimizerDB Optimizer: Powerful Simple Database Performance Solutions

Identifying the root cause of a performance issue can be difficult or practically impossible using standard tools. Even if the root cause is found, the next step to finding a solution can prove almost as hard. DB Optimizer solve these issues. DB Optimizer can identify, in seconds and with ease, the root causes for database performance issues. DB Optimizer empowers the user to see database load in the blink of an eye, quickly see anomalies and performance issues, and drill down to the root of the problem. Problems will be clearly identified as machine, database configuration, application design, or SQL optimization issues.  If SQL has optimizations issues, DB Optimizer will parse the query and look through hundreds of options to find better alternative execution paths as well as verify that the necessary indexes, statistics, and even histogram information is in place for the fastest execution.

With Kyle Hailey of Embarcadero Techologies

WATCH VIDEO NOW

 

All AccessAll Access

All AccessThe Right Tools Just in Time: How to Best Position Yourself for Perpetual Fire Fighting

In an agile development environment, change happens quickly and code is developed, tested, and deployed to production with extraordinary frequency.  Whether you’re developing internal-facing applications that serve the business or external-facing applications that serve your customers, you need the right combination of tools to manage change, ensure high performance, and meet expected service levels (SLAs).  This session introduces the tools that any master craftsman should have handy to best position yourself for any fire fighting situation.

With Greg Nerpouni of Embarcadero Technologies

WATCH REPLAY NOW

 

All AccessHow Embarcadero Database Tools Fit into the Development Life Cycle of Databases
Part I& II

Learn what products you can help with the modeling and development phases of the SDLC for databases. 

With Rick Iannitelli of Embarcadero Technologies

WATCH REPLAY NOW

 

Performance CenterPerformance Center

Performance Center

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.

With Harry Helal of Embarcadero Technologies

WATCH REPLAY NOW

RapidSQLRapidSQL

RapidSQLJBuilder

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.

With Michael Rozlog of Embarcadero Technologies

WATCH REPLAY NOW

Rapid SQL Short Subject Videos:

  • Create Quality Code & Manage Projects with Rapid SQL by Robert Lorenger
    DOWNLOAD VIDEO NOW
 

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.

With Dan Lukasik of MassMutual

WATCH REPLAY NOW


All-AccessDSAuditor and All Access

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.

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

WATCH REPLAY NOW

Database Tools Short Subject and General Videos:

 

 

Embedded and Workgroup Databases

InterBaseInterbase

InterBase

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.

Jim McKeeth - WideOrbit / Podcast at Delphi.org

WATCH REPLAY NOW

 

InterBase

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

With Jerry Barnes of Embarcadero Technologies

 

Rapid Application, Web and Java™ Development Tools

DelphiDelphi

Delphi

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.

With Marco Cantu - WinTech Italia Srl 

 

Delphi

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.

With Robert Love - State of Utah

 

Delphi

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.

Marco Cantu - WinTech Italia Srl

 

Delphi

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.

Cary Jensen - Jensen Data Systems

Delphi

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.

With Pawel Glowacki of Embarcadero Technologies

 

Delphi

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.

With Giacomo Degli Esposti - Optima s.r.l

 

Delphi

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.

With David Intersimone of Embarcadero Technologies

 

Delphi Short Subject Videos:



Server Response from: ETNASC01