TechNet Guru Contributions - June 2013

[toc] 
 

Introduction

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.

Submissions for June are now closed. July submissions should go HERE. Winners are announced in this blog post.

This is a TechNet Wiki awards program, so we only want WIKI LINKS for articles created in JUNEJune, 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 June 2013 and must be in English. However, the original blog or forum content can be from before June. 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 JUNE) 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

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 June in the Sections Below...

NOTE: These MUST be TechNet Wiki articles, and they MUST be written in June 2013.

BizTalk

The TechNet Guru June competition is announced in this BizTalk forum thread.
Post a link to the TechNet Wiki page of your BizTalk contribution here:

• BizTalk: Monitoring and Automatically Starting Host Instances Via A Scheduled Task By Ron Phillips
• Complex FlatFile Conversion using Biztalk schema and Map  By Mohit Gupta
• Implementation of Routing slip pattern using ESB Toolkit 2.1 and BizTalk Server By Abhijit Mahato
• XSLT Muenchian grouping - Biztalk Complex transformation By Mohit Gupta

SharePoint 2010

The TechNet Guru June competition is announced in this SharePoint General forum thread and in this SharePoint Development forum thread. Post a link to the TechNet Wiki page of SP 2010 contribution here:

• New! SharePoint 2013: Branding Solutions as an App! Showcase your solutions now! By Sunny Dasgupta
• SEO Friendly SharePoint Sites/Pages By Sunny Dasgupta
• Uploading (and Resizing) Images to a SharePoint Picture Library via a Webpart By Matthew Yarlett
• What's New for Developers in Word Automation Services 2013 By Usama Wahab Khan
• Deploy Lookup as a Site Column By Stefan Bauer
• Showing display name of selected item of a dropdown in forms library in InfoPath 2010 By Ashish Gupta
• Step by step configuring document archival in SharePoint 2010 By Ashish Gupta
• SharePoint 2010: Resolve Design Changes without Design Skills and authentication Problem with WireShark By Gokan Ozcifci
• SharePoint 2010: How does Web Analytics works under By Gokan Ozcifci
• SharePoint 2010: Reminder to myself: Automatic Password Change By Gokan Ozcifci
• SharePoint 2010: User Profile Synchronization Proxy in DMZ zone with One Way Trust By Gokan Ozcifci   
• How to achieve Excel document repository with multiple checkout using SharePoint 2010/2013, Windows 8 and Server 2012 By Libin.NET
• What happens internally when a web application is created in SharePoint By Mohammad Nizamuddin
• How to bypass the Firewall, TMG and Proxy during a content crawl in SharePoint Publishing Farm By Gokan Ozcifci
• Best Practices - Checking SharePoint list field NULL value in code By Mohammad Nizamuddin
• Freeze Header Row of SharePoint List View By Mohammad Nizamuddin
• SharePoint 2010: What if the domain NetBIOS name is different than the FQDN of the domain with User Profile By Gokan Ozcifci
• SharePoint 2010: How to maintain InfoPath Form Changes or Versions By Suresh C
• SharePoint : Bread Crumb for List/Library View Web Part in Wiki Page By Joydeep K.
• Using the KeywordQuery class to search SharePoint content By Matthew Yarlett

Small Basic

The TechNet Guru June competition is announced in this Small Basic forum thread.
Post a link to the TechNet Wiki page of your Small Basic contribution here:

• Small Basic: Did You Know?  By Nonki Takahashi
• Small Basic: How to Convert Multi-Line Text into Array of Lines  By Nonki Takahashi
• Small Basic: IDE Colors  By Nonki Takahashi
• Small Basic: How to Use Trigonometric Functions  By Nonki Takahashi
• Small Basic: How to Draw Triangle  By Nonki Takahashi
• Small Basic: How to Make a Turtle Maze Game  By Nonki Takahashi
• a
• Development Map for Becoming a Good Programmer using Small Basic and MSDN By Jibba Jabba

SQL Server Analysis Services

The TechNet Guru June competition is announced in this SSAS forum thread.
Post a link to the TechNet Wiki page of your SSAS contribution here:

• Aggregations in SSAS By Yogish Bhat
• MOD Function in MDX By Yogish Bhat

SQL Server Integration Services

