Interview with a Wiki Ninja and SQL Server Guru Winner: Shanky 621

Today's interview is with Shanky_621.

Shanky_621's avatar 


Shanky has 19K Recognition points, over 1K forum answers, and he has 3 TechNet Guru medals (for SQL Server), including 1 gold medal! 


SQL Server is also my product I work on, so I love to see community members championing SQL Server!


Let's get the interview started!



Who are you, where are you, and what do you do? What are your specialty technologies?

Hello everybody I am Shashank Singh.I am from Mumbai ( India). I am married to a beautiful wife .I am very patriotic person and believes that best service one can do is a service to motherland. I am currently work for Tata Consultancy service a big Software service provider company.



What are your big projects right now?

As of now I would be moving to UK for a new project.Project is about  SQL server performance tuning and business Intelligence.I am going their as a consultant .I have worked on SSIS before but their I would get more involved in SSIS (one of the SQL Server features that I love the most). I have worked extensively on SQL Server memory and locking. Both of these topics fascinate me the most. The more I try to go deep the more it eludes me.

What is TechNet Wiki for? Who is it for?

Well I prepared  a bit to give answer to this question. Wiki is Where I can Keep my Insights. I love wiki very much as this a best source of pure and advanced knowledge about SQL server and its applications.
TechNet Wiki is for beginners as well as experts. You can find all kind of articles here. Sometimes the more the simple it is the more classic it is.


What do you do with TechNet Wiki, and how does that fit into the rest of your job?

Quality of knowledge is such that the more you share the more you learn. This is how I see TechNet Wiki. Things that I learn from the forums or from my day-to-day activities, I share it in turn. The things that I learn from Wiki and Forums I try to implement in my Environment. So TechNet Wiki is kind of attached to my Job.



What is it about TechNet Wiki that interests you?

The Knowledge and the discussion. Your answers /articles are reviewed  by some of the industry experts and yes I have received good feedback from the judges. This makes me feel that I stand somewhere in the community and yes I can also contribute to this community as I am valued here.


On what articles have you collaborated with other community members on #TNWiki? What was that experience like?

Not got chance to collaborate actually. But their feedback was pretty real and awesome.

On what Wiki articles do you spend most of your time?

Currently I am working on SQL Server memory and locking behavior. I will try to come up with an article related to SQL Server memory. I spent lot of time on my article What does Log truncations counter signify.


What are your favorite Wiki articles you’ve contributed?

The 2 below are my favorite:

What does log truncation counter signify

Understanding lock escalation

What are your top 5 favorite Wiki articles?

Almost every article teaches you a lot. But I love articles By Uwe Ricken.


What could we do differently on TechNet Wiki?

Like there is PASS summit. Can we have a TechNet Wiki summit where we can call different authors and discuss SQL Server? This will only include non Microsoft guys. (Just a thought.)


Who has impressed you in the Wiki community, and why?

All those who post in Wiki are awesome and wonderful. I try to judge an article not by who has posted it but by how much knowledge it provided. For me, each and every article is something to learn for. Some one who has impressed me on TechNet Wiki is Uwe Ricken. I seriously love his answers. I guess I can learn lot about indexes and SQL Server internals from him.

From the Forums I must mention Olaf, Saeid, Uri, Naomi, Ed, Sathya, Dan, Tom, and Sean; I learned a lot from their posts and answers.  I must also thank to all the persons who posted question on forum ,their questions challenged my capability and forced me to extra distance to find the answer.

What does success look like for TechNet Wiki?

Its already successful.

Thank you to Shanky for all your contributions to the community!

Here is my favorite quote from the interview: "Wiki is Where I can Keep my Insights."


Please join me in thanking Shanky and asking him any further questions.

I have one question for Shanky: You said, "Can we have a TechNet Wiki summit where we can call different authors and discuss SQL Server? This will only include non Microsoft guys. (Just a thought.)"

What would that look like? Would it be an annual event for one week (multiple sessions that week), but all the sessions are virtual (over Lync)? That would be pretty cool! What do you think?

   – Ninja Ed

