Introduction

July's competition has now closed.







The winners were posted here.

August is HERE.



















If you contribute any new code, or solutions to problems in the following categories, please add your content (that you write for a Forum or Blog) to TechNet Wiki, and then add a link to your TechNet Wiki article below, to let us know. This is a TechNet Wiki awards program, so we only want WIKI LINKS for articles created in JULY, not old, external forum or gallery links. If you have already made a contribution on the forums or gallery, simply copy it into the wiki and reference the original article, like shown here.

One winner in each category will be selected each month for glory and adoration by the MSDN/TechNet Ninjas and community as a whole. This includes a dedicated blog post in the Wiki Ninjas blog, a tweet from the Wiki Ninjas Twitter account, an announcement on your forum, and other acknowledgement from the community.

Winners will be voted on by five judges. The judges consist of 3 TechNet Wiki Community Council members and 2 Microsoft Employee SMEs (Subject Matter Experts -usually the people making the technologies). The judges will be looking for articles that are thorough, technically accurate, visually clear (images might help, but aren't necessary), and well written. (Any community member can help with the "technically accurate" part by reviewing the articles below and either fixing inaccuracies in the article or commenting on them--asking questions or suggesting fixes.)

The articles must be written in July 2014 and must be in English. However, the original blog or forum content can be from before July. Make sure you aren't taking credit for someone else's content (you have to be the author of the original content and of the Wiki article). The categories listed are targeted to the most popular forums/technologies and ones that we are able to support. We will add more categories as we go (please don't add more categories, instead, leave a comment at the bottom to suggest a new category).

How to Enter

1) Create a new TechNet article YOU CAN COPY YOUR CONTRIBUTION FROM MSDN/TECHNET FORUMS OVER TO TECHNET WIKI (IN JULY) TO QUALIFY FOR THESE AWARDS. You can also create a new article not related to your forums contributions.

A) Log into TechNet/MSDN with your Microsoft credentials

B) Add your content as an article to TechNet Wiki: http://social.technet.microsoft.com/wiki/contents/articles/add.aspx%20

If you are copying and pasting your MSDN/TechNet forum solutions over to TechNet Wiki, please give some introduction to the problem, make sure your steps are clear, and then link to the original forum post. You can also paste in your blog posts (rather than forum content).

2) Tell us about it To add a link to your article:

A) Log into TechNet with your Microsoft credentials

B) Click the "Edit" tab, above this article title, and copy in the URL to your TechNet Wiki article into the appropriate section.

Categories

Add Your Contributions for JULY in the Sections Below...

NOTE: These MUST be TechNet Wiki articles, and they MUST be written in JULY 2014.

Microsoft Azure

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your Azure contribution here:

• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)
• Download you Azure website with Kudu by M.I. Isham Mohamed
• Datatable design view for Azure SQL Database by saramgsilva
• How to provide a temporary and secure remote access to Microsoft Azure VMs by Mr X
• How to set up Endpoints to Microsoft Azure VMs by Mr X
• Microsoft Azure and Availability Sets for VMs by Mr X

BizTalk

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your BizTalk contribution here:

• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)
• BizTalk Server 2013: How to publish a REST web service with POST by Idar H
• BizTalk: Pattern to on-board increasing business partners by Murugesan Mari Chettiar
• BizTalk Developer Interview Questions and Answers - HL7 by Maheshkumar S Tiwari
• Securing BizTalk endpoints leveraging Sentinet API Management Part 1 by Steef-Jan Wiggers

Forefront Identity Manager

The TechNet Guru competition is announced in the forums links available below.

Post a link to the TechNet Wiki page of your FIM contribution here:

• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)
• How to Calculate Manager Reference Value from PeopleSoft SQL View by Scott Eastin

SharePoint 2010 / 2013

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of SharePoint contribution here

• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)

• Capacity Planning In SharePoint 2013 by Vivek Jagga
• Retreiving Server Date using SharePoint JSOM by Naveen Sasi
• How to setup, configure and test SQL 2012 SP1 SSRS with SharePoint 2013 SP1 by Dan Christian
• Web Sensitive Files and SharePoint 2010  by Johnathan Lightfoot

Small Basic

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your Small Basic contribution here:

• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)
• Small Basic Survival Guide by Ed Price - MSFT
• Small Basic: Character Set - Unicode by Nonki Takahashi
• Small Basic: Controls by Nonki Takahashi
• Small Basic: Sound by Nonki Takahashi
• Small Basic Known Issue: 25471 - Sound.PlayXXXAndWait() Does Not Wait in Remote by Nonki Takahashi
• Small Basic Known Issue: 25568 - Shapes.Zoom() Stops Program with 0.7 or Smaller Scale of Transparent Image in Local by Nonki Takahashi
• Small Basic: File by Nonki Takahashi
• Small Basic Known Issue: 25669 - Turtle Operations in Event Handlers Cause Browser Hang Up in Remote by Nonki Takahashi 
• Small Basic: Community Channels by Ed Price - MSFT
• Small Basic Known Issue: 25671 - Turtle.Show() Doesn't Show Turtle after GraphicsWindow.Clear() or Turtle.Hide() by Nonki Takahashi
• Small Basic: Resources for Game Programming by Nonki Takahashi

SQL BI & Power BI

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your BI contribution here:

• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)
• Getting Started with Forecasting and Hindcasting in Power View by Firdous S -MSFT

SQL Server General & Database Engine

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your SQL Server contribution here:

• Cell Level Encryption With Always On Availability Groups by Sean Gallardy
• How to Install SQL Server 2012 SP2 on Standalone Instance of SQL Server By  Shanky

System Center

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your System Center contribution here:

• Orchestrator – Check System Center VM Snapshots by Mark Scholman
• How to use Orchestrator to automatically recover Website failures by checking the HTTP status code by Mr X
• How to uninstall or remove SCCM client by Mr X

Transact-SQL

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your T-SQL contribution here:

• Get Current Fiscal Year Dates by Visakh16
• T-SQL: Find the Peak Hour by Naomi N
• Transact-SQL: Join Order by Ronen Ariely (nickname PITUACH)
• Formatting T-SQL queries output from JSON model by Durval Ramos
• T-SQL : Find Word Matched Count by Hasham Niaz

Microsoft Visio

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your Azure contribution here:

• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)
• Reverse Engineering a SQL Server Database using Visio by Durval Ramos

Visual Basic

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your VB contribution here:  

• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)
• Simple_database_LogIn_system by .paul.          

Visual C#

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your C# contribution here:

• A Client/Server Application Using Named Pipes by Eyal Shilony
• Writing a Very Basic Dynamic Query using Expression Trees by Jaliya Udagedara
• C Sharp: Multi-Types Application, by Ronen Ariely (nickname PITUACH)

Windows Phone and Windows Store Apps

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your Windows Phone contribution here:

• Expression Blend - Playing with Sample Data (WPF , Windows Phone) by Saad Mahmood
• Authentication using Facebook, Google and Microsoft accounts in Universal Apps using MVVM by saramgsilva
• WP8.0 vs WP8.1 :All about new package.appxmanifest file at beginners level by SubramanyamRaju.B

Windows Presentation Foundation (WPF)

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your WPF contribution here:

• Thinking outside the box with the Adorner by Andy ONeill
• WPF: Implementing Custom Authentication And Authorization by Magnus (MM8)

Windows Server

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your contribution here:

• How to get the HTTP status code for a Website running on a specific Web server using Powershell by Mr X
• Basic Method for Troubleshooting a Domain Controller by seansobey
• IIS7+: Renewing a SSL Certificate by FZB
• How to prevent rogue DHCP servers on your network by Mr X
• How to enable and configure DHCP MAC address filtering by Mr X
• DCDiag: Missleading DNS test failure in a multi-sited parent/child-domain scenario by FZB

Wiki and Portals

The TechNet Guru competition is announced in the forums, links are listed below.

Post a link to the TechNet Wiki page of your contribution here:

• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)
• How to add images to your TechNet Wiki article by Dan Christian
• SQL Server 2014 Portal by Durval Ramos

Miscellaneous

This section is for entries that people have added to TechNet wiki, which do not fit into any of the categories above.

Post a link to the TechNet Wiki page of your contribution here:

