TechNet Guru Awards - November 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.


The November results are in!  With many new SQL Server related TechNet entries, the competition for the November TechNet Guru was very tough!  Here are the final results.  Congratulations to all winners!


Guru Award  Transact-SQL Technical Guru - November 2013  

Gold Award Winner


Naomi N T-SQL: Create Report for Last 10 Years of Data Richard Mueller: "Excellent article solving a common problem." Ed Price: "Good details in the Solutions section!" Samuel Lester: "Handy code and very slick solution!"

Silver Award Winner


Ronen Ariely Random String Samuel Lester: "Great comparison and VERY useful information in the application testing space as you mentioned." Ed Price: "Great detail and depth!" Richard Mueller: "I disagree with several statements in the article. For example GUID values will be random." 

Bronze Award Winner


Saeid Hasani Simplified CASE expression Ed Price: "Incredibly clear and detailed explanations. Great job taking Carsten's advice (in the comments) and giving it good code formatting. It helps a lot!" Samuel Lester: "Extremely thorough and a great read! Good addition!" 



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

Gold Award Winner


Uwe Ricken When Foreign Keys will conflict with FILLFACTOR Jinchun Chen: "Nice! I love it." NN: "Great article, very comprehensive. Few drawbacks - it doesn't explain in details what the correct solution should be. Also, the code samples to the article include line numbers which make them harder to copy" Ed Price: "As Saeid in the comments wrote, "I love this article. This article defines the quality!" Between the explanations, code, comments, and diagram, the story is told well." Samuel Lester: "Outstanding explanation, format, and write-up! Superb again Uwe!" DB: "Very interesting both in content and technique. " DRC: "Very nice article, well documented with sample script and sample output. If we add the references to few of the topics discussed, would be helpful to understand the concept better so that the reader will get the complete picture of the blog talks about. Definitely a TechNet WIKI article. "

Silver Award Winner


Ronen Ariely SQL Server: Create Random String Using CLR NN: "This article can not be read by its own without reading the article it refers to. The code is not explained, the process of creating CLR function is also not explained. So, it is not clear how this C# code is used in SQL Server at all" Ed Price: "This could benefit from much more explanation. " Samuel Lester: "Very good article and a great in-depth break-out that compliments your broader random string tech-net Wiki article. Great read!" DRC: "It would have been better if the code would also provide the below details: 1. How to load the dll generated in SQL Server memory 2. Sample T SQL script to use the function and a sample output for the same. "