All-in-One Programming Guide

September 22, 2007 by Mark Marucot · Leave a Comment 

All the How To reference articles and tips are now available in book format, with a complete Table of Contents and live Index links, in a single pdf file. This pdf file makes it easy to find answers to your questions. You can use the table of contents links, click the page number links in the Index, or search for a string.

Download Here

Debugging Using Eclipse

September 19, 2007 by Mark Marucot · Leave a Comment 

Eclipse is an integrated development environment (IDE) that provides workspace management, code and debug application. Eclipse is known to many Java developers because of its rich features that make their programming task easier. IBM Developer Works discussed about debugging your code using Eclipse.

Find out how to use the built-in debugging features in the Eclipse Platform for debugging software projects. Debugging is something programmers can’t avoid. There are many ways to go about it, but it essentially comes down to finding the code responsible for a bug. For example, one of the most common errors in Linux® applications is known as a segmentation fault. This occurs when a program attempts to access memory not allocated to it and terminates with a segmentation violation. To fix this kind of error, you need to find the line of code that triggers the behavior. Once the line of code in question has been found, it is also useful to know the context in which the error occurs, and the associated values, variables, and methods. The use of a debugger makes finding this information quite simple.1

  1. http://www.ibm.com/developerworks/op…ipse-Debugging []

TechED South East Asia 2007 in Kuala Lumpur

September 19, 2007 by Mark Marucot · Leave a Comment 

I haven’t attended any TechED event. The first time I read about TechEd South East Asia 2007 , which will be held on September 10-13, 2007, in Maria Johansson’s blog, the event got my attention since it’s within South East Asia because I’m currently in Manila, Philippines working on the system integration designs that links a mainframe, an existing Warehouse Management System and a new WMS called Red Prairee.

I’m involved mostly in Oracle Technologies and large scale systems but I’m fond of using Microsoft Technologies especially on my small tools created using VBA. I also designed Sharepoint sites for our Oracle Retail capability in Accenture for project and group management.
I founded Gizmo which is an internal group in Accenture that creates tools and utilities using VBA. For three quarters, I and my project became the recipient of Oracle Retail Job Well Done Award for all the utilities and best practices I shared not only to the Oracle Retail capability but to the whole Accenture.

How I wish I could be won a free plane ticket and entrance to attend TechEd South East Asia 2007. I know that I will learn new things in this event. I hope Ed Quek read this blog. Check the progress of preparation of TechEd here.
Tech•Ed SEA 2007, Microsoft’s premier & largest annual conference in the South East Asia regon, focuses on newly released products such as of Microsoft Office along with content about upcoming releases such as Windows Server code name “Longhorn”.
For four days in September, you can get technical training, information and resources to help you build, deploy, secure, mobilize, and manage solutions.
TechEd SEA 2007 features:

  • More than 120 breakout sessions
    This year’s event will feature even more speakers from Microsoft Corporation allowing you to hear about your favorite technologies from the sources who develop them. Create a personal learning program from 6 technical tracks with more than 120 breakout sessions.
  • Hands-on experiences
    Tech•Ed offers opportunities to evaluate products both from Microsoft and from 250 of our most important industry partners. Additionally, based on attendee feedback from last year, we will be more than doubling the number of Instructor Led Lab sessions as well as introducing a whole host of new self-paced Hands On Lab content.
  • Networking with your peers
    Walking around Tech•Ed are more than 2,000 minds just like yours. 2,000 IT pros and developers to meet. 2,000 opinions to consider. Add to the mix Microsoft product team members and industry gurus and you immediately see why a Tech•Ed crowd is like no other.

How to determine the working days between two dates in Excel?

September 19, 2007 by Mark Marucot · Leave a Comment 

If I have a Start Date and End Date columns, how to I determine how many working days between them?

You can use the function NETWORKDAYS. To use this function you need to do the following:
1.Select Tools Add-in.
2.Checked the Tools Analysis Pack
3.Click the OK button.

CODE:
  1. NETWORKDAYS<span style="color: #66cc66;">(</span>start_date,end_date,holidays<span style="color: #66cc66;">)</span>

where
Start_date is a date that represents the start date.
End_date is a date that represents the end date.

Holidays is an optional range of one or more days (holidays) to exclude from the working calendar.

Example 1:
Start_date: August 17, 2006
End_date: August 21, 2006

CODE:
  1. = NETWORKDAYS(August 17, 2006,August 21, 2006)

The formula above will return 3. This means there are 3 working days between August 17, 2006 and August 21, 2006.

In Pursuit of the Best Programming Languages

September 15, 2007 by Mark Marucot · Leave a Comment 

In my years of experience in software development, I wandered around which is the best programming language. I’d been involved in Oracle based application but there are programming languages out there that excels in their fields.
Amazon Unspun provides methods for community collaboration on the Web to develop consensus ranking. For the Best Programming Languages, here are the rankings.

Top 50 Best Programming Languages
as of 5/19/2007 6:27 PM GMT +8

  1. Ruby
  2. Pythou
  3. Java
  4. Lisp
  5. C
  6. Smalltalk
  7. APL
  8. Perl
  9. C++
  10. PHP
  11. Javascript
  12. C#
  13. Haskell
  14. Objective-C
  15. Scheme
  16. J
  17. Erlang
  18. Algol
  19. SQL
  20. Pascal
  21. Basic
  22. Fortran
  23. Delphi
  24. Ada
  25. K
  26. Snobol
  27. Assembler
  28. Visual Basic
  29. D
  30. Coldfusion
  31. O’Caml
  32. Brainfuck
  33. Forth
  34. Cobol
  35. Icon
  36. Standard ML
  37. IO
  38. Groovy
  39. Prolog
  40. Logo
  41. Lua
  42. Powebuilder
  43. F#
  44. R
  45. Providex
  46. Dylan
  47. ToonTalk
  48. Var’AQ
  49. Comal
  50. MOO