2015: What’s in the box

“If I had only one hour to save the world, I would spend fifty-five minutes defining the problem, and only five minutes finding the solution.”                   ~Albert Einstein


2014: The Year that was

  • Made me a proud father (on Nov 3). Thanks to Prangya, my wife.


  • Gave me a promotion to a WL2 (Sept)
  • I Completed 72 Hrs of IT training
  • Took a online webinar
  • Spoke in the User Group (Community)
  • My Brother Got married.
  • Our website is live (Thoughts2share.in)
    • Thanks to Lalit Sir and Pranay
  • Attended a Google Summit on mobile
  • Attended a Microsoft Azure Summit
  • Completed a number of Pluralsight videos
  • 5000 tweets completed and the lesson learned is “Quality matters not the quantity”

2015: This year I have set some goals

  • Learning  CLEAN CODE
  • Learning, implementing and sharing with the community
  • Do things right and doing right thing also
  • Imparting Training again …
  • Be pragmatic as much as possible
  • Refactoring as much as possible
  • JAVA script frame works to be explored
  • Deep dive to NOSQL
  • Write blogs
  • working the agile way
  • and a lot more….
All of us every single year, we are a different person. I do not think we are the same person all our lives. ~ Steven Speilberg

Till next Keep Smiling ….

WEB API: What to learn and where

The buzzing key word in the IT industry is “WEB API” and almost all the leading organization have registered there APIs for the world to use. API is an acronym for Application Programing Interface. WEB API is an interface that defines a request-response message system and expressed by either JSON or XML.  By crafting their APIs these companies target the developer as their customer. So for a developer its essential to learn the APIs and their usability for their respective applications.  WEBAPIs are RESTful in nature and as a developer we must know the rules of making our application restful.

We have masters in the world for WEB APIs, but this article targets absolute new comers to the world of WEB APIS. This is like an index for your WEB API learning and I have tried my best to compile as many resource as possible to strengthen your learning. As you read the article and move along the page your interest might increase to add something else that I have missed, make sure to put a comment if you want to suggest something.

Knowing REST

Defining WEB APIs


Training Videos


WEB API Design

API Documentation

List of APIs

HTTP Status Code / Server Header Response




Further Reading

Point to consider (But make your own choice)

  • At max try to use two base URLs per resource  (GET/Lists, GET/Item)
  • Collection goes better with HTTP verbs.

Finally if you are in Indian and want to develop some apps for Indian Railways , there is a API for this as well Smile surprise!!! , check here : http://railpnrapi.com/

Well Keep smiling, till next.


MS-OneNote session at SQLBangalore User Group

On 28th of June 2014 I took a session on

Increase productivity using the Microsoft OneNote

The best part was initially most of the audience said they don’t know/have not seen Onenote and after the session most of them agreed to start using the same. After a day we got tweets where in they said they have already started using OneNote.

Get OneNote free for All your notes on all your devices.

Windows Windows Store Windows Phone Mac iPad iPhone Android Amazon Web

Here is the slide share link.

Till next “keep smiling”

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

A San Francisco cable car holds 60 people. This blog was viewed about 1,400 times in 2013. If it were a cable car, it would take about 23 trips to carry that many people.

Click here to see the complete report.

Keep smiling and make it contagious. Happy New Year 2014


May this new year brings lots of inspiration inside you to make you self efficient in the area you are growing.


Keep smiling and make it contagious.


Smiles from the threshold of the year to come,
Whispering ‘it will be happier’…
Alfred Tennyson


A new year report http://manasdash.wordpress.com/2013/annual-report/

#3 MS-Office Gyan for the day: OCR in OneNote



Optical Character Recognition, usually abbreviated to OCR, is the mechanical or electronic conversion of scanned or photoed images of typewritten or printed text into machine-encoded/computer-readable text.


I tried exploring the OCR and other features of Microsoft One Note and its really cool. I might present in a layman style but believe me its awesome tool for your day to day notes. Just take a look how I explored One Note.


If you are using One Note get the One Note  apps for free from http://www.onenote.com/


Just open your OneNote and create your Tab and your page… yes all set. This is a simple note taking application but the capabilities what One Note has is mind-blowing.

Select the Insert menu and take a look at the Ribbon. Lets try couple of feature. We will start with the OCR.

We will read text from an image!!! Cool …Right. Lets do it.


Copy Text From Picture


Here I have inserted one of my picture where some quotes are there. I will try extracting the text from the picture. Its just two step.




Right click on the picture & select  “copy Text From Picture”  and when you are ready “paste your text any where”.



Now you try with various picture and explore the power of One Note.

Screen Clipping

