Blog Aggregator - Amardeep Sidhu

One of the clients I’m working with this week wants to go through how OBIEE environments are migrated from one environment to another. They are working on a solution for their organization where a team of developers put together an initial first cut of the repository and web catalog, and then at various points from […]

I went to AskTom to add the site’s search engine to my Firefox’s Search Bar but too bad the search engine link was broken:

So, I went ahead and created a new AskTom search engine plugin.

If you are browsing this page in Firefox 2 or above or IE7 or above, click here to install the AskTom […]

Not long ago - I wrote about some frustrations with the state of software ‘development’.  This morning I read an article written not too long ago “They Write the Right Stuff”.  I liked it a lot.  Maybe not practical or reasonable for every piece of software (but then again, why not?) - but definition sound techniques and processes for everyone.

The sections are

• The product is only as good as the plan for the product.  Ah, they are talking specifications, communication, documentation…
• The best teamwork is a healthy rivalry.  Indeed!  I’ve said before the best was to test your ability to recover in a DBA team would be to set up two teams - one is responsible for damaging a test database in any way they want to.  The other team is responsible for recovering from that catastrophe.  Next week - switch sides.  Not only fun but very enlightening (when I poll audiences, less than 5%, way less, have done a recovery in the last six months - could it be they might not be able to today if needed?).
• The database is the software base.  Now, they did not mean the database is the center of the application itself (I would say something like that) but rather the history, change control, reason for all change is.  The history, the legacy of the code is as important as the plan for the product.  You need to understand why things were done the way they were - in order to safely change it later.
• Don’t just fix the mistakes - fix whatever permitted the mistake in the first place.  My favorite one!  How many times will I have to hear in my life “we have to do X, but you cannot tell us to use method Y to do it - Y cannot be done”.  I get that all of the time - tell me how to make it go faster, but don’t look at or mention touching the application.  The mistakes are typically to be found there - in the application (typically means 99.99999999999999999% give or take a small amount).

As an aside, anyone that knows me, knows my mantra - written many times:

• You should do it in a single SQL statement if at all possible.
• If you cannot do it in a single SQL Statement, then do it in PL/SQL (as little PL/SQL as possible!).
• If you cannot do it in PL/SQL, try a Java Stored Procedure.  The number of times this is necessary is extremely rare today with Oracle9i and above.
• If you cannot do it in Java, do it in a C external procedure.  This is most frequently the approach when raw speed, or the use of a 3rd party API written in C is needed.
• If you cannot do it in a C external routine, you might want to seriously think about why it is you need to do it…

Therefore - I just loved this Oracle-WTF.  And you know what - it pairs up with the “write stuff” article nicely.  I’ll bet you that that original stored procedure was not planned (no specs), peer reviewed (no health rivalry), change managed as it was tweaked over time, and until now - never “fixed”.  Can you imagine how long it took to reverse engineer that into a single SQL statement (I’d guess a minimum of an hour - and likely more).  An hour well spent, but I know personally the frustration of that person for that hour - cursing every developer that touched the code before them.

And I cannot tell you how much I hate code like this:

    BEGIN        v_temp_runs := 0;        SELECT COUNT(*)        INTO   v_temp_runs        FROM   dual        WHERE  EXISTS               ( SELECT *                 FROM   temp_runs );    END;

    IF v_temp_runs > 0 THEN

Why count something and do something else if there was something to be counted?  JUST DO IT, if there is nothing there - SO WHAT?

At least the original code did not end in “when others then null;” - there is that.

I’ve already discussed some reasons why performance is not particularly improved by simply separating indexes from tables and storing them in a different tablespace. It sounds like it might be helpful from a performance perspective but when one digs down a little, it turns out any so-called performance benefits are questionable to say the least.
However, […]

I am a big fan of Trend Micro Internet Security , it’s much better then Symantec (Norton) anti virus.

There are some good features in Trend Micro internet security - one of them is it core design when virus scanner runs it doesn’t slow down the PC when virus scanner is running.I have used Symantec abntivirus for years but when it comes down to advanced features and price tag Trend micro antivitus rocks. I have 6 years old dell inspirion laptop that runs windows XP ,it runs very slow so i have to uninstall Symantec antivirus and when i installed trial version of Trend micro internet security i noticed significant performance improvement . Now i can work on my laptop with full virus scanner running in background without affecting my work.

On top of that Trend Micro internet security 3 user license copy is available for $42.99 only. I use one for my laptop , one for my desktop and one for virtual Machine i am running on my desktop.

If you want to buy Trend micro Internet security 2008 version (3 user license) then click here to buy it directly by clicking on the image below :