technology Archive

6 May 2017

SQL Script – Insert into table only if row does not exist

SQL Script – Insert into table only if row does not exist There is always a time when you would like to insert data into a table only if row does not exist Do you need those re-runable
5 Mar 2017

12 Tricks Google Search Engine Provides – Search and Much More

Google is probably the most popular search site on the web, used for finding just about everything we need on the internet. Google has one of the simplest user interface but there are still tricks that you
27 Mar 2016

2 Big transformations by the tech giants – Facebook and Google

2 Big transformations by the tech giants – Facebook and Google Facebook, will be the information and learning center. It is already connecting everyone, the next thing will be instant news like instant article. Facebook will transform
3 May 2015

Are Web Apps The Future?

Are Web Apps The Future?   There has been a lot of discussion on native vs hybrid app but what is really the future of apps. I think web app is the future. Probably some of the
3 Dec 2014

Future of smartphones – phone on your skin – see the working prototype

This is amazing. Smartphones will be all virtual, water proof and probably no weight. This is is a working prototype. Take a look at this android prototype from Cicret  
24 Sep 2013

Business Intelligence (BI)

What is business Intelligence I am sure a lot of people can define business intelligence but what we need to know is how it applies to us our business, our life and things we do. Over the
21 Sep 2013

How to get Windows Folder sizes recursively

Ever need to know the folder sizes that has several sub-folders, windows explorer takes really long time and requires checking properties of each folder. This script will do the job just need excel installed on your machine
21 Sep 2013

SQL Server FUN – Split received string using XML

Several time, we have a need to split the string based on a delimiter, for instance to handle multiple input filter parameters etc. Most of the time we end up using a user defined function that accepts
21 Sep 2013

SQL Server FUN – Identity insert

Insert in identity column for a table Sometimes there is a need to insert data into a table that has identity column. Example when you would like to restore a table from a backup including the same