TechNet Guru Awards - September 2013

All the votes are in!  


And below are the results for the TechNet Guru Awards, September 2013 !!!!


The TechNet Guru Awards celebrate the technical articles on TechNet, contributed from valued wiki authors like YOU!

Each month, the contributions are scored by a panel of judges (5 per category, 2-3 in each are MS experts), and the winners of each category are showered with love and attention from all corners of TechNet.

See the links at the bottom, to find out more about the competition and how to enter.


We have picked the top three highest scored contributions for each category to bestow our awards upon.

The awards are in gold, silver and bronze, the gold obviously being the top winner of the category.

The last column is just a few of the comments judges made during the judging process.

In some cases, we have not obtained permission to use the judges names, so they have been reduced to initials.


My fellow wiki ninjas will be digging deeper into some of these articles in this blog series, so watch out for those.


A big thank you also to the other authors who did not make the top three of each category.

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



A few entries were missed from the voting, for technical reasons, but they will be carried over to this month (October).   Our apologies to those that were affected.


Guru Award  BizTalk Technical Guru - September 2013  

Gold Award Winner


Steef-Jan Wiggers BizTalk Server 2013: WCF-SQL executing a stored procedure in Windows Azure SQL Database Tord Glad Nordahl: "As always Steef-Jan cooks up an amazing article, well described and authored. Very good work Steef-Jan!" Ed Price: "Beautiful, clear, and incredibly thorough!"

Silver Award Winner


Suleiman Shakhtour BizTalk Server:Receive and Send Excel Files from Existing Templates Tord Glad Nordahl: "Very good article, well described and full of good quality content and images!"Peter Laker: Superb article. very useful indeed!

Bronze Award Winner


M.R.ASHWINPRABHU BizTalk: Generating Flat File Schema for File with Tag Identifiers not at the Beginning, Grouping Data by Element and Debatching Mandi Ohlinger: "Oh. My. Goodness. Thank you for putting this on the Wiki! You've definitely resolved some scenarios." Tord Glad Nordahl: "Again, the top 3 articles this month out-class the others with amazing content, well described and elements that are on huge demand from the community! Thanks!" Ed Price: "You can see how much thought has gone into each of the images to make this incredibly clear. Once again, this was a fantastic month for BizTalk content and the true winners here are all the BizTalk users!"

Congratulations to all three above. It's great to see our very own Ninja Blogger, true guru and BizTalk demi-god Steef-Jan leading the charts this month! Special thanks also to runner up Maheshkumar S Tiwari, better luck next month!

Guru Award  SharePoint 2010 / 2013 Technical Guru - September 2013  

Gold Award Winner


Matthew Yarlett SharePoint: Using PowerShell to Group Filter and Sort Documents by Metadata TVG: "The numbers tell the tale! PowerShell is a very powerful tool in your admin toolbox, well done!" Margriet Bruggeman: "A very detailed article!!" Ed Price: "Great topic! It's important that SharePoint admins know how to leverage PowerShell! Great formatting with the images and code snippets, and you give a lot of explanation! The icing is the rich list of resources at the bottom where you can learn more about all the related topics!"

Silver Award Winner


Rahul Shinde SharePoint 2013: SharePoint Community Site as Real Time Social Communities or Groups Ed Price: "This is a very deep look at the topic with multiple perspectives and great formatting. As Naomi wrote in the comments, "Great article, as usual!"" Jinchun Chen: "Excellent. A solution with almost all required informaiton."

Bronze Award Winner


