Database Technology Trends

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

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

###

Turns out that maintaining a blog requires time and efforts. That’s why so many blogs went silent in the past few months. Regarding a source of the NY Times (Blogs Falling in an Empty Forest) bloggers are abandoning their beloved blogs in an increasing rate. The good news is that this will weed out 95% of all the competitors.

I have to admit that I fell into a blog fatigue myself. After blogging a few articles that created a lot of interest in the market space I got wrapped up in a lot of work for my company and ignored my blog all together.

Many of my fellow colleagues were constantly asking me when I will release my next article on the blog. I chose to ignore these requests and deemed the blog as too much work for not much in return. But times are changing and the current recession is very challenging for small businesses to stay afloat.

The one thing the last recession proofed was that the companies that were able to keep their names on people’s minds, either through advertising or aggressive mouth to mouth promotions, came out ahead once the economy recovered.

Of course advertising costs money and money is tight during a recession. But there’s a way to bypass that. Blogging is essentially free and a great tool to keep your name in people’s mind. Especially in the consulting business it is very hard to actually create a direct response marketing campaign. Circulating your name is the best method to keep you on a possible short list in the future.

So, this is reason enough for me to re-launch my blog. There will be summaries and reviews of new database features recently released by the major database vendors. I will also add a new topic covering content management issues. Besides a multi decade long experience in database architecture and management I also added Microsoft’s SharePoint as a strategic tool to my company and the blog will feature articles that will discuss SharePoint features not many people are aware of.  Whenever possible there will be real life experiences as well.

Having said that I now have to go back to the drawing board and get busy with the next blog series.

As always, thank you for stopping by and your continued interest in my views.
Thanks,
Peter