Friday, August 12, 2016

List all stored procedures which are modified recently in a SQL Server database

In SQL Server Management Studio:

  1. Navigate to your database > Programmability 
  2. Press F7 (or) View > Object Explorer Details
  3. In the Object Explorer Details window right click anywhere on the header row and select "Date Last Modified" field (in case it isn't selected already)

T-SQL Script to achieve the same result:

Option 1:

FROM sys.procedures
WHERE modify_date > '2016-08-09'
ORDER BY modify_date DESC;

Option 2:

WHERE routine_type = N'PROCEDURE'
and last_altered > '2016-08-09' 
ORDER BY last_altered DESC;

Thursday, May 12, 2016

Transform your fear to success

During my days as an MVP (Microsoft Most Valuable Professional), I used to mentor few juniors from the community. One of them used to be very low on confidence and fear of failure was hurting him more than anything. Recently while cleaning up my mailbox found few of the old emails which I have sent him - cleaned it up a bit and just compiled all those into this article.

Important Life Lessons from Cycling

Over the past two years, I acquired many life lessons from cycling. However, after careful thought, I have decided to share the most significant life lessons I have learned in this article

Thursday, July 30, 2015

#ComeBackHome - Join hands to find missing children

In continuation to my earlier post Finding Missing Children in India I have been looking out for more ways by which we can help track and find a missing child. In that process came to know from my friend about

On the first look it definitely sounded like a great idea. The concept of this plugin is by just adding one single line of code in all websites we can get the entire internet search for the missing children. When the visitor click on the banner it will show the missing children in their geographical region. This plugin is integrated with multiple missing persons databases including Interpol, NCMEC (The National Center for Missing & Exploited Children) and NAMUS (National Missing and Unidentified Persons System). That said, if we know of any other countries authentic databases the code can be integrated with that too.

If a user of a website navigates to a page that does not exist, either because the user has mistyped an URL or trying to open an old bookmarked link which is not valid anymore it throws an error message: "HTTP 404 - Page Not Found". Why not make use of these pages to locate missing people? That's exactly what does. It adds an unintrusive banner with photos of missing people to any website's 404 error pages, with a hope that someone who visits the site might recognize the missing people.

"Saving one life is all it takes to make it worth the effort!"

Refer the below images to see how it would look for example in

If clicked on the banner this is how it would look like

There were few obvious questions which I wanted to get it clarified from the creators of this plugin - Bipin Suresh & Yang Su. So reached out to the contacts listed in their site and Bipin responded back with his detailed response. Thought would write about couple of those Q&A here.

1. Why are we targeting only "404 page not found" page alone? On production environment the probability of seeing this is very minimal isn't it?

When they built this plugin, they knew that the only way to make this an easy sell would be to make it as easy and painless as possible for website owners. Any obstacle (like the potential loss of traffic) would add to the inertia of not integrating. The reason they chose to promote this on 404 pages are:

  • These pages are high volume but low value
  • Convincing website owners to add this to their main pages is a harder sell
  • '404 - Person Not Found' is catchy and memorable

That said, yes, if we could convince people to add this to other pages, that would work well too, especially since, as we observed, those pages offer a magnitude of order more traffic.

2. How do we validate the authenticity of data?

As mentioned earlier the plugin is integrated with national / international databases of missing people. All vetting of records is done by these authorities.

So as a reader of this blog post what can you do?

A. CSR - My humble request is as part of CSR (Corporate Social Responsibility) if organizations integrate this in their website it would be a great help to the society. This will definitely show your company as progressive, socially very responsible and more importantly will create a social pressure for your competitors / others to follow suit. If the entire internet is searching for missing people I strongly believe they would be found. Can you please try to champion it in your organization? No harm in trying isn't it?

Think about this - somebody kidnaps a kid, based on the complaint it gets logged in the countries authentic database, from the next minute it will be flashed to users in appropriate geographical region - this will effectively restrict kidnappers movement to a very small circle & help find the kids quickly.

B. Have an Idea - Do you think you have an idea to make this better? The source code can be found here - please help them improve and make it better OR send it to the contact details mentioned in their site.

C. Help find databases in non US region - As we know this may not be the most current or up-to-date datasource for non US region. Reason being most of the international data is taken from Interpol which might not be up-to-date. The results are ranked based on recency and geography, but the underlying datasource should be rich and plentiful for relevancy. Please help find authentic databases of missing people in your country: especially in places like India, where data is sparse, and distributed.

Everybody in the world lead their life with hope and with this little effort from our side we can hope that there is a chance that someone who visits our site might recognize them. At the end of the day, even if one child is found with this effort, that's the end of one parent's nightmare.

If God knows everything that happens on Earth, and he can communicate with us, why doesn't he tell us the whereabouts of children that go missing? - Geronimo Jones

Monday, July 13, 2015

Finding missing children in India

Recently I come across at least one missing child information shared by my contacts in social media every week. The thought of what might their near and dear one's be going through in those period until they find the child is very disturbing. How on earth somebody is able to kidnap a child? Has money become so important in life that we lost all our moral values?

Few days back came to know that my cousins friends son was missing. I don't know for some reason it has been so disturbing that i haven't come out of that yet. During that period, came across couple of sites relating to this and I believe those weren't well advertised among the public. So thought I would do my share by writing a blog post and spreading the word around.  

These where important websites launched by government of India (Ministry of Women's and Child development) where one can register the details about the missing child. Since its government of India initiative hoping required focus would be there from the concerned authorities!!

1. Khoya Paya (Lost and Found) -

Important: Please note currently if you don't have a mobile number then you cannot register and post in this website. Also apart from posting it here its mandatory to register a FIR in the police station as well.

Steps to be followed by the Parents/Citizen in case a child is missingextract from

  • Dial 100 for police (or) 1098 for CHILDLINE.
  • Go to the Police station and register an FIR.
  • Upload the information of the child on the Khoya-Paya and other similar portals.
  • Think about what your child was wearing when you last saw him/her. Was he/she carrying with him/her, a mobile phone, money, bank cards, any items of sentimental value such as toy etc.?
  • Notify all local media assignment desks.
  • Make a list of / talk to friends, acquaintances, and anyone else who might have information or clues about your child.
  • If you know where your child is and you are still concerned for their safety (e.g. if they are at a house where you suspect criminal activities are taking place) you can ask the police to carry out a welfare check on that house or location.
  • Parents should immediately inform the Station Master or officer concerned at nearby railway station as usually trafficking or migration of children mostly takes place through railway route.
  • Rapidly create and disseminate posters to help generate leads.
  • Remember - NEVER GIVE UP HOPE!

Check out the Dos and Don'ts section of this site which talks about "What you can do to protect your child?"

Tips for parents to help their children stay safe - Extract from Do's & Don'ts section of

Safety at Home

A. Children should know their full name, home address, home phone number and how to use the telephone. Post your contact information where your children will see it: office phone number, cell phone etc.

B. Children should have a trusted adult to call if they're scared or have an emergency.

C. Choose caregiver/nanny with care. Obtain references from family, friends, and neighbors. Once you have chosen the caregiver, drop in unexpectedly to see how your children are doing. Ask your children how the experience with the caregiver was, and listen carefully to their responses.

Safety in the Neighborhood

A. Make a list with your children of their neighborhood boundaries, choosing significant landmarks.

B. Interact regularly with your neighbors. Tell your children whose homes they are allowed to visit.

C. Don't drop your children off alone at fair, market places, railway stations, bus stands or parks.

D. Teach your children that adults should not approach children for help or directions. Tell your children that if they are approached by an adult, they should stay alert because this may be a "trick."

E. Never leave children unattended in an automobile. Children should never hitchhike or approach a car when they don't know and trust the driver.

F. Children should never go anywhere with anyone without getting your permission first.

G. Children should never go anywhere with anyone without getting your permission first.

Safety at School

A. Be careful when you put your child's name on clothing, backpacks, lunch boxes or bicycle license plates. If a child's name is visible, it may put them on a "first name" basis with an abductor.

B. Walk the route to and from school with your children, pointing out landmarks and safe places to go if they're being followed or need help. Make a map with your children showing acceptable routes to school, using main roads and avoiding shortcuts or isolated areas. If your children take a bus, visit the bus stop with them and make sure they know which bus to take.

Please check the Do's and Don'ts section of this site as it has other useful information's like:

1. How to talk to your Child (tips for discussing child safety)
2. What you can do to help your Child (tips for parents to help their children stay safe)
3. What your Child can do (the rules for younger children)
4. What your Teen can do (the rules for older children)
5. What your Child can do (at school and at home)
6. What to do in an Emergency (numbers to call and information to collect)
7. How to keep you Child safe in information superhighway (golden rules for safe browsing)
8. Additional resources for parents and children

Hoping for a day when child kidnapping, abuse & trafficking stops completely and these websites becomes obsolete. Till then lets stay safe people.

One missing child is one too many - John Walsh 

Sunday, September 28, 2014

My Second Brevet - 300 BRM Freedom Ride

After completing 200 BRM on June 21st 2013 (ECR Classic 200 BRM) was enjoying the success for too long that I didn't practice for quiet sometime. Even registered for 400 BRM for July but dropped out on last minute as I wasn't feeling well. During that period Kandappa Sir posted in Madras Randonneurs about a crash course he is willing to take for folks who are interested in attempting 200 / 300 BRM. Didn't think twice before requesting him to consider me as well and from then on no looking back. Took the practice rides seriously and followed it religiously. 

Me and my worries!

Couple of things I was worried about were:

  • I have never rode during night time on highway and was little worried on whether my headlight would be powerful enough to show me the way. 
  • Never during a ride I had ate anything apart from energy bar, tender coconut, Gatorade or Juices. But for a 20 hours ride one can't survive like that alone.

To overcome this fear I decided to face it and see what exactly happens instead of sitting on a sofa with a worried face. On 27th July started my ride after sunset. Chose Ramapuram - Porur toll gate - Tambaram and Loopback to Ramapuram as a route which I had never rode before. Once I crossed Porur toll gate after few minutes it was pitch dark and I was depending only on my Headlight. The fear was there for few minutes so I was pedaling as slow as possible and then I got used to the situation. After 10 minutes it became like a meditation - Me, My cycle and the Road that's it. I covered 41 kms in 1 hr 54 mins and felt more comfortable on handling the night portion of the event.

On 3rd August took a long ride on NH45 along with my friends and chose that to be my practice ride for eating during the ride and try to do the whole stretch in 2 - 7 gear combination as much as possible. Started at 4.15 AM and we reached Maduranthakam by 8.15 AM. Took breakfast there and was hoping my stomach doesn't get upset with my new decision :) Reached home at 2:15 PM and all was well.

Let's go Shopping

On the day before the event visited Nuts n Spices in Nandambakkam to purchase few things needed for the ride. Bought Gatorade and Energy bar but the more time i spent there more I was feeling that everything would come in handy on the ride day :) 

Ok the fun(?!?) part was I didn't even carry 1/4 of what I had purchased as my backpack was overweight already :) Btw do we really need to carry a backpack? That's a debate for another day but I am used to carrying 3 to 4 kg with me so no issues.

Get - Set - Go

Arrived on the venue just 5 minutes before start, got the cycle inspected and Brevet card sealed by Partha quickly. As did on my earlier BRM again started slowly and rode under 20 kmph for ~15 minutes before settling on my regular speed. Mid way to the first control point met Raghav, SaiRam and from then on we rode together. The plan was to ride along with Raghav till the second control point (102 kms) where he would take the U turn towards Chennai while myself and SaiRam would continue our 300 Kms journey.

On the Vandallur - Kelambakkam stretch got a chance to meet Vel Annamalai (One of the few persons in Chennai who have completed 1000 kms already). We rode together for few minutes before he sped away. After crossing Chengalpattu toll gate had our breakfast at Hotel Nellai and reached the second control point at 10.56 AM. Varun Spike, Vallab was manning this control point and Vallab was seen doing some stretches for another rider.

By the time we reached the control points all water CANs have already been emptied by other riders :) That's where my backup Gatorade bottles came handy. Refilled our water bottles in a shop after crossing Melmaruvathur and then continued our journey towards the 3rd control point @ 152 kms. 

