Wiki

TechNet Wiki

Visit a content portal to find information, resources, and help over a wide range of topics, projects, and issues.

Featured Articles (updated 7/2/13)

T-SQL: Dynamic Pivot on Multiple Columns

By Naomi N
July 2, 2013

The problem of transposing rows into columns is one of the most common problems discussed in Transact-SQL forum. Many times the problem of creating a dynamic pivot comes into the light. One thing that many people who ask this question forget is that such transposing is much easier to perform on the client side than on the server where we need to resort to dynamic query. However, if we want to make such pivot dynamically...

Retreiving the Screen Resolution for Windows Phone 8 Emulator

By isenthil
June 29, 2013

The Windows Phone 8 supports 3 different screen resolutions like WVGA,WXGA,720P. If you are a developer and want to retreive the screen resolution dynamically , you can use the ScaleFactor property defined in App.Current.Host.Content.ScaleFactor. Eg: string data = App.Current.Host.Content.ScaleFactor.ToString(); This will retreive the one of the 3 values 100 , 160 , 150 which refers to the screen resolutions...

SQL Server PIVOT

By Naomi N
June 27, 2013

Recently I helped to solve a relatively simple problem. I'll quote my solution and then I'll explain the main problem people often encounter with PIVOT solutions. The pivot solution by itself is not complex, it's a simple static PIVOT. But the thread originator was having a problem arriving to it. The main problem is to understand, that all columns which are not mentioned in the PIVOT aggregate function in the PIVOT clause will be aggregated, so if there...

Spell Checking WinRT Component (C#, VB, HTML5/JavaScript)

By Sachin S
June 24, 2013

This article provides spell checking functionality for Windows Store Apps, which is missing out-of-box for C#-VB/XAML, HTML/JavaScript apps. This was implemented in response to MSDN forum questions where developers are often looking for spell check solutions in C# or JavaScript apps. Writing a wrapper over the spell checker factory is easy. However, it could be a little tricky for C# developers...

More featured articles


Recent Activity
Loading activity...