Database Administration Tools

'DB Optimizer' Category

• May

  27

  2010

  Jonathan Lewis vs. Kyle Hailey — Tune-In for the Tune-Off!

  According to Jonathan Lewis, there is a basic strategy to writing efficient SQL, but it requires knowledge of the data, the metadata, and the intent of the query. Jonathan will start with the basic principles of efficient data access and then show different ways of analyzing the data. He’ll then describe a graphical approach to [...]

  posted in DB Optimizer, SQL by admin

• May

  19

  2010

  Embarcadero Ups Ante in Database Tools Market with Multi-Platform, On-Demand XE Products

  Embarcadero Technologies, long known for providing premium database design, development and management tools for all major database platforms, is unveiling a new line of database products that carry an XE brand. Embarcadero XE products incorporate three distinguishing features – deep, native support across all major databases with a consistent user interface, centralized license management and [...]

  posted in DB Optimizer, database tools by admin

• Nov

  09

  2009

  Taking the black art out of SQL tuning

  Embarcadero DB Optimizer 2 takes a methodical approach to SQL query analysis and optimization
  As any database admin knows, mastering the subtler nuances of SQL can be likened to the black arts. For me, tuning the efficiency of SQL queries on large, heavily used databases is a perfect example.
  Sure, I know how to use the query [...]

  posted in DB Optimizer, database tools by admin