Mentally started noting down hotels on the way - 18 kms before U turn point Vasantha Bhavan (veg), 12 kms before U turn point there was another Veg hotel, Hardly 2 kms from U turn Point Hotel Anjapaar (Non Veg) just in case we didn't find any good hotels near the control point where prepared to ride to one of these hotel to have our Lunch.

At last reached that control point at 1.35 PM and Guru welcomed us with some good photo clicks. We rested for few mins and took the U turn towards Chennai. Both of us first thought of having our lunch at Anjapaar as its logical to go to the nearest hotel. But on nearing that place we were not so comfortable and decided lets go to the next one at 12 kms. Just stopped to buy couple of water bottles and continued our ride towards the next hotel. On reaching that SaiRam didn't like it because there wasn't any customers in the hotel at that time so decided to go to Vasantha Bhavan itself :) So started riding for another 6 kms for lunch. Had full meals and started to continue our return journey. Few mins into the ride noticed the first problem of the day! Was not able to bring the gear down to 2 - 6 :( Tried my best but the shifter was too hard and because of the fear that it might break I stopped trying further and decided to ride the remaining distance in 2 -7 itself. Though it wasn't so tough on a flat surface but climbing bridges was really challenging. 

Unlike 200 BRM the terrain wasn't flat and there were lots of bridges to climb - was wondering why the hell do they need to build so many bridges :) The below image posted in MR FB page sometime back is what came to my mind immediately.

During this period as well we did manage an Average of around 21 kmph and as planned halted at Sangeetha Restaurant in Vandallur for dinner. That's where started getting the pain back on the ligament tear which I had very long time back on my left knee. I still believe this should be because of the extra strain on my legs as I wasn't able to bring down the gear since ~175km point.

Post dinner took the Vandallur - Kelambakkam road and was really surprised to see the roads weren't properly lit!! I believe there are many colleges on that stretch and at least they should take steps to have proper road lights on that stretch for safety of their college hostel students.

Reached the next control point which is an ATM at 9.10 PM. It wasn't working so took a snap in-front of the ATM along with SaiRam and started riding towards Velachery Just Buy Cycles (Finish Point) which we managed to reach at 10.28 PM.

Very happy to have completed 300 Kms ride comfortably and after resting for sometime thought of riding back home which is just another 12 kms. As the mind knows that the event is over it started finding reasons for not riding back home. So after phoenix mall took an auto and loaded my bike in it and started to return home. The auto driver was curious on what I have been up to with my cycle at this time of the day :) tried explaining him about the event and looks like he was quite impressed. On reaching home gave Rs. 250 which he had actually asked for that short 12 Kms distance claiming late night!!, tough to get customers from there to his home etc., but to my surprise he returned Rs. 100 and said that's enough sir. He asked me to take care of my health and get some hot water bath that night :) 

