Posts Tagged ‘Sql Expert’

Dobler Consulting Launches New Website to Help Companies Lower Technology Costs with Database Consulting and Business Process Improvements

Thursday, October 29th, 2009

TAMPA, Fla., October 30, 2009 – Dobler Consulting, Inc. (www.doblerconsulting.com) launches its new website, offering proven solutions that put an end to a company’s database challenges. The company, which started in 2000, has made some important changes for Sybase, Oracle, and Microsoft SQL Server visitors to their site.

Peter Dobler, President, wears his database consultant hat, and shares his extensive experience with his readers. His distinctive approach to safeguarding valuable data and business resources for clients is based on products, services, and continuous education he offers for database technology clients. The website is a content resource with some key new features, which include:

 

  • Free Software Stimulus Package

    Download a free copy of ActiveBase SQL Expert™ for Oracle. Once installed, this software helps Oracle users influence the database optimizer’s choices to improve response time and minimize resource waste. For more information, see: http://www.active-base.com/download_expert_dobler.asp.

 

  • DBA Managed Services

    Their Database Administrator Managed Services are focused on assisting small and medium sized businesses with a remote database support model for the major databases: Sybase, Oracle and SQL Server. They specialize in helping clients achieve minimized database downtime, increased database performance, and customized support services, both onsite and offsite. The onsite services include scheduled visits as part of a client’s service level agreement (SLA).Dobler tells clients “using our services will help you realize significant savings and predictable costs, rather than using traditional contracting resources.” Learn more at: http://www.doblerconsulting.com/services-dbams.html.

 

  • Product Line Offerings

    • ActiveBase Tool Suite – a leading performance and security software tool for your databases.
    • SmartScore – a proactive business event management software solution.
  • See more at http://www.doblerconsulting.com/products.html.

 

  • White Papers 

    • Challenges and Customer Experiences Using ActiveBase
    • Active Base Security, Priority, and Performance benefits to save money, improve response time, and prevent leakage of company data.

    Read more at http://www.doblerconsulting.com/solutions.html. Additional white papers are posted regularly for visitors to read about up-to-the minute database technology.

    “How ActiveBase Security Changes the Remote DBA Support Approach” can be downloaded. It includes such points as: 

 

  • Database Technology Trends Blog 

    Database Technology Trends is a continuing education personal blog, discussing the latest database technology trends, and important database technology events. See: http://www.peterdobler.com/

 

  • Technology Tips and Tricks Blog 

    This technically-focused blog offers tips, tricks, and technical guidelines, based on Dobler’s years of performance tuning and troubleshooting experience. Database Administrators can try out or validate step-by-step topics, using the blog as an evolving information resource. Visit: (http://www.techtipsntrick.com ) or use the RSS link on each page of www.doblerconsulting.com for immediate updates.

 

Peter Dobler maintains that “most companies need help with their databases from time to time. Our remote DBA support services help clients improve their database administration needs. We work to improve each company’s unique business processes, by bringing cost savings and problem solving through process improvements.”

Dobler specializes in planning and executing technology recommendations, by turning them into concrete IT projects, and successfully completing them.

Browse through Dobler Consulting’s offerings by visiting http://www.doblerconsulting.com. Contact Peter Dobler at 813-322-3240, or info@doblerconsulting.com.

About Dobler Consulting

Dobler Consulting is a leading information technology and database services company that offers cutting edge technology and integration for their clients. Founded in 2000, the Tampa consulting firm delivers implementation expertise for Oracle, Sybase, and MS SQL Server. Dobler Consulting has over 20 years of proven experience, working with their clients to improve database efficiencies and reduce costs. Dobler Consulting serves local and southeast regional clients with their world class services and products.

###

Software Stimulus Package

Friday, October 9th, 2009

After all these bad news about the economy and how businesses struggling to stay afloat, a lifeline was offered courtesy of ActiveBase, the latest addition to the product line of Dobler Consulting. After forming a strategic channel partnership with Silos-Connect Technologies, the US Distributor for ActiveBase software, we are ready to introduce ActiveBase to the US market.

Please read the latest press release from Silos-Connect regarding the software stimulus package:

 


SOFTWARE STIMULUS PACKAGE

The Recession is Real…It is Ugly…and Ugly it will be for the foreseeable future!


 

IT budgets have been slashed, staff has been reduced, and there is more work than ever! All of the focus is on market sectors and companies that are “too large to fail“.

 

It is Our Opinion that
IT is also Too Large to Fail!

 

That is why we have created this Software Stimulus Package. We are offering one of our break-through technologies at no charge! This way, you can put in a new tool and not have to worry about budget! Especially at a time when you need more tools just to keep up!

ActiveBase SQL Expert for Oracle can be downloaded and used on an unlimited basis, at absolutely no cost.

ActiveBase SQL Expert, the newest module of the ActiveBase Suite, helps the DBA and SQL developer by automating the process of finding the right Oracle Hint, for a given SQL statement. The “right Hint” is the one that, when added to the original SQL statement, produces the lowest result (shortest elapsed time or the least CPU or I/O). Oracle Hints change the way Oracle executes queries, without changing the source code or the database. This is especially powerful when running proprietary applications where you don’t have access to the source code.

Finding the right Hint using existing current methods is an iterative and highly-time consuming process, and is simply not feasible. Often times, you may find a “good” solution, but not always the “best”. A statement with a cost of 175, will run certainly better with a cost of 142, but it would run even better than that with a cost of 125. Wouldn’t you rather know that you got the best alternative, rather than just a good one?

Through its simple graphic interface, ActiveBase SQL Expert completely automates the process and guarantees the best alternative, without any extra effort!

 

  1. Identify: Select un-tuned SQL requests from the Oracle SGA using the ‘Hotspot’ viewer, or a flat file that you create from either source code, or another application monitor.
  2. Set benchmark options: Set the number of alternatives to execute, total benchmark time, automatic canceling, session and parallel degree settings, etc.
  3. Analyze: Find different alternatives (SQL + ‘Hints’) generating multiple unique execution plans.
  4. Run Benchmark: Execute the alternatives against a database to find the best result.
  5. Analyze results: Using the automatically generated, detailed benchmark audit trail with a color-coded summary view quickly identify the best improvement.

 

What’s the catch? This is a legitimate question, one I would ask myself. The answer is, there is no catch, unless you consider an occasional pop-up that describes the other ActiveBase modules to pique your interest.

 

Get Your Own Stimulus Package

 

For more information, or to schedule an installation or demo, please contact me:
Tony Cannizzo | President
Silos-Connect Technologies
404 580 3451
tony@silos-connect.com

###