Although in Linux you can easily create multi-part zip files, unzipping them can be problematic. By using the -s argument in the zip command you can specify the split size and create split archives. The following example creates split archives with each part not larger than 1GB: The result could be something like: Where...
Read more →Some time ago, Oracle removed the download links to Oracle 10g Express Edition (XE). If you need to do a new install of the Oracle XE database on your Linux platform, you can download Oracle 11g XE from the Oracle web site. However, Oracle 11g XE is only available for 64 bit architectures. If...
Read more →When you need to schedule a Unix or Linux job in crontab to run on the first Sunday of the month, or any other weekday for that matter, your first instinct may be to write your cron entry to look like this: However, you will find that the job will be executed every day...
Read more →When I received my Geeksphone Keon last year (2013), I searched the Firefox Marketplace for a simple calculator, similar to the Calculator that comes with Windows. At the time I couldn’t find anything I liked so I wrote my own, which I named NNCalc, short for No Nonsense Calculator. One of the things I...
Read more →SQL Server does not natively support a “LIKE IN” clause. For instance the following example is not valid: Luckily there is a way to achieve this effect. First imagine that you have a stored procedure or function that searches for a specified word that appears anywhere within a Description column. If you had to...
Read more →Your DD-WRT enabled router can be configured to block ads as described in the Ad Blocking article. For non-Micro DD-WRT versions the ad blocking hosts file on the router can be updated automatically by a custom shell script that you then execute as a cron job, all on the router itself. However, the Micro...
Read more →In order to merge split vmdk files into one, you need to use the vmware-vdiskmanager command. However, this is only available if you have VMware Fusion or VMware Workstation installed. VMware Player doesn’t have this. Luckily this little utility can be downloaded separately from the VMware site. It is the 1023856-vdiskmanager-windows-7.0.1.exe.zip attachment that you...
Read more →The following example shows one way how you can remove leading zeroes from a varchar column in SQL Server: Returns:
Read more →The following C# code shows how to make a Progress Bar in a dialog window that can be shown for tasks that run for an undetermined amount of time. Instead of a regular progress bar that progresses from 0 to 100%, this one shows a little indicator that scrolls back and forth, while in...
Read more →The reason why sometimes a grid control shows a big red X and stops working properly is because an unhandled exception has occurred during the control’s OnPaint event. One way to handle this is by extending from the grid control and overriding the OnPaint event so that any exceptions can be handled. Of course,...
Read more →Through Windows’ WMI Service you can find out who the owner is of a file. This is somewhat similar to the user/group owner of a file in UNIX or Linux, as shown in the example below, where the file myfile.txt is owned by user root and group root. With the following AutoIt code, you...
Read more →If you plan on learning a new programming language, one good way to get to know the language better is by using it to solve the computational problems found on the Project Euler site. Currently there are about 385 problems to be solved, however more are added regularly. They start out relatively easy but...
Read more →