DB Optimizer Community

Welcome to the DB Optimizer Community!

Embarcadero DB Optimizer lets you quickly discover, diagnose, and optimize poor-performing SQL. By discovering data-intensive or frequently executed queries, focusing in on specific SQL statements through query statistics (i.e., CPU, I/O, wait times), and optimizing any problematic statements, DB Optimizer eliminates performance bottlenecks.

  • Eliminate performance bottlenecks in production databases and applications
  • Prevent poor-performing SQL from reaching production
  • Develop, test, profile, and tune SQL in a single easy-to-use IDE

Events

Events: Upcoming | Latest | Day | Week | Month
17 Oct 2012SQL Server 2012 Performance Tips and Gotchas for Beginners
Web Seminar     10/17/2012 11:00 AM - 10/17/2012 12:00 PM
3 Oct 2012
Joes2Pros Author Talks SQL Server 2012 Performance Tuning
7 Sep 2011Webinar: SQL Server Performance Tuning and Optimization – Expert Roundtable
Web Seminar     9/7/2011 11:00 AM - 9/7/2011 12:00 PM
17 Aug 2011
SQL Server Performance Tuning and Optimization - Hit us with your best shot!

Articles

Sort by: Page 1 of 4 | 1 2 3 4 | Next
DateTitleAuthorType
25 Mar Blocking and Locking Troubleshooting in SQL Server
A look at the various ways to identify potential problems of locking and blocking, how they are different and what options SQL Server gives to resolve them
Tim DelChiaro Article
23 Mar DB2 Log Management Webinar: In the Beginning, There Was the Log
Watch Martin Hubel, DB2 Evangelist and Scott Walz, Director of Software Consultants as they share insight and best practices on understanding DB2 processes and log management strategy.
Tim DelChiaro Article
18 Mar SQL Server Security Enhancements
This paper outlines the security features introduced with SQL Server 2014
Tim DelChiaro White Paper
16 Mar Dan Hotka’s PL/SQL Tips & Techniques, Part II
Watch Oracle ACE Director, Dan Hotka and Solutions Consultant Director, Scott Walz in part two of the series, where they continue to build on that knowledge and share even more expertise on PL/SQL procedures, functions and packages.
Tim DelChiaro Article
11 Mar Zero to Hero with SQL Server Management Studio
This whitepaper will show you 12 cool tips for working with SQL Management Studio that you will want to know about
Tim DelChiaro White Paper
5 Mar Overcoming the Top SQL Server Mistakes Seen in the Field
Tim Radney and Mike Walsh, SQL Server MVP's and frequent speakers at technical conferences, share the common issues they encounter when performing WellDBA™ exams
Tim DelChiaro Article
25 Feb SQL Server in Simple Words eBook
Pinal Dave shares some of his tips and techniques that utilize some of the capabilities available with SQL Server Management Studio (SSMS) that can help you enhance your productivity.
Tim DelChiaro White Paper
24 Feb Dan Hotka's PL/SQL Tips and Techniques Part I
Join Oracle ACE Director, Dan Hotka and Solutions Consultant Director, Scott Walz as they present and demo the fundamentals of PL/SQL and much more.
Tim DelChiaro Article
19 Feb Find it. Fix it. Real-World SQL Tuning Cases
In this on-demand webinar, several real-world examples are reviewed to help you learn how to evaluate poorly performing SQL
Tim DelChiaro Article
17 Feb The DBA and Developer Career Tips eBook
Pinal Dave provides career tips that are helpful to database professionals that are looking to move their career to the next level.
Tim DelChiaro White Paper
3 Feb Embarcadero Database NewsFlash Newsletter - February 2015
Get the latest news and information on for DBAs and Database Developers
Tim DelChiaro Article
23 Dec 2014 Season's Greetings from Embarcadero
We wish you a joyous holiday season and a Happy New Year
Tim DelChiaro Article
9 Dec 2014 Technologies Revolutionizing the Database World
Webinar on-demand
Tim DelChiaro Article
1 Sep 2014 Preparing for Data Centric Interviews
What would be your traits you will look forward to when taking a data centric interview?
Tim DelChiaro Article
18 Jun 2014 Embarcadero Ranks on the 2014 DBTA 100
Recognized as one of the most important companies in data for the second consecutive year
Tim DelChiaro Article
14 Mar 2014 Follow your favorite Embarcadero tools on Social Media
Twitter, Facebook, LinkedIn, Pinterest, YouTube, Google+ and more!
Tim DelChiaro Article
16 Jan 2014 Become a Troubleshooting Legend. Rapidly Find & Fix Performance Issues and Get Noticed.
Webinar presentation featuring David Intersimone & Scott Walz
Tim DelChiaro Article
9 Oct 2013 Embarcadero Database NewsFlash Newsletter - October 2013
News and resources for database professionals
Tim DelChiaro Article
7 Aug 2013 Embarcadero Database NewsFlash - August 2013
Data Governance, Visual SQL Tuning, Data Modeling and More!
Tim DelChiaro Article
19 Jul 2013 Webinar Series: Build and Sustain your Data Governance Program
Make the business case and avoid key pitfalls. Featuring Kelle O'Neal
Tim DelChiaro Article

Server Response from: ETNASC02