Microsoft TechNet Wiki T-SQL Guru - Winners for December!!

The results for December's TechNet Guru competition have been posted!

http://blogs.technet.com/b/wikininjas/archive/2014/01/16/technet-guru-awards-december-2013.aspx

Congratulations to all our new Gurus for December!

We will be interviewing some of the winners and highlighting their achievements, as the month unfolds.

Post your JANUARY contributions here:

http://social.technet.microsoft.com/wiki/contents/articles/22211.technet-guru-contributions-for-january-2014.aspx

Read all about January's competition, hopefully in a stickied post, at the top of this forum.

Below is a summary of the medal winners for December. The last column being a few of the comments from the judges.

Unfortunately, runners up and their judge feedback comments had to be trimmed from THIS post, to fit into the forum's 60,000 character limit, however the full version is available on TechNet Wiki.

Some articles only just missed out, so we may be returning to discuss those too, in future blogs.

 
 

Guru Award  BizTalk Technical Guru - December 2013  

Gold Award Winner

Steef-Jan Wiggers Managing Windows Azure BizTalk Services with REST API Ed Price: "I'm not sure how you come up with such vital topics, but this is as important as it comes, and you nailed it!!!"
TGN: "It's almost unfair for others, Steef-Jan is a God when it comes to writing tutorials and articles, great one!"

Silver Award Winner

Sandro Pereira BizTalk Server: Grouping and Sorting Operations Inside BizTalk Maps Using the Muenchian Method TGN: "Very good article, I love this. Explains grouping and sorting in a good way, and by following best practice. Very good Sandro"
Ed Price: "Great explanations and fantastic formatting!"

Bronze Award Winner

Maheshkumar S Tiwari BizTalk Server 2010: How to Insert Image In SQL Through Orchestration Ed Price: "Very clear instructions through great use of images!"
TGN: "Should contain a warning around the size of the images, I do not usually recommend this way when using BizTalk due to performance."

 

 

Guru Award  SharePoint 2010 / 2013 Technical Guru - December 2013  

Gold Award Winner

Matthew Yarlett SharePoint: A Complete Guide to Getting and Setting Fields using C# Craig Lussier: "A fantastic reference that every SharePoint developer should have bookmarked. Well done!"
GO: "Matthew knows how to write an article worthy of recognition! This is a reliable source and contains many SharePoint and PowerShell examples that will be useful for IT-PRO as developers! A big thank you for your participation and your articles Matthew! Excellent work!"
Margriet Bruggeman: "What a handy reference!"
Ed Price: "What an epic article! From Mohammad in the comments: "this is something to add in my favourites, thanks"
Jinchun Chen: "Good guide"

Silver Award Winner

Benoit Jester - MTFC SharePoint 2013 - Design Manager : Use of Display Templates Ed Price: "The comments say it well. From Matthew: "Great article Benoit! I agree, it's a great feature!" From Dan: "I agree with Matthew. I can see myself refer to this article in the near future. I'm definitely adding this to my bookmark list. Thank you Benoit for sharing your knowledge.""
Craig Lussier: "Great walkthrough of Display Templates in SharePoint 2013. Well written, great screenshots and thoughtful material. "
GO: "If you want to have a better knowledge of SharePoint 2013, Benoit is your man! Again a great article: The use of XSLT ? Done ! This article absolutely deserves a medal!"
Margriet Bruggeman: "Not a big fan of design manager, but def. a nice write-up"

Bronze Award Winner

Nilesh Jain Sharepoint 2010 : A Complete list of SPFile Operations using ECMA Script Jinchun Chen: "Good getting start"
GO: "This articles show us various methods/properties associated with SPFile object! Clever article and well written! Great source!"
Craig Lussier: "Well written reference for SPFile operations with solid examples. "
Ed Price: "Solid formatting! Great comments on this article: From Matthew: "Nice article Nilesh!" From Dan: "Thank you for sharing your knowledge. I'm a big fan of using screenshots when writing an article and you've definitely done a great job here. Thanks again.""
Margriet Bruggeman: "Nice idea, but the reference is too short to be really cool"

 

 

Guru Award  Small Basic Technical Guru - December 2013  

Gold Award Winner

Nonki Takahashi Small Basic Known Issue: 21694 - Font and Pen Width Change Earlier in Remote RZ: "Very useful tip. May potentially save some frustration :)"
Ed Price: "This code is very helpful!"

Silver Award Winner

Nonki Takahashi Small Basic Known Issue: 22108 - Viewport of GraphicsWindow is Narrower and Sometimes Resized in Remote Ed Price: "The diagrams really help make this clear. Great job!"
RZ: "Again, very useful tip. And thank you highlighting them."

Bronze Award Winner

Nonki Takahashi Small Basic Known Issue: 21691 - Rectangle and Ellipse Become Smaller in Remote

RZ: "Very useful tip. May potentially save some frustration :)"
Ed Price: "Your samples you wrote help give these articles an added boost!"