• Hyper-V and Router Guard feature by Mr X
• Hyper-V and DHCP Guard feature by Mr X
• Automating a Data Paging using VBA on Excel by Durval Ramos
• How to execute a SQL query in Powershell by Brian Nadjiwon

See Also

• TechNet Guru Contributions
• List of Award Winning TechNet Guru Articles

This Month's Forum Announcements

http://social.msdn.microsoft.com/Forums/en-US/82077990-37d8-4bbf-ba11-28f12b43c7c6/a-chance-for-you-to-play-for-the-biztalk-team-in-the-technet-guru-world-cup?forum=biztalkgeneral

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/13eed857-a100-4b4e-b56e-d204973e7dbd/a-chance-for-you-to-play-for-the-sharepoint-2010-team-in-the-technet-guru-world-cup?forum=sharepointgeneralprevious

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/dc7640b2-5254-4dfe-b95f-c4b8f596f624/a-chance-for-you-to-play-for-the-sharepoint-2010-team-in-the-technet-guru-world-cup?forum=sharepointdevelopmentprevious

http://social.msdn.microsoft.com/Forums/en-US/89f49780-53d2-420e-8282-f8f29efe04e5/a-chance-for-you-to-play-for-the-small-basic-team-in-the-technet-guru-world-cup?forum=smallbasic

http://social.technet.microsoft.com/Forums/sqlserver/en-US/aadb1221-2b99-4b36-b778-364c3d4db127/a-chance-for-you-to-play-for-the-ssas-team-in-the-technet-guru-world-cup?forum=sqlanalysisservices

http://social.technet.microsoft.com/Forums/sqlserver/en-US/ad20a212-8f8a-4102-a4cc-85ab93750207/a-chance-for-you-to-play-for-the-power-pivot-team-in-the-technet-guru-world-cup?forum=sqlkjpowerpivotforexcel

http://social.technet.microsoft.com/Forums/sqlserver/en-US/4cb7672e-410d-4a8e-b413-3f7d22e48425/a-chance-for-you-to-play-for-the-ss-dbe-team-in-the-technet-guru-world-cup?forum=sqldatabaseengine

http://social.technet.microsoft.com/Forums/sqlserver/en-US/cf6c3770-1f3b-4224-a323-85592a6ca31c/a-chance-for-you-to-play-for-the-ssrs-team-in-the-technet-guru-world-cup?forum=sqlreportingservices

http://social.technet.microsoft.com/Forums/sqlserver/en-US/328543c4-f6b2-4bb0-bd83-dc2eabbee49f/a-chance-for-you-to-play-for-the-ssis-team-in-the-technet-guru-world-cup?forum=sqlintegrationservices

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/13bee0a8-01e8-420f-bcfd-c4e384bd4c1c/a-chance-for-you-to-play-for-the-tsql-team-in-the-technet-guru-world-cup?forum=transactsql

http://social.msdn.microsoft.com/Forums/vstudio/en-US/13740449-0fa7-4118-ab17-570bb72b3742/a-chance-for-you-to-play-for-the-vb-team-in-the-technet-guru-world-cup?forum=vbgeneral

http://social.msdn.microsoft.com/Forums/vstudio/en-US/1a146233-af07-484e-b9bc-6fc7f0f2c479/a-chance-for-you-to-play-for-the-c-team-in-the-technet-guru-world-cup?forum=csharpgeneral

http://social.msdn.microsoft.com/Forums/wpapps/en-US/18a1c525-ed80-42f9-a7a1-fc2ad1ff36bb/a-chance-for-you-to-play-for-the-windows-phone-team-in-the-technet-guru-world-cup?forum=wpdevelop

http://social.msdn.microsoft.com/Forums/windowsapps/en-US/d500974e-e015-477f-be79-eb680a0087f0/a-chance-for-you-to-play-for-the-store-app-team-in-the-technet-guru-world-cup?forum=winappswithcsharp

http://social.msdn.microsoft.com/Forums/vstudio/en-US/1390303a-fa9c-4766-a1a1-2a665c85bd5b/a-chance-for-you-to-play-for-the-wpf-team-in-the-technet-guru-world-cup?forum=wpf

http://social.msdn.microsoft.com/Forums/windowsserver/en-US/4b78dbe6-f73c-49c7-9f7e-e7b985a9b83e/a-chance-for-you-to-play-for-the-windows-server-team-in-the-technet-guru-world-cup?forum=windowsserversolutionssdk

