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 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 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. 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 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 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 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 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 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 Read more…
Something that I did before, but never documented until now was querying the database for all of the PL/pgSQL function definitions. In PostgreSQL, you can run the following to pull all of them along with the owner, schema, function name, Read more…