Guru Award  SQL BI and Power BI (SSAS, SSIS, SSRS, Power Pivot) Technical Guru - December 2013  

Gold Award Winner

Tim Pacl Functional Reports: Making a Report Into a Management Tool NN: "Terrific article! Very helpful and clean steps"
Ed Price: "Tim nails it again with a fantastic and descriptive narrative on a great topic! It could be improved with images to show what you're describing. Fantastic article!"

Silver Award Winner

Michael Amadi A practical example of how to handle simple many to many relationships in Power Pivot/SSAS Tabular models Ed Price: "Great topic and great formatting! The descriptions are helpful, the images and the tables help clarify. The bold text really pops! Great article!"
NN: "Great article explaining a common problem and solution"

Bronze Award Winner

Tim Pacl Using a Date Picker for an Analysis Data Query Parameter NN: "Another interesting article by Tim"
Ed Price: "Another great article from Tim. Shorter but sweet!"

 

 

Guru Award  SQL Server General and Database Engine Technical Guru - December 2013  

Gold Award Winner

Uwe Ricken How does SQL Server allocate space in a heap Samuel Lester: "Amazing content, great presentation, and incredibly educational! "
DRC: " Very nice article, very well documented. Clear explanation of the behaviour and queries to trace the same. This also explains the output of the queries which makes the users more comfortable while reproducing the behaviour explained. The only modification is to remove the .(dot) for the value 8.096 which should be 8096. "
DB: "Clear and informative explanation of details not available elsewhere."
Jinchun Chen: "Awesome"
Ed Price: "Another high-quality article from Uwe! Great formatting and even a good interaction with Shanky in the comments!"
NN: "Great and thorough article"

 
 

Guru Award  Transact-SQL Technical Guru - December 2013  

Gold Award Winner

Naomi N T-SQL: Relational Division DB: "Clear and detailed."
Jinchun Chen: "Nice article!"
Richard Mueller: "Very well done and well researched."
Ed Price: "The article comments say it welll. From Saeid: "Surprised with this one! This is really one of the important topics. Many questions in MSDN SQL forums are about this topic" From Carmelo: "Very good work Naomi!" "
Samuel Lester: "Outstanding article again! As mentioned in the article and comments, variations of this question appear in the forums frequently and it is nice to have this article to reference. Great breadth and depth with each solution!"

Silver Award Winner

Durval Ramos How to extract data in XML to meet the requirements of a Schema Samuel Lester: "Creative solution and great write-up! "
Richard Mueller: "The articles in this group were very close. This is a great article with outstanding links. The See Also section should only include Wiki articles."
Ed Price: "Very detailed narrative that's well supported by great formatting and images! Great article!"

Bronze Award Winner

Saeid Hasani Error handling within Triggers using T-SQL Richard Mueller: "A well executed article. The trigger rules were confusing to me."
Ed Price: "Another great article from Saeid! This could be made better with more explanations for each step. Good job!"
Samuel Lester: "Great new content and nice companion to your prior article. "

Guru Award  Visual Basic Technical Guru - December 2013  

Gold Award Winner

Dewayne Basnett Prime Number Sieve Richard Mueller: "Amazing material that will take some study, but very clever. Donald Knuth in "The Art of Computer Programming", vol. 2, says Eratosthenes filter only considers odd integers and increments from p*p."
SB: "Nice article, not much practical use but just details coding for the fun of solving a problem"

Silver Award Winner

HomeGrownCoder Don't Throw Out the System Brushes Richard Mueller: "An important concept that is well explained, with lots of links. Should have a See Also section."
SB: "Nice article which address a real world issue that occurs."

Bronze Award Winner

Paul Ishak Declaring numeric data types SB: "Good simple piece helping detail best numeric types to use."
Richard Mueller: "Basic recommendations. This article could use links and a See Also section."

 

 

Guru Award  Visual C# Technical Guru - December 2013  

Gold Award Winner

Jaliya Udagedara Loading Related Entities in Entity Framework NN: "Very clear and helpful article! Nicely done"
DB: "Clear and informative."
Ed Price: "Fantastic article with a good suggestion in the comments. Could benefit from a TOC. Great job!"

Silver Award Winner

chriga Identifying and Resolving Shortcuts/Links of files and folders NN: "Short and useful article"
DB: "Useful bit of information."
Ed Price: "Great formatting and article!"

Guru Award  Windows Phone and Windows Store Apps Technical Guru - December 2013  

Gold Award Winner

Saad Mahmood Binding any JSON data list in your application in 10 mins.(Windows Phone) Ed Price: "Great detail, formatting, and use of images!"
Peter Laker: "Nice simple example"

Silver Award Winner

Saad Mahmood Now Check for updates of your app inside your Windows Phone application  Ed Price: "Good use of code formatting. Could benefit from a TOC."
Peter Laker: "Great article, thanks Saad"

Bronze Award Winner

Ken Tucker Convert date time received in JSON to a .Net DateTime Ed Price: "It's valuable, short and sweet, good code commenting, and it has good interaction in the Wiki article comments. But it is a bit generic for this category."
Peter Laker: "Top tip, nice layout, thanks Ken!"

 

 

