View Selection Formula: Get the records of the last 15 working days. This is achieved by calculating total days (TotDays) by moving back from now() and excluding all sundays (weekday=1). So for instance, If there are 3 Sundays in this period then we have to take 15+3=18 as TotDays (total working days) to get the […]
Continue Reading
If you want to be able to quickly access a particular website, you can add its address to your Home screen. Follow these steps:
Continue Reading
A launcher is an app that enables you to launch other android apps. The launcher governs the way your device’s Home screen and other main screens appear, including any live widgets you place on them. Android includes a default launcher that runs by default and which you invoke every time you press the Home button. […]
Continue Reading
Android’s Smart Lock feature allows you to set up methods of unlocking your device other than your pattern, PIN, password, or fingerprint. Setting up Smart Lock is pretty straight-forward. Locate Smart Lock option somewhere under Settings -> Security. You’ll be required to enter your password, PIN, or pattern to prove your identity. Next, choose the […]
Continue Reading
Sometimes it is required e.g, to get a comma-delimited-values list in a field from a relational database table. This is only possible to find some way to concatenate rows of the table. Following is one of the possible solutions using ‘FOR XML PATH’ expression in T-Sql. You may find other solutions as well. Suppose you […]
Continue Reading
Enter multiple commands at onceAdding && between commands will let you enter multiple lines at once to be executed in succession. e.g, tasklist && netstat -b List every device driver on your PCThe following command line displays the list of device drivers on your PC driverquery /FO list /v Output results to text file or […]
Continue Reading
A couple of very simple and intuitive code examples to parse data received in JSON format: var resultJSON = ‘{“FirstName”:”John”,”LastName”:”Doe”,”Email”:”johndoe@johndoe.com”,”Address”:”123 dead drive”}’;var result = $.parseJSON(resultJSON);$.each(result, function(k, v) { //display the key and value pair alert(k + ‘ is ‘ + v);}); Or var obj = $.parseJSON(resultJSON);for (var prop in obj) { alert(prop + ” is […]
Continue Reading
Losing your smart device can be drastic and painful, specially when you have a collection of sensitive and/or precious data. Financial loss could be tragic, for quite some time. With panic stricken face you may rush here and there in search of it. There’s a strong hope!!!Log in to this page: https://www.google.com/android/find?u=0 from a PC, […]
Continue Reading
Very few people out there know of this little trick that you can download and install Apps on your Android devices using your computer. Just log into your Google account and open Google Play. From there, find the app of your choice and click install. You will be shown a drop-down menu containing your Android […]
Continue Reading
Amazon Alexa is a voice assistant that can make your life smarter, comfortable and easier, but only if you know the right commands. Here are some of the commands you may want to know for your daily life activities. To start with; With your Echo or other Alexa device, use the activation word “Alexa” to […]
Continue Reading