Matthew Yarlett Search vs. Recursive Looping: Getting a List of Sites (SPWeb's) a User Has Access to in a SharePoint Site Collection TVG: "Search is indeed the most recommended approach and this approach is even more present in SP2013!" Margriet Bruggeman: "An excellent article. Certainly a must read!" Ed Price: "Good subject with a great approach and thorough explanations! Very thorough!"

Congratulations to Matt for winning gold AND bronze. Special thanks also to nunespascal, Daniel Christian & Nilesh Jain for their superb entries. Please continue to compete, as you only just missed out. The judges decision is final, however we may be changing the rules soon so people only win one (their highest) award, so hopefully we see you in the medals next month!

Guru Award  Small Basic Technical Guru - September 2013  

Gold Award Winner


Timo Sö SmallBasic | AutoUpdater Snippet RZ: "Is is a very innovative idea to introduce autoupdater functionality to Small Basic!" Ed Price: "The best reviews are in the comments. From Gungan: "Very nice article! Comprehensive but simple enough for a beginner to follow." And from LitDev: "Well written article and useful - I look forward to the next one..." CS: "A little hard to follow the flow, but I like the idea."

Silver Award Winner


Nonki Takahashi Small Basic: Parameter or Return Value Range for Math Function RZ: "Very useful information for those math functions" Ed Price: "Great resource. Thanks, Nonki!"

Bronze Award Winner


Nonki Takahashi Small Basic: Supported Languages RZ: "Useful information" Ed Price: "20 languages is pretty awesome! Most software isn't localized for that many different languages."

Nonki deserves silver and bronze, as there were only three entries last month! Congrats to Timo for heading the medals with a superb winning article! C'mon Small Basic folks, lets see your code!!!

Guru Award  SQL Server Analysis Services, PowerPivot Technical Guru - September 2013  

Gold Award Winner


Olaf Helper PowerPivot: Query Power Pivot DMV's with VBA Ed Price: "Important topic, great formatting, and I love having the links in line to the parent topics (like how the Power Pivot link in the first line goes to the Power Pivot wiki topic)." Richard Mueller: "Excellent overview of the subject, with great links."

Silver Award Winner


MnisharMSDN Profile MDX & SQL  queries from SSRS Ed Price: "Great formatting, and very easy to follow! The images help take you through the full story." Richard Mueller: "Could use more cross links."

Bronze Award Winner


ShankarGS SSAS: Custom MDX Query for Excel Filters Ed Price: "Great topic with thorough steps to take!" Richard Mueller: "Needs more explanation."

Three entries, three winners! Great stuff too, thank you for these excellent contributions, we all learn from you.

Guru Award  SQL Server Reporting Services, Power View, & SQL Server Integration Services Technical Guru - September 2013  

Gold Award Winner


SathyanarrayananS SSRS - Multi-valued Parameter as Stored procedure Input Jinchun Chen: "It can be a workaround for using Multi-Value parameter in subscriptions" Richard Mueller: "Amazing solution. I had to puzzle over this one for some time." Ed Price: "It's a tough race this month, but this article is very detailed and features great interaction in the comments!"

Silver Award Winner


SathyanarrayananS SSRS - RDL Compare Ed Price: "As Saeid wrote in the comments: "WOW! It's a nice solution." Great code formatting and images!" Richard Mueller: "Very interesting with a good example. This could prove useful in many situations."

Bronze Award Winner


SathyanarrayananS SSRS (Matrix) - How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling Peter Laker: "Very nice work" Richard Mueller: "Good instructions with a clear example."

Wow, all three medals for SathyanarrayananS!! Also a special thanks to Yogish Bhat for his noble contribution. That's just the result from the voting tool, the way it currently works. Please keep contributing, as you may get more chances in future votes.

Guru Award  Transact-SQL Technical Guru - September 2013  

Gold Award Winner


Saeid Hasani Structured Error Handling mechanism in SQL SERVER 2012 Richard Mueller: "Useful tutorial with lots of examples and very good links. Excellent comparison of THROW and RAISERROR." Jinchun Chen: "Nice article. Thank you for the sharing." Ed Price: "Incredibly well formatted with images, code, and explanations. And great interactions in the comments, making the improvements suggested by Naomi. " DB: "Useful, clear and accurate guidance on error handling" Samuel Lester: "Great coverage of different techniques, challenges, pros/cons. Well done, very informative, and easy to read."

Silver Award Winner


Stefan Hoffmann SQL Server XML: Sorting Data in XML Fragments Samuel Lester: "Interesting problem space and outstanding write-up/solution!" Richard Mueller: "I especially liked the use of FLWOR. Great links." Jinchun Chen: "Good." Ed Price: "Naomi described it well in the comments: "Great article - very interesting!" The formatting on the comments and sections is really well done!"

Bronze Award Winner


Ronen Ariely T-SQL: Using Bulk Insert to import inconsistent data format (using pure T-SQL) DB: "Good, detailed on advanced XML Format Files" Richard Mueller: "Very interesting with some good tips. I liked the detailed steps. Good links at end. Grammar and spelling need work." Ed Price: "A lot of great detail!"

Some outstanding pieces above, really worth a read. Thank you all so very much for your time and generosity in sharing these with the SQL community. Also a big thanks to SathyanarrayananS & DIEGOCTN who JUST missed out in the month's votes. It was very close as we had some supurb work from everyone in the SQL category in September.

Guru Award  Visual Basic Technical Guru - September 2013  

Gold Award Winner


Code for 2008 and 2010 versions of Have you ever wanted an oval, triangle, a pentagon, a hexagon or an octagon for a control or a form? Richard Mueller: "A very interesting and creative article with lots of example code." MR: "Helpful article! " Ed Price: "Good solution with a lot of detail! Would be even better formatted into sections, since it's so long. Some good interactions in the comments, too!" SB: "The article has a narrative and shows doing something which I know people want to achieve. The code shows revisions and is VB code. "

Silver Award Winner


.paul. Maths Revision V1.0 Richard Mueller: "An interesting assortment of programs. I like the icons for each." MR: "Great app, but not an article that describes a way for users to learn." Ed Price: "Nice collection! A few of these as a tutorial would be great. " SB: "No real narrative but lots of code samples which are well done. Code contains comments but would like to more narrative on articles. " Anthony D. Green: "This is not an article so much as a download link that showcases code the author has written in the past. The code seems like it might be fun and educational but the author needs to bring more content into the article to prime the reader before asking them to download arbitrary code on to their machines and run it."

Bronze Award Winner


.paul. VerticalLabel Control Anthony D. Green: "Given the emergence of UI frameworks like WPF this topic seems less compelling - it would be interested in to see an article showcases how a layout transform makes this very easy." Ed Price: "Would be good as a tutorial. " SB: "The control is simple a small code sample, useful although the narrative seems to indicate that this is just a C# run through translator and fixed up - so feels as though its useful but the VB is an afterthought. The fact its targeting VS2008 is also something I'd like it targeting current VS version " Richard Mueller: "It would help to see the code with an explanation." MR: "This is not a good "article" example of how to do something."

Only two entrants with three entries in total for September :(

Still, what pure gold we got! Thanks to both John and Paul. Lovin' your work guys!!

Guru Award  Visual C# Technical Guru - September 2013  

Gold Award Winner


Jaliya Udagedara IEnumerable<T> Vs. IQueryable<T> Ed Price: "As Naomi wrote in the comments, "I like your articles and your style - easy to follow." I agree, it has great formatting, and it is very clear. Special thanks to Pituach for helping format it and for giving Jaliya some good advice!" CW: "The most important difference is in the query building. Unfortunatly this was at the end. Article still quite useful."

Silver Award Winner


chilberto WCF Service Hosting - Supporting Multiple Versions Ed Price: "Great topic with good formatting on the code snippets!" Peter Laker: "Great layout, love the code bits! We want more!"

Bronze Award Winner


PaulDAndrea How do you manage unmanaged buffers used for P/Invoke Christian Lukito: "Good wrapper" Ed Price: "Great code formatting! It would be great broken down into sections with more explanations."

Three entrants for September, with six articles between them, and all three get a mention in the medals, which is nice to see.

Great work folks, thanks for your continued contributions, you deserve all the love we bestow upon you over the coming months :D

Guru Award  Windows Phone Technical Guru - September 2013  

Gold Award Winner


mcosmin How to play flac files in windows phone using C# JS "Long but good" Ed Price: "Long article; very in depth!"Peter Laker: "Wow yummy, very nice, thanks mcosmin"

Silver Award Winner


Gaurav Khanna Searching in Windows Phone ListBox JS: "Nice little tutorial" Ed Price: "This is a great topic!"Peter Laker: "A very useful article!"

Bronze Award Winner


Tiziano Cacioppolini IsolatedStorage: folders and files JS: "Basic info all in one place" Ed Price: "Good topic, but it could use more explanations."Peter Laker: "A great resource, will help future generations, could do with filling out with a little more info"

Three entries, three new gurus. All entries were well worth the read, we are very lucky to have your wisdom bestowed upon us. Please keep up the great work, as you've certainly got our attention!

Guru Award  Windows Store Apps Technical Guru - September 2013  

Gold Award Winner


Thomas Claudius Huber What's new for the Appbar in Windows 8.1 RC: "It's pretty much a rehash of the documentation here. The comments on differences between the XAML implementation and the C# implementation are useful. How about C++ and VB syntax as well? The title and tags should also clarify that this is a XAML-specific article." Ed Price: "Good breakdown of the sections, great formatting of the code and images. Great article! As RC mentioned, this should include more info about XAML. "

Silver Award Winner


JORDAN RTG Windows Store Apps Issue with ComboBox Leads to Crash in ATOM Processor RC: "This is an interesting anecdote, but it's not useful technically without a link to the KB for the hotfix" Ed Price: "Good topic, but it needs to include the solution as well."



Thomas and Jordan are our honourable winners for September.

We may be setting a quality/content bar for medals very soon. Congratulations to all the winners!

Guru Award  WPF Technical Guru - September 2013  

Gold Award Winner


Magnus (MM8) WPF: Exporting Data from a DataGrid Control Ed Price: "Fantastic formatting and great descriptions!" Peter Laker: "Wow, awesomely detailed, nice work Magnus!"

Silver Award Winner


Gaurav Khanna Multiple Columns in WPF ListBox Ed Price: "Good breakdown of the sections!" Peter Laker: "Great article Gaurav! Excellent introduction, keep up the great work!"

Amazing contributions from two regular gurus, thanks to both of you for keeping this category going.

Hang in there till the rest of the community catches up!

Personally, I missed the deadline, so couldn't contribute for September D:

Guru Award  Forefront Identity Manager Technical Guru - September 2013  

Gold Award Winner


Peter_Stapf FIM 2010 R2: How-to Manage Group Membership from the User UI Ed Price: "This is a high quality article with a TOC, clear headers, great images, and code that is formatted well with great in-line comments that make each line very clear! Fantastic job!" Richard Mueller: "Very useful and well documented solution. I like the use of PowerShell."

Silver Award Winner


Jacques Swanepoel FIM 2010 R2 How-to: Password Synchronization with PCNS using a one way external/forest trust with Selective Authentication Ed Price: "I love the diagram, the "What you will need" section, and the in-depth how-to steps and explanations! It could benefit from better formatting with a TOC and clearer headers. As Peter mentioned in the comments, "Very cool and helpful article, could be useful in my future work." Great article!" Richard Mueller: "Good tutorial with detailed steps."

Bronze Award Winner


FIM 2010 R2: Using FIM to Synchronize User Data with HP Service Manager 9 (SM9) Ed Price: "Great start! Looking forward to seeing how this develops" Peter Geelen: "Can you elaborate the article more in detail?"

Some great contributions here, thank you to all three of you. FIM looks like it will grow into a very interesting category. 

Guru Award  SQL Server Database Engine Technical Guru - September 2013  

Gold Award Winner


Shanky Understanding Lock Escalation DRC: "I was able to repro the lock escalation even at 5000 rows The reasons and threshold for Lock Escalation are documented hereJinchun Chen: "Nice article." Samuel Lester: "Great investigation and summary of a complex topic broken down in a practical way. I really like the way you explained your test scenarios, the results, and future research that you'd continue to do. A great concept and use for TechNet Wiki!" Ed Price: "Great explanation! Thanks, Shanky!"

Silver Award Winner


SathyanarrayananS SQL Server Performance tuning with Indexing Ed Price: "This is a great Q&A and resource list! An innovative use of TechNet Wiki that is very helpful for people searching on this topic! As DRC mentions, it would be even better to include the query info in the article. Great job!" Samuel Lester: "Outstanding collection of resources, links, and explanations! I can easily see this as a section to a future database engine reference guide. " DRC: "The topic covered is very broad.  It would have been more appropriate to test the queries (along with the expected output) and mention it in the article instead of pointing to 3rd party sites. It clearly summarises the topic and provides links for the related topics.  "

Only the two entries for this category, but both deserved winners, thanks to both of you for entering articles in this category and looking forward to seeing if anyone else has anything to offer in the coming months.

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

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


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


Best regards,
Pete Laker

More about the TechNet Guru Awards:



Forum announcement links coming soon!