Guru Award  Windows Presentation Foundation (WPF) Technical Guru - December 2013  

Gold Award Winner

dev hedgehog The Myth of BindingGroup Ed Price: "Very thorough article developed from forum questions. Great job! But why is it a Myth if it's really helpful? =^)"
Peter Laker: "Another excellent contribution from dev hedgehog. Good subject."

Silver Award Winner

Shweta Lodha Safest way to use RaisePropertyChanged method Ed Price: "Good topic and explanations. Could be improved with black font and with a TOC. Good job!"
Peter Laker: "Nice tip from Shweta. There are various variations to this."

Bronze Award Winner

chriga Binding of DataGrid column header Ed Price: "Short and sweet! Fantastic formatting and great descriptions help sell this one!"
Peter Laker: "Useful example and welcome edition to the knowledge base, thanks chrigra!"

 

 

Guru Award  Windows Server Technical Guru - December 2013  

Gold Award Winner

Mr X How DNS aging and scavenging works Richard Mueller: "Very good information. The images, links, and code example help a lot."
JH: "Brilliant article, great explanations and illustrations"
Ed Price: "Explanations, links, code, images, diagrams... it's all here! It could benefit from a TOC for easier navigation. Just add headers and then "[toc]" at the top of the article."
JM: "Excellent article and a nice use of good graphics, nice work!"

Silver Award Winner

Kelly Bush Delegate Replication Rights to non-admins JM: "This is an excellent article, nice work!"
JH: "Like how author organized and summarized a forum post and added more, like "applies to" values "
Ed Price: "Good reference, instructions, explanations, and images! Could be improved with a TOC."
Richard Mueller: "On my first reading of the articles in this section I had a 3 way tie for first. This article covers a very important concept for security. It could use a See Also section."

Bronze Award Winner

Mr X How to mark an Active Directory attribute to be copied when duplicating a user template Richard Mueller: "Very useful and well explained information. Very good images. This could use a See Also section."
JM: "This is an excellent article, however the first sentence needs to be revised for clarity."

 

As mentioned above, runners up and their judge feedback were removed from this forum post, to fit into the forum's 60,000 character limit.

 

A great big thank you to EVERYONE who contributed an article to last month's competition.

Hopefully we will see you ALL again in this month's listings?

As mentioned above, runners up and comments were removed from this post, to fit into the forum's 60,000 character limit.

You will find the complete post, comments and feedback on the main announcement post.

Please join the discussion, add a comment, or suggest future categories.

If you have not yet contributed an article for this month, and you think you can write a more useful, clever, or better produced wiki article than the winners above, here's your chance! :D

Best regards,
Pete Laker

More about the TechNet Guru Awards:

January 17th, 2014 6:15pm

Congrats to Naomi, Durval, and Saeid!

Guru Award  Transact-SQL Technical Guru - December 2013  

Gold Award Winner

Naomi N T-SQL: Relational Division DB: "Clear and detailed."
Jinchun Chen: "Nice article!"
Richard Mueller: "Very well done and well researched."
Ed Price: "The article comments say it welll. From Saeid: "Surprised with this one! This is really one of the important topics. Many questions in MSDN SQL forums are about this topic" From Carmelo: "Very good work Naomi!" "
Samuel Lester: "Outstanding article again! As mentioned in the article and comments, variations of this question appear in the forums frequently and it is nice to have this article to reference. Great breadth and depth with each solution!"

Silver Award Winner

Durval Ramos How to extract data in XML to meet the requirements of a Schema Samuel Lester: "Creative solution and great write-up! "
Richard Mueller: "The articles in this group were very close. This is a great article with outstanding links. The See Also section should only include Wiki articles."
Ed Price: "Very detailed narrative that's well supported by great formatting and images! Great article!"

Bronze Award Winner

Saeid Hasani Error handling within Triggers using T-SQL Richard Mueller: "A well executed article. The trigger rules were confusing to me."
Ed Price: "Another great article from Saeid! This could be made better with more explanations for each step. Good job!"
Samuel Lester: "Great new content and nice companion to your prior article. "

Free Windows Admin Tool Kit Click here and download it now
January 18th, 2014 1:13am

Congratulations Durval,Saeid  and Naomi
January 18th, 2014 1:21am

Congratulations Durval,Saeid  and
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2014 3:04pm

Thanks! I enjoyed both articles by Durval and Saeid. 
January 18th, 2014 8:44pm

Very nice articles Naomi, Durval and Saeid.

One note though: the XML article should go under the XML forum heading not T-SQL.

Free Windows Admin Tool Kit Click here and download it now
January 19th, 2014 3:32am

Thanks! I enjoyed both articles by Durval and Sa
January 19th, 2014 6:03am

Very nice articles Naomi, Durval and Saeid.

One note though: the XML article should go under the XML forum heading not

Free Windows Admin Tool Kit Click here and download it now
January 19th, 2014 6:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics