All blog posts on the front page.
A week ago someone asked me how they can format a date so that it returns the MM/DD/YYYY format. The following is a definition for a function that does just that: The following code is an example of how you would use this code: The following is a JSBin page Read more…
Did you know about the interactive guides provided by Microsoft to help Office 2003 users to migrate to the corresponding 2007 or 2010 software? If you are trying to get use to Office 2010, you can use the interactive guides on this page. If you are trying to get use Read more…
If you want to validate virtually any date (formatted as YYYY/MM/DD or YYYY-MM-DD) in JavaScript with a regular expression, you can use the following (fixed on August 8, 2013): This was actually inspired by the regular expressions from this post. Of course, the best way to check a date’s validity Read more…
To answer last week’s POW, the purpose of the SQL was to generate a random string of letters and numbers. I actually wrote two different JavaScript function that can produce the same results. The following is the slightly more straight-forward solution: The next version is a bit harder to follow Read more…
Someone asked me to quickly write them some code in any language that would accomplish a certain task. The following, which is in PostgreSQL, is the second solution that I came up with after doing the first one in my favorite language, JavaScript: The question is, what does this SELECT Read more…
This answers the Problem of the Week from May 8, 2012. The identity of this well-known computer science function is the binary search. The following is the same code from before with the variables more properly named: To tell you the truth, after using the real names in the function Read more…
This Problem of the Week involves determining the identity of a well-known computer science function and renaming the variables so that the definition makes more sense. The following is the function definition (obfuscated by me): What I can tell you is that this function takes in a sorted array (in ascending order) as the Read more…
The following is one answer to this Problem of the Week that works in PostgreSQL (and probably in other flavors of SQL):
Although I am not a system administrator, I do have to make sure that the date/time on many different servers is correct. For some reason, the time on these servers keeps getting off by between 15 and 30 minutes. I use to simply write the sudo date -s command to Read more…
One of the things I always find interesting is the fact that DBAs almost always use some type of auto-increment method in order to generate unique IDs for records. Sometimes, though, you may have a table in which you don’t want to use the default method of generating the next Read more…