PROFESSIONAL SERVICES

Consulting Training
Technical Papers

Optimizing the Development Process | More Info
Embarcadero Technologies
One of the most formidable IT challenges that companies must solve is the extreme cost of the development process. Learn how to optimize your development process and improve the performance of your applications through a thorough examination of your database schema.

Why Data Warehouse Projects Fail | More Info
Embarcadero Technologies
According to a 2003 Gartner report, more than 50 percent of data warehouse projects failed, and the ones that survived were delivered very late with extremely high costs. Learn how you can save time and resources on data warehouse projects by improving the quality of your database schema.

Get some respect in data management | More Info
Donna Burbank, Director, Enterprise Modeling and Architecture Solutions, Embarcadero Technologies
Advice to data managers is that if you want to get the attention of your business sponsor, make sure to speak their language. Don't show a business sponsor a detailed data model–instead use the web, excel spreadsheets, and/or high-level (conceptual) diagrams to get your point across.

New kids on the data management block | More Info
Donna Burbank, Director, Enterprise Modeling and Architecture Solutions, Embarcadero Technologies
While new technologies and initiatives like XML and Web 2.0 offer exciting possibilities, the old-fashioned principles of solid data architecture still need to be followed. The tried-and-true principles developed by data architects for traditional database systems can and should still be applied to these new technologies.

Ringing the Changes for Change Management | More Info
Philip Rathle, Senior Product Manager and Scott Walz, Senior Director, Product Management, Embarcadero Technologies
As modern database change management techniques for the Sybase DBA become more sophisticated, there is an inherent need for practitioners to be aware of the increasingly powerful tools available to them.

Benchmark Study - Embarcadero Technologies, Inc. CM/Data Competitive Analysis | More Info
National Technical Systems (NTS)

The High Performance DBA: Optimizing Databases for High Performance | More Info
Scott Walz, Director - Product Management, Embarcadero Technologies

Selecting the Right Change Management Solution | More Info
Terry Beadle, Senior Product Manager, Embarcadero Technologies

Collaborating with Developers and DBAs: 7 Ways to an Easier Project, a Better Product and a Stronger Team | More Info
Karen Lopez, Info Advisors

Forrester Total Economic Impact™ (TEI) Study of Embarcadero DBArtisan | More Info
Commissioned study conducted by Forrester Consulting.

ER/Studio 7.1 : Supporting Data Governance | More Info
Donna Burbank, Embarcadero Technologies, Inc.

SQL Benchmarking – Five Easy Steps to Finding and Fixing Code BottlenecksMore Info
Scott Walz, Embarcadero Technologies, Inc

Managing Data Strategically | More Info
An IDC Executive Brief sponsored by Embarcadero Technologies, Inc.

Database Security Best Practices: Implementing the Missing Piece | More Info
Embarcadero Technologies, Inc.

Enterprise Data Management: 7 Mistakes You Can't Afford to Make | More Info
Karen Lopez, Info Advisors

Key Criteria for Evaluating ETL Solutions | More Info
Philip Howard, Bloor Research

Response Time Analysis Made Easy in Oracle Database 10g | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Data Lifecycle Management Series: Overview of Data Lifecycle Management | More Info
Embarcadero Technologies, Inc.
Handling Database Migrations with Embarcadero Solutions | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Data Lifecycle Management - Migrating to MySQL | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Data Lifecycle Management for DB2 | More Info
Robin Schumacher & Amit Agarwal, Embarcadero Technologies, Inc.
Data Lifecycle Management for Sybase | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Data Lifecycle Management for MS SQL Server | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Automating Common Administration Tasks | More Info
Rob Young, Embarcadero Technologies, Inc.
Why You Need a Code Profiler | More Info
Embarcadero Technologies, Inc.
The Need for Better SQL Server Backups | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Data Design Analysis -- A Bottom-up Approach to Analyzing and Standardizing Database Design | More Info
Jason Tiret, Embarcadero Technologies, Inc.
Why You Need Capacity Planning | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
The High Performance DBA --
Techniques and Best Practices for Keeping Databases Optimized for High Performance | More Info