http://social.technet.microsoft.com/Forums/en-US/f0dc53b8-7719-43de-9933-eaff44605504/a-chance-for-you-to-play-for-the-windows-server-team-in-the-technet-guru-world-cup?forum=winserver8gen

http://social.technet.microsoft.com/Forums/en-US/ffaceffc-c41b-43b8-a062-c4fd76b05e08/a-chance-for-you-to-play-for-the-windows-server-team-in-the-technet-guru-world-cup?forum=winservergen

http://social.technet.microsoft.com/Forums/sqlserver/en-US/d00d0908-39fe-447f-9abc-7c4bdab4ef63/a-chance-for-you-to-play-for-the-sql-server-team-in-the-technet-guru-world-cup?forum=sqlgetstarted

http://social.technet.microsoft.com/Forums/en-US/e00a89c0-6a4d-465d-8f53-bdd06217cde3/a-chance-for-you-to-play-for-the-windows-server-team-in-the-technet-guru-world-cup?forum=winserverDS

http://social.technet.microsoft.com/Forums/systemcenter/en-US/3f125543-13ca-46f2-bcb0-97d46c4cb27b/a-chance-for-you-to-play-for-the-system-center-team-in-the-technet-guru-world-cup?forum=configmgrgeneral

http://social.technet.microsoft.com/Forums/en-US/d9ef0d67-1188-4460-a28d-f0cdaf2b4be4/a-chance-for-you-to-play-for-the-system-center-team-in-the-technet-guru-world-cup?forum=configmanagergeneral

http://social.technet.microsoft.com/Forums/systemcenter/en-US/d87c2431-f9de-4346-9ff8-91546f04d400/a-chance-for-you-to-play-for-the-system-center-team-in-the-technet-guru-world-cup?forum=operationsmanagergeneral

http://social.technet.microsoft.com/Forums/en-US/3d427ee4-881f-4677-9fb0-85ef536d216a/a-chance-for-you-to-play-for-the-system-center-team-in-the-technet-guru-world-cup?forum=dataprotectionmanager

http://social.technet.microsoft.com/Forums/en-US/38973f79-e13c-4959-8c3f-6b9eccad12fa/a-chance-for-you-to-play-for-the-system-center-team-in-the-technet-guru-world-cup?forum=scogeneral

http://social.technet.microsoft.com/Forums/systemcenter/en-US/673869fc-be94-4542-8e49-240508521ba4/a-chance-for-you-to-play-for-the-system-center-team-in-the-technet-guru-world-cup?forum=systemcenterservicemanager

http://social.technet.microsoft.com/Forums/systemcenter/en-US/c883244e-d0dd-401a-aa03-4ab72b8f342d/a-chance-for-you-to-play-for-the-system-center-team-in-the-technet-guru-world-cup?forum=virtualmachinemanager

http://social.technet.microsoft.com/Forums/en-US/5dfa1821-21da-4c65-8c2c-646235c4fa12/a-chance-for-you-to-play-for-the-system-center-team-in-the-technet-guru-world-cup?forum=appcontroller

http://social.msdn.microsoft.com/Forums/windowsazure/en-US/abb604cb-0d5a-46ca-b369-51867118703b/a-chance-for-you-to-play-for-the-azure-team-in-the-technet-guru-world-cup?forum=windowsazuredevelopment

http://social.msdn.microsoft.com/Forums/windowsazure/en-US/e03f1339-c2ce-4a07-a6ae-cff47982724b/a-chance-for-you-to-play-for-the-azure-team-in-the-technet-guru-world-cup?forum=WAVirtualMachinesforWindows

http://social.technet.microsoft.com/Forums/en-US/82bedbba-b00a-428a-bbbf-33b403e08e80/a-chance-for-you-to-play-for-the-tn-wiki-team-in-the-technet-guru-world-cup?forum=tnwiki

http://social.technet.microsoft.com/Forums/office/en-US/08e2514a-3288-4594-a2ae-32ddc008bf31/a-chance-for-you-to-play-for-the-visio-team-in-the-technet-guru-world-cup?forum=visiogeneral