Introduction

April's competition has now closed.

May contributions are 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 APRIL 2014, 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 April 2014 and must be in English. However, the original blog or forum content can be from before April. 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 APRIL) 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 April in the Sections Below...

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

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:

• Resource Dispenser – Send Port Edition by boatseller
• Installing BizTalk Server 2013 on Multiple Virtual Machine on Windows Azure By Mohit Gupta
• Playing with wbemtest.exe tool to know about BizTalk artifacts, even passwords By Ravindar Thati
• BizTalk Server 2013: Familiarize your Windows server to work with BizTalk By Tord G. Nordahl
• BizTalk Administration and Monitoring - BizTalk Monitoring Automation Utility By Muhammad Ehsan
• Creating a Custom Extender for an Orchestration-Based Itinerary Service By Tomasso Groenendijk
• Testing WCF Service endpoints hosted in BizTalk with SOAPUI 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)

Microsoft Azure

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

• Streaming Videos using Windows Azure Media Services & ASP.NET by Shreeharsh Ambli
• How to Remotely Debug Azure Websites by Shreeharsh Ambli
• How to Create a Developer Virtual Machine on Microsoft Azure by Shreeharsh Ambli
• AADSync Frequently Asked Questions by Markus Vilcinskas
• AADSync Technical Overview by Markus Vilcinskas
• AADSync Scenario Overview by Markus Vilcinskas
• AADSync Release Notes by Markus Vilcinskas
• AADSync Content Roadmap by Markus Vilcinskas
• AADSync Installation Guide  by Markus Vilcinskas
• Windows Azure - Create new SQL Database  by João Sousa

Microsoft Visio

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

• Documenting Use Cases using Visio Professional by Shreeharsh Ambli

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

• The CodePlex Corner: Sushi by Steven Andrews
• SharePoint 2013 – Workflow Management – Starting a workflow using Powershell by Jesper Arnecke
• Building Custom Forms Using SharePoint Designer 2013 by Dan Christian
• Perform Basic Admin Operations using CSOM in SharePoint Online by Geetanjali Arora
• Replace with "Article Name" by "Profile Name" (each hyperlinked to the article and the author profile urls)
• Print specific SharePoint Fields using JQUERY by Michaelle de las Alas
• Removing Old SharePoint Designer Workflow Instances with PowerShell by Steven Andrews
• SharePoint 2013: Deep integration of Yammer - Organizational chart for My Site by Rahul A Shinde 
• SharePoint: PowerShell Runas by Matthew Yarlett

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:

• History of Microsoft Small Basic by Nonki Takahashi
• Small Basic: Object by Nonki Takahashi
• Small Basic: Default Value by Nonki Takahashi
• Small Basic Community Council: Focus Areas by Ed Price
• Features of Microsoft Small Basic v1.0 by Nonki Takahashi
• Small Basic Community Council by Ed Price

SQL BI and 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:

• Power Pivot DAX: SUMX - Application on Price and Quantity Effect Analysis by TC0098
• Hide/Unhide a Measure irrespective of 'IgnoreUnrelatedDimensions' Property of its Measure Group by S Kamath
• Creating friendly week names in Power Pivot and SSAS Tabular models with DAX by Michael Amadi

SQL Server General and 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:

• Installing SQL 2014 Step by Step Tutorial by Ronen Ariely (nickname pituach)
• Mis-Understanding of Truncate command By V.Vt
• find Enterprise-only features in your database by Praveen Rayan D'sa
• Importing an Excel Spreadsheet into a SQL Server Database by Durval Ramos

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:

• Improve Service Level Tracking Summary Report by Ivan Kovac
• Implementing SCCM in a XenDesktop VDI environment by Paul Winstanley
• Implementing AppLocker with App-V 5 Packages by Paul Winstanley
• The System Center 2012 R2 Operations Manager Survival Guide by Matthias Heil
• How to identify missing subnets in Active Directory using Orchestrator by Mr X
• How to remove netlogon.log content on all Domain Controllers within an AD domain using Orchestrator by Mr X
• Using System Center Operations Manager (SCOM) Applocker for alerting and reporting by Dave Jaskie
• Advanced options for User State Migration in SCCM 2012 R2 by Dave Jaskie

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 WeekDay Number of the Month for a date by Visakh16
• Searching All Columns in a Table for a String by Naomi N
• Same Query on Different SQL Server Versions by Ronen Ariely (nickname pituach)

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:

• masterMind Game 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:

