I read the article about the cost of software development approaching zero and realized the author was talking about one off solutions of a small and specialized nature.  I am...

I think it would be interesting if you input a requirements document, naming standards and a database, if an AI could generate the extended property MS_DESCRIPTION script to describe most...

If your code is under version control and isn’t authorized for change you will have to create a change order to justify the refactor.  But if you already have the...

No company can afford a highly skilled coder to go around refactoring their code base and shouldn't use an inexperienced coder for the task.  When does it make sense to...

I don't believe AI is going to clean up bad data.  Humans can't even clean up dirty data.  I have seen situations where bad code created 750 duplicate entries for...

It will be interesting to see how many comments are made on this topic of database design.  It seems that action is what everyone wants to see and design is...

I have many years of experience in IT as an employee as well as a consultant.  As I see it you need to hire all of the above.

Hire inexperienced staff...

I retired in 2021 and figured it was a good time.  Database design was one of my favorite tasks and it appeared that no one was designing databases.  I agree...

• This reply was modified 3 months, 2 weeks ago by hmbacon.
• This reply was modified 3 months, 2 weeks ago by hmbacon.

Wow.  The silence indicates whoever reads these post has not given much thought to finances and retirement.  The sooner you think about it and make financial plans the better off...

I converted Jeff's algorithm for determining ISO dates to Oracle, but it was only a matter of translating the algorithm.  In the case of the splitter, the purpose was not...

Another excellent article.  I am currently working on a budgeting application in Oracle and decided to use these concepts in Oracle.  WARNING: For anyone else wanting to use these concepts...

As someone who has been around too long, I know the purpose of the semi-colon.  It is to define the end of a statement.  It is possible to put several...

Examples of CTE's with semicolons has always bothered me.  I started out in Oracle and the semi-colon is required and it only took about a year to finally include it...

I indicated that the need for a cursor is rare but you need to be willing to use them.  If you need to update 6 tables based on the data...

9. How many loops were used to determine duration and is it clock or cpu time.

10. Was the load on the system constant like in a stand alone database on...