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. !