A few weeks back, XAML Guy posted the December TechNet Guru awards:

 

TechNet Guru Awards - December 2013

 

To give you a taste, here are the results of the technologies in my product areas (SQL Server, Power BI, and Small Basic)...

 

 

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

Also worth a mention were the other entries this month:

 

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"

Also worth a mention were the other entries this month:

Ed Price: "A good solution and some great suggestions from Shanky in the comments! Examples would help."
NN: "Another great article by Praveen which contains many methods to check Server and Windows Restart time."
Samuel Lester: "Knowing when SQL Server restarted is nice, but knowing why it restarted is often the more important issue. The methods you highlight are creative and allow you to quickly find the first answer, but aside from determining if it was restarted due to an OS reboot, it would be nice to dig more into the topic of why. Great content on what could turn into a spectacular topic and set of troubleshooting steps."
DRC: "• It mentioned about finding the "reason" for the SQL Server and windows restarts at the beginning but the details are missing in the article. . The query "SELECT create_date FROM sys.databases WHERE name = 'tempdb'" will not work if traceflag 3609 is ON which doesn’t create a new tempdb file during sql server startup. For windows: Method 1: Start Task Manager->Performance Method 1 shows only the uptime but doesn’t show the actual time of restart. If the server has been up for a long time, then the calculation is very difficult Method 2: This method helps you to figure out root cause for the restart. start -> run -> eventvwr The 2nd method will not help if event viewer logs are clreared. • We have a better method to find the system startup time where we don’t depend on any other logs or tools. C:\> systeminfo | find /i "Boot Time" "

 

 

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

 

 

 

And keep your eyes on the January results as January comes to a close:

 

TechNet Guru Contributions for January 2014

 

 

Here are the current entries for the technologies that I work on...

 

Small Basic

Current contributions for January:

SQL BI & Power BI

Current contributions for January:

SQL Server General & Database Engine

Current contributions for January:

Transact-SQL

Current contributions for January:

 

 

Special thanks to for hosting this contest!

 

See Also

TechNet Guru Contributions 

List of Award Winning TechNet Guru Articles

 

Hope you're having a great week!

   - Ninja Ed