One of the things that I often had a difficult time with was finding a way to select the newest records from a table that had one or more columns to group by and then one column to order by. Let’s use the following table as an example: Version Name Read more…
We recently had the need to create hundreds of folders but didn’t want to do so manually. Unfortunately, this wasn’t as easy as simply going into the database and adding them. Fortunately, it was as easy as using the following script: That script creates the following folders with the same Read more…
A while back, I wanted to have a script that would select a file or a folder in Windows Explorer. The following JScript selects the parent folder of the script that is run within Windows Explorer: For instance, if the above code is run in a script found at “C:/Users/chriswest/Documents/Scripts/JScript/select_parent_folder.js“, Read more…
Recently at work we had the need to convert a string parameter (passed into an iReport) into a table. For many people, the first thing that may come to mind is either the STRING_TO_ARRAY(...) function combined with the UNNEST(...) function. The biggest issue with using just those two functions is Read more…
Now to grant all access for roles on all of the functions in the database, you can use a query such as the following: After running this query, you will have all of the GRANT statements that are needed to give the user john_doe all access to the functions in Read more…
Once again, since the DBA is on vacation today, I have to assume some of his duties. It seems that nobody has access to anything in the development databases. After granting them permissions to all of the tables in the public schema (figured this out last time), I was asked Read more…
That’s right! As of right now, I have a totally open source, unbreakable encryption tool available to the masses called Crypter. What Is Meant By Unbreakable The only way that I can conceive of breaking any of the encryption methods used in the Crypter is to actually know the key Read more…
The following answers the Problem of the Week from May 14, 2012: At first glance, it may seem that the following would be the solution: Unfortunately, the above results in true being returned. In order to get false to be returned, you could do the following: Even though the result Read more…
Many JavaScript/JScript developers use Google Closure Compiler to compile their code. Even though this tool is a great way of minifying JavaScript code, believe it or not, it doesn’t always work (at least as of May 14, 2012). The following JavaScript code works fine when you run it without being Read more…
The following answers the Problem of the Week from May 7, 2012: One of the simplest ways to prove that 0.999999 = 1 is by doing the following: 0.333333 = 1 / 3 3 × (0.333333) = 3 × (1 / 3) 0.999999 = 1 As shown above, since it Read more…