How to use Regular Expressions in SQL

In Technology by KumarLeave a Comment

Recently I had a need to check if a column contains non-numeric/alpha-numeric values for identifying anomalies of a design. The first thing that struck me was, RegEx a.k.a Regular Expressions, which would make it simpler to search. I use them often in tools like notepad++ and in programming languages like Java. Then I wanted to know if Oracle SQL supports …

Airtel 4G LTE Dongle – No device found error resolution

In Technology by KumarLeave a Comment

Issue: Sometimes after connecting Airtel 4G LTE Dongle, we might get ‘No device found’/’Device not detected’ error on Windows 7, although the device is properly connected and shows up under My Computer. Resolution: After talking to the customer care technical support, the following steps resolved the issue for me: Under My Computer –> Right Click on the device drive (You …

How to zip a directory by excluding specified sub-directories

In Technology by KumarLeave a Comment

On Unix, the common zip command used to compress a folder is: zip -r <zip_file_name>.zip <directory_name> However, sometimes we might require an option to zip the directory by excluding few sub-directories, especially the ones with huge size and are not required. One easy workaround is to zip normally, extract and then delete the undesired sub-directories. But if the zipped file …

File transfer using FTP from command line

In Technology by KumarLeave a Comment

For the people who work on multiple machines (Windows, Unix or a combination), file transfer is a frequent need. There are many famous and widely used tools like filezilla, WinSCP but somehow I prefer using command line OS utility for its simplicity and robustness. Here is how I use it: Eg: Windows (Source), Target (Unix): Open Windows command line. Change …

How to Move from HTTP to HTTPS – WordPress, CPanel AutoSSL

In HowTos by Kumar1 Comment

I have literally spent over couple of days moving my WordPress site from HTTP to HTTPs, the whole reason for doing it is to make sure the connection is Secure and also Google Chrome shows “not secure” icon, if you do not have the HTTPS enabled.  Below is a simple guide to enabling SSL or get a secure lock icon …

Guide to TTD Tirumala Darshan Tickets Booking Online New Website

In HowTos by Kumar30 Comments

I recall searching for how to book tickets online almost over a year ago scrambling for information, finally ended up writing an article on it, you can read TTD Online Booking Process. The problem is that, TTD has moved to a New Website and System in 2016, where most of it has changed, I believe it is good to re-do …

How to remove Drishti or Buri Nazar for Babies ?

In HowTos by Kumar1 Comment

Babies or young kids can be very cranky and can get you drained down, if they are hit with disti, drishti or buri nazar ( however you call it ). It may help you, if you can try some of these home customs that have been practiced over centuries. Some of them may not make any sense, but they just feel …

Need Taxi -Don’t know Thai,Avoid Cheating -Take Uber! Review

In Travel by KumarLeave a Comment

Taking taxis in Bangkok or in Thailand can be a very tricky thing, you often get cheated by taxi drivers..especially in the evenings and nights. Also, the biggest issue is the language barrier in Thailand with Taxis. You as a passenger would say something, the guy driving interprets something and you end up landing in a different place…I have ended …

Singapore Taxi Drivers–Best, No cheating !

In Travel by KumarLeave a Comment

Taxi drivers can be a real pain for anyone new in a totally new country, unless you are in countries like Singapore.  As described taxi drivers in Kuala Lumpur can cheat you a lot, if you are not clear with them. In  Singapore, it is very safe and there is no cheating involved. Whats good about the Taxi Drivers in …