How about taking screen shot in a  quick and effective way with time stamp. Now I am not talking about that old “Print Screen” method of taking screen print and paste it and then write timestamp by your own. Lets see how One Note helps.


imageSelect the Insert menu and select “Screen Clipping” and then suddenly you see One Note will disappear and will go to the background. Its giving a chance to you to capture a portion of the screen you are interested for. (next time Try the keys (Shift+ Windows + s) for a twist.)



Now once you select one area OneNote will take that portion and will paste in the text area of OneNote with a time stamp which reads like “Screen clipping taken <Date>”. I took a screen capture from my blog.





Now a task for you , If you have a scanner attached try the other option “Scanned Images”


Where next





Till next “Keep Smiling”.

Computer Science Education Week: Dec 9th to 15th 2013


Anybody can learn

If you have never learned computer , now this is your chance to learn and support for the “Computer Science Education Week”. If you are willing to learn the course materials are free. Just learn and spread the word.


Computer Science Education Week (CSEdWeek) is an annual program dedicated to inspiring K-12 students to take interest in computer science.

Originally conceived by the Computing in the Core coalition, Code.org is producing CSEdWeek for the first time this year, held in recognition of the birthday of computing pioneer Admiral Grace Murray Hopper (December 9, 1906).  (Source http://csedweek.org/about)


Code.org says

If you haven’t already, start your own Hour of Code. Help us reach 1 billion lines of code!


Some stats so far


12,241,183 have learned an HOUR of CODE


Different organization and BIG Boss of the industry are supporting for this cause.

Word from the Leaders and trendsetters


Aaron Skonnard from pluralsight said

We’ll award a full Pluralsight grant to the first 50 schools that participate in ‪#‎HourOfCode‬ and apply by Dec 15: http://blog.pluralsight.com/hour-of-code-grants ~ Aaron Skonnard


Even Khan Academy is supporting for this cause.


About Code.org

Code.org is a non-profit dedicated to expanding computer science education. The Code.org vision is that computer science should be part of the core curriculum in every school, alongside other science, technology, engineering, and mathematics (STEM) courses, such as biology, physics, chemistry and algebra.


I am learning courses from CodeAcademy and I am really happy with the content and the presentation.



Don’t wait , learn and be a part of the HISTORY.

New Mail Window–Just a line of code

In most of the website you might have noticed, the contact us or contact me link at the end. Once you click that it will open a new mail window of your default mail client and it will have the mention subject and a mail id in the to box. So we can achieve that with the below line of code.

   1: <a href="mailto:simplymanas@gmail.com?Subject=query">Contact Me</a>


in HTML5 I wrote this in the footer section in this way.


   1: <footer>&copy; simplymanas 2013

   2: <a href="mailto:simplymanas@gmail.com?Subject=From BR">Contact Me</a>

   3: <a href="http:\www.twitter.comsimplymanas">@simplymanas</a>

   4: </footer>


and it will appear like this

© simplymanas 2013

Contact Me @simplymanas


This article was also published by me in

Beyond Relational

Quote of the Day:

No person was ever honored for what he received. Honor has been the reward for what he gave.

–John Calvin Coolidge

#2 MS-Office Gyan for the day… (PowerPoint 2013)

In my last post I wrote about the new feature “eye dropper” in PowerPoint 2013, this time I am writing about another features of PowerPoint.


How many of you used a screenshot in your presentation?


So you have used the paintbrush or other such tool to make it more good looking and then copy it to the presentation in your PowerPoint. You might have saved it and inserted it as a picture as well.

How about using any open window’s screen shot on the fly while designing your presentation and without  any help of picture editing tools. Yes no need to take it to the paintbrush and giving it a final touch. Everything is ready for you in PowerPoint itself.



Open the Microsoft PowerPoint and you can start with a blank page or a template of your choice.

Now open the window from which you want to copy a screen shot to your PowerPoint presentation. Navigate to the page or the window and you are done. No copy, no screen capture, nothing. For example I opened my blog in IE i.e. web browser window.



Now lets get back to the PowerPoint presentation and click on Insert menu and take your mouse to the Screen Shot button of the Images area. Just keep it there and read the tooltip.

Take a screenshot!!!!!


Now click the Screenshot button with small camera and a plus image on it. It will display you a list of Available Windows, (the current opened one in your system). Now its time to pick up the one you want to insert as a screen shot. The dialogue box that appears is asking for a hyperlink to the page if it’s a browser window. Choice is yours…just go ahead Smile


Remember my choice !!


…and what you thought … easy right Smile Smile Smile . Just a few steps and we are ready with the screen shot.


Guess what… it opens with an option to edit the image , the picture tools is all set for you. Now edit your picture inside PowerPoint, instead of going to other picture editing tools.

Power point 2013 has more features and options like this and you can learn More From Here & Here.

Till next time “Happy Learning & Sharing” :)