• Writing Data in Excel File into a Database using a DataSet and SqlBulkCopy by Jaliya Udagedara
• Easily debug or optimize Linq queries using LINQPad by Shreeharsh Ambli
• Getting Started with Test Driven Development in C# (tutorial) by Shreeharsh Ambli
• Parallel / Concurrent / Async Programming in C# using Tasks by Shreeharsh Ambli
• ASP.NET MVC 5 - Connect with Azure SQLServer Database by João Sousa
• Easy Code Refactoring using Visual C# by Shreeharsh Ambli

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:

• Pivot and Hub Controls: Design Guidelines by mcosmin
• WindowsPhone 8.1 Store App Deployment with Application Deployment Tool by SubramanyamRaju.B
• Windows Phone 8 Maps API :Making Custom PushPin With Custom Tooltip (C# - XAML) by SubramanyamRaju.B
• WindowsPhone 8.1 SDK Blue: Emulator is superb with lot of features by SubramanyamRaju.B
• Windows Phone 8 Map Control -How To Get Map Bounds Area(C#-XAML) by SubramanyamRaju.B
• How to make Checked event fire on same RadioButton in WindowsPhone8 (C#-Xaml) by SubramanyamRaju.B
• WindowsPhone KeyBoard: Prevent page screen scrolling up when soft keyboard is opened(C#-XAML) by SubramanyamRaju.B
• Create tile images in Windows Store Apps by Dave Smits
• Managing Sequential Access to Local Database in Windows Phone By Spandan Buch
• Add Achievements to Your Windows 8.1 Game (C#/XAML) By Damien Allan

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:

• Changing The Background Color Of a ComboBox In WPF On Windows 8 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:

• Detailed Concepts: Lingering Objects in Active Directory and How To's? by Mahdi Tehrani
• Art Of Manipulation : Add custome attributes to Active Directory search function by Mahdi Tehrani
• Step by Step : Migrate local user profile to domain user profile with all settings by Mahdi Tehrani
• Active Directory Back to Basics : Password policies by Denis Cooper
• Active Directory Back to Basics : Sysvol by Denis Cooper
• Active Directory Back to Basics : The Schema by Denis Cooper
• Active Directory Back to Basics : FSMO Roles by Denis Cooper
• How to provide a temporary and secure administrative access to AD-integrated Critical Systems and Applications by combining the use of AD DS Fine-Grained Password Policies and Orchestrator by Mr X
• How to manage local administrator password on AD-integrated Windows Servers by combining the use of Group Policy and Orchestrator by Mr X
• How to delegate the administration of Subnets in Active Directory by Mr X

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:

• Wiki: How to record and add videos to your TechNet Wiki article by Dan Christian
• Power BI Portal by Ed Price
• Wiki: Article List for Proofreading Grammar by Ronen Ariely (nickname pituach)
• PowerShell Portal by Durval Ramos

See Also

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

This Month's Forum Announcements

• http://social.technet.microsoft.com/Forums/en-US/302b20b9-29b8-485e-a6d8-31631bab3404/biztalk-guru-needed-apply-within?forum=biztalkgeneral
• http://social.technet.microsoft.com/Forums/en-US/d78d0588-4215-4a5f-8076-4fe3b63562f9/fim-guru-needed-apply-within?forum=ilm2
• http://social.msdn.microsoft.com/Forums/sharepoint/en-US/1f3dbc56-6691-4a6e-84d8-711626e21b25/sharepoint-2010-guru-needed-apply-within?forum=sharepointgeneralprevious
• http://social.msdn.microsoft.com/Forums/sharepoint/en-US/f9d748cb-6f64-492b-af06-8e2f7d125641/sharepoint-2010-guru-needed-apply-within?forum=sharepointdevelopmentprevious
• http://social.msdn.microsoft.com/Forums/en-US/06409206-2cf1-4956-aab8-688446daaff2/small-basic-guru-needed-apply-within?forum=smallbasic
• http://social.technet.microsoft.com/Forums/sqlserver/en-US/7a46c1d5-e078-4da3-87cc-387d02a25bb3/ssas-guru-needed-apply-within?forum=sqlanalysisservices
• http://social.technet.microsoft.com/Forums/sqlserver/en-US/98253e64-c195-4abe-86ee-aef0825c26bb/power-pivot-guru-needed-apply-within?forum=sqlkjpowerpivotforexcel
• http://social.technet.microsoft.com/Forums/sqlserver/en-US/3b80b947-4222-4bab-8d0d-2f43cfd628c8/ss-dbe-guru-needed-apply-within?forum=sqldatabaseengine
• http://social.technet.microsoft.com/Forums/sqlserver/en-US/b8f62710-9682-4d6d-9c8f-0a4b2b104dfe/ssrs-guru-needed-apply-within?forum=sqlreportingservices
• http://social.technet.microsoft.com/Forums/sqlserver/en-US/f46b14ab-59c4-46c0-b125-6534aa1133e9/ssis-guru-needed-apply-within?forum=sqlintegrationservices
• http://social.msdn.microsoft.com/Forums/sqlserver/en-US/05a46031-3bd6-48c3-bb80-93c4ed59e3fc/tsql-guru-needed-apply-within?forum=transactsql
• http://social.msdn.microsoft.com/Forums/vstudio/en-US/ad7fdc72-bddd-497a-9148-dc748fc2477a/vb-guru-needed-apply-within?forum=vbgeneral
• http://social.msdn.microsoft.com/Forums/vstudio/en-US/dd2b1491-1054-4f6c-b273-07fd4dc9f8fc/c-guru-needed-apply-within?forum=csharpgeneral
• http://social.msdn.microsoft.com/Forums/wpapps/en-US/6a66bda0-1c06-4f2e-be46-d06c1becb4c5/windows-phone-guru-needed-apply-within?forum=wpdevelop
• http://social.msdn.microsoft.com/Forums/windowsapps/en-US/d82266a4-3e4f-4735-903d-23dbfce2f781/store-app-guru-needed-apply-within?forum=winappswithcsharp
• http://social.msdn.microsoft.com/Forums/vstudio/en-US/570d12a0-f10d-4369-8787-382a1f60b19a/wpf-guru-needed-apply-within?forum=wpf
• http://social.msdn.microsoft.com/Forums/windowsserver/en-US/32101ad4-737c-42d3-b0bb-7cf611654283/windows-server-guru-needed-apply-within?forum=windowsserversolutionssdk
• http://social.technet.microsoft.com/Forums/en-US/8298cbaf-9454-421b-a5dc-3700719a7a12/windows-server-guru-needed-apply-within?forum=winserver8gen
• http://social.technet.microsoft.com/Forums/en-US/ee9b57c3-d300-4ee6-be89-6558df80d9fb/windows-server-guru-needed-apply-within?forum=winservergen
• http://social.technet.microsoft.com/Forums/sqlserver/en-US/d6aac2e2-97b0-4390-9651-eef672464030/sql-server-guru-needed-apply-within?forum=sqlgetstarted
• http://social.technet.microsoft.com/Forums/en-US/2d06217b-4e29-43f8-a43c-e4fa1d2d57ab/windows-server-guru-needed-apply-within?forum=winserverDS
• http://social.technet.microsoft.com/Forums/systemcenter/en-US/dfe15a43-201c-4acd-a919-86b1f11fc9f5/system-center-guru-needed-apply-within?forum=configmgrgeneral
• http://social.technet.microsoft.com/Forums/en-US/8ae674e9-101f-4e11-977c-3f0955080708/system-center-guru-needed-apply-within?forum=configmanagergeneral
• http://social.technet.microsoft.com/Forums/systemcenter/en-US/8a453697-0982-4b60-800b-3b221154c2a9/system-center-guru-needed-apply-within?forum=operationsmanagergeneral
• http://social.technet.microsoft.com/Forums/en-US/00e6342f-753c-43bf-a12f-450f46cb1d16/system-center-guru-needed-apply-within?forum=dataprotectionmanager
• http://social.technet.microsoft.com/Forums/en-US/a2e26908-2082-4c4a-aa9b-219c104433a1/system-center-guru-needed-apply-within?forum=scogeneral
• http://social.technet.microsoft.com/Forums/systemcenter/en-US/e3751e3e-0030-4009-b062-eb6556dc829e/system-center-guru-needed-apply-within?forum=systemcenterservicemanager
• http://social.technet.microsoft.com/Forums/systemcenter/en-US/31de86c6-4df4-4ead-99c4-1effde8ca275/system-center-guru-needed-apply-within?forum=virtualmachinemanager
• http://social.technet.microsoft.com/Forums/en-US/cd240317-f0a6-4b03-909a-e7e6d4d6eb34/system-center-guru-needed-apply-within?forum=appcontroller
• http://social.technet.microsoft.com/Forums/en-US/28deaf95-81fd-4c88-942c-a8c4dba64a13/wiki-portals-guru-needed-apply-within?forum=tnwiki
• http://social.msdn.microsoft.com/Forums/windowsazure/en-US/ccbb0c98-d4bd-4f3a-80b6-b982af8743eb/azure-guru-needed-apply-within?forum=windowsazuredevelopment
• http://social.msdn.microsoft.com/Forums/windowsazure/en-US/395bd6f6-9353-4623-a654-61a7a797b481/azure-guru-needed-apply-within?forum=WAVirtualMachinesforWindows