The TechNet Guru June competition is announced in this SSIS forum thread.
Post a link to the TechNet Wiki page of your SSIS contribution here:

• replace me

SQL Server Reporting Services/Power View

The TechNet Guru June competition is announced in this SSRS forum thread.
Post a link to the TechNet Wiki page of your SSRS or Power View contribution here:

• [[Adding Links in SSRS Reports]]  By Tim Pacl
• [[Concatenating Data Column Values Into a Single String]]  By Tim Pacl
• [[Counting Occurrences in a Concatenated String]]  By Tim Pacl  
• [[Preset Date Parameters]]  By Tim Pacl
• [[Setting Subreport Visibility From User Input]]  By Tim Pacl
• [[Sorting Elements of a Concatenated String]]  By Tim Pacl

Transact-SQL

The TechNet Guru June competition is announced in this T-SQL forum thread.
Post a link to the TechNet Wiki page of your TSQL contribution here:

• EOMONTH() Function Usage in SQL Server 2012 and On By Kalman Toth
• [[SET ANSI_PADDING Setting and Its Importance]]  By Naomi N (See also author's translation of this article into Russian)
• [[Generate XML with Same Node Names using FOR XML PATH]] By SathyanarrayananS
• T-SQL: Remove Leading and Trailing Zeros By SathyanarrayananS
• SQL Server Result Set In An HTML Email By  Johnny Bell Jnr
• [[Fixing Missing Data Based on Prior Row Information]] By Naomi N 
• T-SQL: RIGHT, LEFT, SUBSTRING and CHARINDEX Functions By Johnny Bell Jnr
• T-SQ
• T-SQL: Group by Time Interval By Naomi N 
• [[How SQL Server Determines Type of the Constant]] By Naomi N

Visual Basic

The TechNet Guru June competition is announced in this Visual Basic forum thread.
Post a link to the TechNet Wiki page of your VB contribution here:

• How to Communicate with a Microcontroller or Other Serial Device in VB.Net By Reed Kimble
• Bitmap.Lockbits De-Mystified .Net By Paul Ishak

Visual C#

The TechNet Guru June competition is announced in this Visual C# forum thread.
Post a link to the TechNet Wiki page of your C# contribution here:

• Named Pipes IO for Inter-process Communication By Dan Randolph

Windows Phone

The TechNet Guru June competition is announced in this Windows Phone Development forum thread.
Post a link to the TechNet Wiki page of your Windows Phone contribution here:

• How to Launch Windows Phone 8 Emulator without using Visual Studio 2012? By isenthil
• Maps and clusters By Tiziano Cacioppolini 
• How to use Sqlite with a Windows Phone 8 app By Ken Tucker
• Text To Speech in Windows Phone 8 By Lohith Goudagere

Ken and Lohith's June contributions have been re-included in July's nominations because they were last minute entries that missed inclusion into our voting tool. Sorry for the confusion.

Windows Store Apps

The TechNet Guru June competition is announced in this Windows Store app development forum thread.
Post a link to the TechNet Wiki page of your Store App contribution here:

• Building an App using the DataviewModel from external XML By Sachin S
• Insert ComboBox item separator which is filled through Data Binding By Sachin S
• Basic ColorPicker Control inside Settings Pane By  Sachin S

WPF

The TechNet Guru June competition is announced in this WPF forum thread.
Post a link to the TechNet Wiki page of your WPF contribution here:

• Cascading ComboBoxes in WPF using MVVM By Magnus Montin (Magnus (MM8))
• Set Brush for ScrollViewer Thumb By Gaurav Khanna
• WPF: How to manage available/selected lists. Simple examples. MVVM and Code behind By Peter Laker (XAML guy)
• WPF: TreeView SelectedItem TwoWay MVVM (plus expand to selected and close all others) By Peter Laker (XAML guy)
• Event handling in an MVVM WPF application By Magnus Montin (Magnus (MM8))          

We'll remove some categories for July if they don't receive contributions in June. We might remove Windows Store Apps for July (since those articles can likely be C# or VB articles). We might combine SharePoint 2013 and SharePoint 2010 for July. Some technologies that are being considered to add for July: FIM, SQL Server Database Engine, and Excel 2013 (+ PowerPivot + Power View). Leave a comment with more suggestions!

See Also

•  TechNet Guru Contributions