Robin Schumacher, Embarcadero Technologies, Inc.
Exploring the Oracle Database 10g Wait Interface | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Managing SQL Server Performance with Performance Analyst | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Smart SQL Server Space Management with Space Analyst | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Coping with your database performance gremlins | More Info
Harry Flora, Embarcadero Technologies, Inc.
Is Your Database Breakable? | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Avoiding Performance Downtime and System Outages Through Goals-based Testing | More Info
Nate Skinner & Paul Down, Embarcadero Technologies, Inc.
Embarcadero Describe - Working with Configuration Management Applications | More Info
Brent Hansen & Jeff Bush, Embarcadero Technologies, Inc.
Liberate Your Data With ETL | More Info
Embarcadero Technologies, Inc.
Database Maintenance Plans | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
ETL For All of US | More Info
Judy Saam and Jeff Bean, Embarcadero Technologies, Inc.
Testing Needs to Get Into the Real World | More Info
Paul Down, Embarcadero Technologies, Inc. (article first published in Professional Tester Magazine)
A Case for Capacity Planning? | More Info
Rob Young, Embarcadero Technologies, Inc.
What Database Performance Monitor Do I Need? | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Resolving Oracle Space Problems Using Embarcadero Space Analyst | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Monitoring Databases the Right Way with Embarcadero Performance Analyst | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Disk Sorts - A Subtle Threat to Database Performance | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
The Benefits and Challenges of Implementing XML | More Info
Dan Giannascoli, Embarcadero Technologies, Inc.
"It's The Little Things That Count" | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
"Third Party Tools in Single Platform Shops" | More Info
Matthew Bennetti, Embarcadero Technologies, Inc.
"UML 2.0 Sequence Diagramming" | More Info
Brent Hansen, Embarcadero Technologies, Inc.
"Managing Space Fragmentation in Oracle" | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
"Easing Development Migration to DB2 UDB" | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
"Database Maintenance Plans" | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
"Resolving Common Oracle Performance Problems" | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
"Data Integration - yes, you can afford it" | More Info
Sue Munslow, Embarcadero Technologies, Inc.
Why Build a Logical Data Model? | More Info
Barbara Carkenord, The Knowledge Exchange Company
Software: The Unmanaged Asset | More Info
Embarcadero Technologies, Inc.
Practical Solutions to Ease Development Complexity | More Info
Embarcadero Technologies, Inc.
"SQL Perfection Checklist: Step by Step Methods for Creating High-Quality Database Code." | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Eliminating Space Reorganizations in Oracle8i | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
Improving Developer Productivity Through the Unified Modeling Language More Info
Embarcadero Technologies, Inc.
Building Reusable Oracle SQL and PL/SQL Database Utilities Using Embarcadero Rapid SQL | More Info Embarcadero Technologies, Inc.
Using Embarcadero Tools to Develop an Internet Enabled Data Mart | More Info
Embarcadero Technologies, Inc.
Leveraging Database Expertise | More Info
Embarcadero Technologies, Inc.
"Data Warehousing Quality - What it Takes " | More Info
Tim Raab, Nationwide Insurance Corporation.
"Locally Managed Tablespaces - Are They For You? " | More Info
David Fitzjarell, SPR Consulting.
"Identity Crisis" | More Info
John Hindmarsh, Enterprise Data Inc.
"Data without Meta Data is Like... | More Info
Steve Schaffer, IBM’s Global Services Business Intelligence
"Implementing Data Quality Through Meta Data" | More Info
David Marco & Michael Jennings, Enterprise Warehousing Solutions
"MS SQL Server Tuning Index Wizard" | More Info
Dusan Petkovic and Christian Unterreitmeier
"From Data Warehouse to CRM ..." | More Info
Tim Raab, Nationwide Insurance Company
"Hit and Miss - Setting Oracle's Buffer Cache Size" | More Info
Steve Adams, Ixora Pty, Ltd.
"A Simple Customer Activity Model for E-Business Intelligence" | More Info
David Loshin, Knowledge Integrity, Inc.
"Experience Not Required" | More Info
Robin Schumacher, Embarcadero Technologies, Inc.
"Function Based Indexes in Oracle 8i" | More Info
Jay Wortman, Independent Consultant
"SQL Service Pack 2" | More Info
Brian Knight, Alltel
"Using Select ROLLUP in Oracle" | More Info
Jay Wortman, Independent Consultant
" NULLS - A Conversion Headache" | More Info
John Hindmarsh, Enterprise Data, Inc.
"Creating Materialized Views" | More Info
Kevin Loney, Kevin Loney Consulting, LLC.
"Data Standardization" | More Info
David Loshin, Knowledge Integrity Inc.
"Creating a Database Profile" | More Info
John Hindmarsh, Enterprise Data Inc.
"Orphan Oracle Processes" | More Info
David Fitzjarrell, DBA, SPR Inc.
"Much Ado About Nothing | More Info
David Loshin, Knowledge Integrity Incorporated
"Sizing Extents can Actually Improve Response Time" | More Info
Kevin Loney, founder of Kevin Loney Consulting, L.L.C.
"The Chain Gang" | More Info
David Fitzjarrell, SPR, Inc.
"Here Today, Gone Tomorrow" | More Info
Kevin Loney, founder of Kevin Loney Consulting, L.L.C.
"Identifying Which Indexes to Rebuild" | More Info
Donald Burleson, Editor-in-Chief, Oracle Select Magazine
"Auditing Date Values for Year 2000 Compliance" | More Info
Kevin Loney, founder of Kevin Loney Consulting, L.L.C.
"Beyond Showplan" | More Info
Brian Davignon, Sr. DBA Consultant, Soaring Eagle Consulting
"Tuning: Does it Ever End?" | More Info
David Fitzjarrell, SPR
"Process Monitor - Window to the Soul" | More Info
Todd Adams, DBA: EDS Data Management Service Center
"RDBMS application tuning ..." | More Info
Stephane Faroult, Oriole Corporation
"Will That Be Cache?" | More Info
David Fitzjarrell, SPR
"Mining the Metadata?" | More Info
Jeff Garbus, Soaring Eagle Consulting