Overall the training scheduled provided by Kandappa sir was really useful and it prepared me physically and mentally for the ride. Thanks a lot sir. Looking forward for your training schedules for 400 BRM now :)

Hope you enjoyed reading my experience! Happy Cycling.

Friday, August 29, 2014

Type of Bike / Cycle to buy

Since lately I have been posting my cycling adventures in my Facebook account many of my friends have been asking suggestions on "What types of cycle should I buy?", "Tell me the best Brand of cycle to buy" etc.,

Though I am not an expert on this yet thought of sharing what I understood till now and leave for the experts to comment and help me correct any content which they feel might be misleading for the readers.

My Top 4 Learning as of now

1. DON'T just go by Brand
2. Fix your Budget - Because there are bikes from few thousands to 2+ Lakhs :)
3. Be clear on what sort of terrain you plan to ride / Major purpose of this investment
4. Test as many cycles, brands as possible and see which one YOU are comfortable with.

Majorly these are the 3 types of bikes I tested: Road Bikes, Mountain Bikes (MTB) and Hybrid Bikes.

I had always loved the Brand Cannondale and Bianchi a lot. So I had made up my mind to buy only one of these brands. But after test riding ended up buying Scott Sportster x20 - Its an Hybrid.

Let me jolt down my version of difference between these 3 types of bikes and why I went for Hybrid version.

