Technology Archive
15 Feb 2018
SQL to get counts by statuses and completeness
SQL to get counts by statuses and completeness Recently I came across a need to get the counts of result by statuses as well as completeness – i.e. getting positive result (pass) in all cases. I quickly
9 Feb 2018
JSON Parser Array inside array dotnetfiddle .net’
Have you struggled with JSON parsing array inside array? I was not able to find any solution online but then I created something using dotnetfiddle. Hope it can save time for someone. First step is to
6 May 2017
SQL Script – Insert into table only if row does not exist
By Exuberant India On 6 May 2017 In SQL
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?
By Exuberant India On 3 May 2015 In Technology
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
16 Nov 2014
World’s Largest Aircraft- Must See!
By Exuberant India On 16 November 2014 In Amazing, Awareness, Fun, Information, Interesting, Knowledge, Technology, Travel
This is Big Bird, actually it’s bigger than big. One of the reasons why Russia doesn’t want to give up the Ukraine. Kiev is the manufacturing site for this unique aircraft. http://gelio.livejournal.com/193025.html
28 Mar 2014
ISS spacecraft CURRENT LOCATION AND VIEW
ISS SPACECRAFT CURRENT LOCATION AND VIEW Also click on SNAPSHOT when they are over populated areas, then move in until you can see cars, buildings, etc. This is absolutely fascinating!!! Keep this link on file and check
2 Dec 2013
Rebuild all index in a database
Several times my colleagues asked me about rebuilding all indices in a database. While there are several solution available, I like to use the one below. Please note that sp_MSforeachtable is undocumented but internal so we can