Visit a content portal to find information, resources, and help over a wide range of topics, projects, and issues.
By Selcin Turkarslan July 6, 2013
Windows Azure SQL Database provides a large-scale multi-tenant database service on shared resources. In order to provide a good experience to all SQL Database customers, your connection to the service may be closed due to several reasons, like throttling. This article introduces SQL Database and its network topology. Then, it lists the reasons for connection losses and provides guidelines and best coding practices on how to...
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...
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...
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...
More featured articles