none
Microsoft TechNet Wiki T-SQL Guru - Winners for September!!

    General discussion

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

    http://blogs.technet.com/b/wikininjas/archive/2013/10/16/technet-guru-awards-september-2013.aspx

     

    Congratulations to all our new Gurus for September!

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

     

    Post your OCTOBER contributions here:

    http://social.technet.microsoft.com/wiki/contents/articles/20025.technet-guru-contributions-for-october-2013.aspx

    Read all about October's competition in the stickied post in this forum.

     

    Below is a copy of the September winners. The last column being a few of the comments from the judges.

     

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


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


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


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

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

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


    Guru Award  Visual Basic Technical Guru - September 2013  

    Gold Award Winner

     

    John Anthony Oliver Code for 2008 and 2010 versions of vb.net. 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."


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


    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"


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

     

         


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

    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

     

    Ike Ugochuku - MSFT (IdM-FIM Consultant) 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?"


    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 here
    Jinchun 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.  "

     

    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?

     

    You will find more discussion and lots of 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:


    #PEJL

    Got any nice code? If you invest time in coding an elegant, novel or impressive answer on MSDN forums, why not copy it over to the one and only TechNet Wiki, for future generations to benefit from! You'll never get archived again!

    If you are a member of any user groups, please make sure you list them in the Microsoft User Groups Portal. Microsoft are trying to help promote your groups, and collating them here is the first step.

    Thursday, October 17, 2013 7:48 PM

All replies