Road Bike - For me anytime its the stylish of the lot and most of the time it has a drop (handle) bar. All bikes I had tried have been lightweight with very sleek tires. Out of the 3 types of bikes this was faster as well. Unless you tend to ride ONLY on properly laid road (tarmac) and have a budget of INR 50K+ this option is ruled out.

Mountain Bike (MTB) - When I tried out MTB felt it to be little heavy when compared with the other 2 types of bikes. It had bulky tires which is called as Knobby tires. If majority of the time you would be doing off-roading then this is the type of bike for you. I tried it on a proper tarmac road (as that is the terrain am majorly interested in) and felt to be little slower than Road / Hybrid bikes. I don't remember the price range now but i think any decent MTB would cost upwards of INR 25K+ as well.

Hybrid Bike - Its a mix of Road and MTB!! Based on the bikes I had tried this was slightly heavier than Road Bikes but lighter than MTB. This had the straight / flat handle bar as MTB. Tires weren't so sleek as Road bike but definitely sleeker than that of MTB. Found it to be faster than MTB and less energy consuming. This can be used to ride on properly laid road as well as some sort of light off-roading :) I believe we can get Hybrids for around INR 15K or 25K range.

My main purpose was to commute to office and also use the same bike for Endurance rides organized by Tamilnadu Cycling Club and Madras Randonneurs. The budget I had in my mind was max INR 25 or 30K (inclusive of all accessories). So Road bike was straight away ruled out for me.

With that budget I could have gone for either MTB or Hybrid. But based on test riding I felt doing long distance endurance rides with MTB (say 100+ kms) might need to use more energy than if done with Hybrid. So ended up buying the Hybrid bike which I have now.

FYI - cycles comes with shock observers, disc brakes etc., as well (mine doesn't have it though). But bottom-line more the features you are going to expect more you might want to shell out from your pocket.

As of now very happy with my decision and in 2014 till now have cycled 4900+ kms out of which ~1500 kms of Office commute, have done multiple 100 kms rides as well as completed 200, 300 BRM using the same bike. Hoping to try out 400 BRM also with this and beyond that would be too much of stretch and not very sure as of now.

Happy Cycling!