Interview with Jayakumaur(JK) – Transact-SQL – TechNet Guru Competition Gold medal Winner

Today's the interview will be with Jayakumaur(JK) . JK is a Transact-SQL Technical Guru Gold medal Winner – February 2014.



Here are some his stats:

• Published 4 TechNet wiki articles, including   

               Gold medal article – Transact-SQL Technical Guru – February 2014    

               Bronze medal article – SQL Server General and Database Engine Technical Guru – February 2014 

• 5k Recognition Points on MSDN forum

• Published 5 Gallery scripts

He is also a regular visitor to Chennai SQL Server User Group meets.

Let's start the interview:

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

I am Jayakumaur aka JK, a SQL enthusiast from Chennai, India. Being passionate about programming in general, I am currently working as a Database Developer with a leading MNC.


What are your projects right now?

I’m currently involved in developing a customizable payroll report generation system using SSIS and SSRS for a client based out of UK.


What is TechNet Wiki for? Who is it for?

Wiki is for anyone who wants to learn and contribute back from what they have learnt. Also, personally I feel wiki as the place to hold solutions to common problems which are being raised as issues in the forums from time to time like pivoting, splitting a column to multiple ones etc. to name a few.


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

I use TechNet wiki on a day to day basis to learn new technologies, concepts and features. It also helps me to contribute back what I have learnt in the form of new wiki articles, gallery items etc.

What is it about TechNet Wiki that interests you?

Community contribution. Microsoft technologies enjoy one of the most active communities online, and this TechNet wiki is yet another example of that!

The wiki is totally based around the community, with the members posting articles on a varied set of concepts. The exceptional part is that, other Gurus and Experts in the field voluntarily pitch in, edit and contribute to the article taking it up a few notches higher!! And one mustn’t forget the TechNet guru contest that serves as a great motivating factor!!


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

On TSQL articles generally, looking to learn new tricks and ways of writing better and efficient queries. Also fixing articles that require any additional explanations, corrections etc.


What are your favorite Wiki articles you’ve contributed?

Ha-ha… All of them of course


What are your top 5 favorite Wiki articles?

All T-SQL and SSIS related articles.


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

There are many including: Ed, Naomi (she’s omnipresent – Forums, Blogs, wiki everywhere!!), Ronen aka Pituach (Patient and dedicated), Shanky


What does success look like for TechNet Wiki?

TechNet wiki has been and is continuing to be an astounding success. A simple example would be the number of articles being put forward for the TechNet Guru contests and the quality of them! Wow!!


Last but not least, I would like to thank MVP’s Madhu K Nair and Vidhyasagar for having inspired and motivated me always. I am privileged and grateful for having come under their tutelage.

Looking forward for many more successful days ahead…



Thanks JK for this great interview.

Please join me in thanking JK for all his contributions to the community, and feel free to ask him any further questions. !


Comments (23)

  1. Davut EREN says:

    Thank you for good interview SathyanarrayananS. Nice to meet you Jayakumaur

  2. Saeid Hasani says:

    Pleasing to read this interview! Congrats JK! Thanks Sathya! 😉

  3. Shanky_621 says:

    Congrats for getting interviewed JK. I am thankful for your feedback.

  4. Wow. Congratulations JK. Great interview SathyanarrayananS.

  5. Congrats and good to know you !!!

  6. Durval Ramos says:

    SathyanarrayananS, Great interview !

    Congrats Jayakumaur.

  7. Awesome! Great to meet you, JK!

    Also, I think this is Sathya’s first blog post, right?

    Thank you both!

  8. JK says:

    Thanks a lot guys 🙂 Great to be a part of this awesum community!! 🙂

  9. Sathya,

    How long have you been an MVP?

  10. Ed,
    Yes, this is my first post and I was awarded as SQL Server MVP for the first time on Jan-2014.

  11. Congratz sathya ! welcome to the MVP-world !

  12. Sathya, well you have to tell us so that we can celebrate with you!


  13. Anonymous says:

    I just wanted to officially congratulate Sathya on winning the MVP award back in January 2014.


  14. Congrats JK!!!!!
    Great article..Nice interview.

  15. Thanks a lot Prashanth!! 🙂

  16. Thanks a lot Prashanth!! 🙂

  17. Big thanks to Davut, Saeid, Shanky, Durval, Mahesh and Ed!!
    Sorry for the late response.. I have been experiencing sm kind of a problem with blogs which goes on to say – ‘Page not found error’ the moment i log into blogs.. ! ~

  18. its a privilege shanky!! Your articles are enlightening!

  19. Anonymous says:

    Hello Community!
    Today is Wiki Life and I’ll talk about the Blog for TechNet Wiki (Wiki Ninjas