Comments (45)

  1. Shanky_621 says:

    Hello Ed,
    Thanks for interview .For your question I would like it o be Annual event for one week keeping sessions virtual.

  2. BhushanDBA says:

    Congrats Bro!!! Keep up the good work

  3. Shanky_621 says:

    Thanks Bhushan and Mahesh

  4. Congratulations Shanky. Great interview and great work in the community.

  5. Durval Ramos says:

    Congratulations Shanky. Very good “SQL Server man” and good luck in your new project

  6. Shanky_621 says:

    Thanks Durval and Hezequias

  7. Hey Shanky, I love your quote “Wiki is Where I can Keep my Insights”!

  8. Congratulations Shanky!! Tata Consultancy is fortunate to have a passionate SQL engineer like you.

  9. Shanky_621 says:

    Thanks Matthew.This is actually what I do with Wiki…

  10. Saeid Hasani says:

    Really nice quote: “Wiki is Where I can Keep my Insights.”

  11. Saeid Hasani says:

    Thanks Shanky, I also learn many thing by reading your WIKI articles and Forum answers!
    and Thanks Ed for providing this great interview!

  12. Shanky_621 says:

    Thanks Saeid..Its always nice interacting with you

  13. Anonymous says:

    Congrats Shanky …

  14. rahuljain8910 says:

    hiii …shasank ….great job .I am also learn many important things from your blogs about different topic on sql .thanks for such a great post and best of luck for your future.

  15. Saeid, you’re welcome! I also really love that quote from Shanky!

  16. “Hello Ed, Thanks for interview .For your question I would like it o be Annual event for one week keeping sessions virtual.” — Shanky, I think that is a great idea! Let’s move to Skype to discuss this. Would it be the TechNet Wiki Summit?

  17. pituach says:

    Congrats Shanky,
    Great interview 🙂

  18. Punit Porwal says:


  19. Shanky_621 says:

    Thanks Sathya and Pituach

  20. Shanky_621 says:

    Thanks Rahul…way to go buddy

  21. Shanky_621 says:

    Punit totally surprised to see you but anyways thanks a lot

  22. Shanky_621 says:

    Ed thanks for giving some idea to my thought.I already mailed you regarding the same.Will get in touch with you shortly

  23. JK says:

    Congrats Shanky!! And an awesome idea – the Technet Wiki Summit !!

  24. Saeid Hasani says:

    Thanks Ed, I was really busy because of transferring to new company and involving in a performance tuning project. I have more time now, but I am in trouble with internet connectivity problem that issued by my ISP right now. They promise me to solve my problem tomorrow. I hope start my activities tomorrow and continue my regular basis participating with WIKI and Forum. Sorry for having low participating. I will improve it soon.

  25. Saeid Hasani says:

    In addition I have one little suggestion: “It’s good to have an sticky forum post for interviews like this for one week to encourage other forum users to participate in WIKI”.

  26. Shanky_621 says:

    Saeid its already mentioned in Peter Laker’s post that If you Win you will be interviewed.Do you still want to make it sticky

  27. Testing…

    Multiple line breaks in comments.

  28. Divya Singh says:


  29. Shanky, where is that location where you’re in the snow? Was it on a vacation?

  30. Mr X says:

    Congrats Shanky, you deserve it 🙂

  31. Shanky_621 says:

    Ed..this place is Sikkim Its in North East India.It was a vacation .Temp was just about 2-3 degree centigrade and I was enjoying the chill air. 🙂 with my jackets open

  32. Shanky_621 says:

    Thanks Ahmed Aka Mr X 🙂

  33. Shanky, nice and cold! It looks beautiful!

  34. Saeid Hasani says:

    You are right Shanky! BTW, I don’t have your contact info like fb or twitter account to be in touch with you 🙁 So please send an email to me to be in touch with you. (My email: my first name + my last name Thank you Shanky!

  35. Davut EREN says:

    Congrats Shanky 😉

  36. Anonymous says:

    Welcome back for another analysis of contributions to TechNet Wiki over the last week.

    First up, the