SQL Bang UG…Completed A Quarter…Sharing is fun, sharing is learning

430589_10151249803289029_384269882_n       I joined SQL Bangalore User Group (#SQLBangUG) as one of the first 4 members and till date I am part of this “knowledge Hub”, where sharing is fun while learning.

It was Saturday, November 24, 2012 when the first SQLBangUG was hosted at Microsoft Signature Building, Bangalore, India. Vinod Kumar delivered the key note for the event with his unique style of welcoming all and introduced the speakers while explaining the core  purpose of SQLBangalore User Group.


"Sharing is fun, sharing is learning"


I was lucky enough by getting a chance to present a session on SQL Server 2012 and would like to thank Vinod and Pinal for giving  me an opportunity to deliver a a session at such a big event. Being a learner and a student this forum is going to help me a lot.

The First UG meet sessions were

1: T-SQL Pitfalls  Speaker: Vinod Kumar M, MTC – Technology Architect
2: Top 5 SQL Server 2012 functions Speaker: Manas Ranjan Dash
3: Contained databases Speaker: Sudeepta Ganguly, Sr. Systems Engineer – Atos
4: Column Store Index in SQL Server 2012 Speaker: Pinal Dave, Evangelist – Pluralsight

Also we had two surprise session by International Speaker Lynn Langit, BigData and BI consulting & Raj Chaudhuri from Microsoft, Mumbai on Index and Big Data.



Photo courtesy: Sandip Pani

Pinal Dave from Pluralsight gave away one year free subscription coupon of Pluralsight courses to one of the lucky audience and also he gave couple of his books and monthly coupons of Pluralsight to other attendees.

Sahal blogged about this event and  this was written prior to the event which shows the excitement level of the participants and the enthusiasm to learn something new.


By December 18 the group had added 300 members to its list Smile


The Second UG Meet was on Saturday, December 22, 2012

The sessions were as follows

1. Better together: Excel + SQL for Database Developers By Kamlesh Rao
2. Basics of Backups with SQL Server By Balmukund Lakhani, Microsoft
3. Intro to Indexing – Basics rediscovered By Sourabh Agarwal, PFE – Microsoft
4. Knowing sp_server_diagnostics output By Amit Banerjee, PFE, Microsoft
5. Tips and Tricks Session By Vinod Kumar, MTC – Architect


Amit Banerjee wrote a blog about the event which is the fastest ever published blog on SQLBang UG http://troubleshootingsql.com/2012/12/22/sql-bangalore-ug-meet/

Also an excellent coverage by our Super Star Balmukund Lakhani in his blog http://sqlserver-help.com/2012/12/23/coverage-report-sql-server-bangalore-user-group-meeting-2-22-december-2012/


and we did it! Crossed 400 Mark on 1st Jan 2013 ~ Balmukund Lakhani


Also we wished our members on new year day with this unique poster



The Third UG Meet was on Saturday, Jan 19, 2013 which focused on EXCEL based visualizations

1: Tour of PowerPivot with Excel by Vinod Kumar

2: Advanced Excel Visualizations by S Anand

3: Introduction to PowerView with Excel by Selvakumar

4: Surprise SharePoint Session by Pinal Dave


SQL Bangalore se Balmukund Lakhani without Cameraman


We were forced to postpone the SQL user group meeting (scheduled for 23 Feb 2013) by a week due to some issues with the availability of speakers.

Great Discussion and Knowledge Sharing in FB page


In between all these sessions the FB page of SQLBang was fully occupied by members where they discussed some live issues and shared great knowledge about SQL Server and the trend is going on with a lot of enthusiasm.


Next UG meet on 2nd March 2013

So What are you waiting for… join the SQL Bangalore User Group and experience the power of sharing through learning and be a part of the next UG meet on 2nd March 2013

This UG meeting is about multi-dimensional concepts. This is completely different from the relational engine we are aware off. Register at here

1: Start your journey with Multidimensional using SSAS -by Sudhir Rawat (Microsoft)
2: Introduction to Cubes -by Deepthi Anantharam (Technology Evangelist)
3: SQL Server 2012 Analysis Services – Tabular Mode by Karan Gulati (Microsoft)

Smile Smile Smile Today the group has welcomed its 791th member Smile Smile Smile


What & where


Facebook: https://www.facebook.com/groups/SQLBangalore/

Events Page: https://www.facebook.com/groups/SQLBangalore/events/

Twitter: @SQLBangalore

Twitter Hash Tag: #SQLBangUG

Download PPT from the Past sessions



SQL Bangalore UG se Manas Ranjan Dash

Till next “Keep Smiling”