Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  TechNet Guru
Tagged Content List

  • Wiki Page: Custom Sort in Acyclic Digraph

    Table of Contents Problem definition Vocabulary Digraph (Directed Graph) Acyclic Graph Acyclic Digraph Topological Ordering Solution See Also Problem definition This article is derived from this MSDN forum post. This article addresses the task of how to present a Tree in a custom order ...
    on8 Sep 2013

  • Wiki Page: T-SQL: Remove Leading and Trailing Zeros

    In this post I have consolidated few of the methods to remove leading and trailing zeros in a string . Here is an example : DECLARE @BankAccount TABLE (AccNo VARCHAR (15)) INSERT @BankAccount SELECT '01010' INSERT @BankAccount SELECT '0010200' ...
    on8 Sep 2013

  • Wiki Page: Generate XML with Same Node Names using FOR XML PATH

    In this post we are going to see how we can generate XML in the below mentioned format from the relational data. < row > < column >1</ column > < column >1</ column > </ row > < row > < column >2</ column > <...
    on8 Sep 2013

  • Wiki Page: T-SQL Script to Get Detailed Information about Index Settings

    This article is about the script which I wrote to get detailed information about Index settings. The script in this article does not show any information about missing indexes or index usage details, the script will show only the information about settings made on an Index using CREATE /ALTER INDEX...
    on8 Sep 2013

  • Wiki Page: SSRS - RDL Compare

    This article shares the information on how to compare two versions of the same report . Sometimes we might be in a need to compare the changes in two versions of the same report. We can observe the changes easily on the report if it is a color modification or something like this, What if...
    on7 Sep 2013

  • Wiki Page: Progress of a Task in C#

    By default Task doesn’t report its progress as a BackgroundWorker does. But that doesn’t mean we can’t get a progress of a Task. There is a new interface which was introduced with .NET framework 4.5 which is IProgress<T> . This interface exposes a Report(T) method, which the async task calls...
    on7 Sep 2013

  • Wiki Page: C#: Extension Methods in .NET

    Sometimes there is a need to add customized/ user defined methods to existing datatypes. If we write String s1 and then put a dot after s1, we get a list of methods pre-defined such as Aggregate<>, All<>, Average<> etc. With extension methods, we can write out our own method...
    on7 Sep 2013

  • Wiki Page: Serializing WCF Contract with Object Property

    Table of Contents Introduction WCF Service The issue stems with how to handle contracts with object type properties: WCF Client Initial observations ​ Adding a new class ​ Introduction This sample project is posted in reply to the forum post: http://social.msdn.microsoft.com/Forums/en-US...
    on7 Sep 2013

  • Wiki Page: Introduction to WCF Data Services

    Table of Contents Introduction OData(Open Data Protocol) WCF Data Service + oData Data Service Providers Introduction WCF Data Services (formerly known as ADO.NET Data Services and codename is “Astoria”) is a platform for what Microsoft calls Data Services. This is a component of the .NET...
    on7 Sep 2013

  • Wiki Page: WCF Data Services with Entity Framework Provider

    This Article focuses on how we can implement a WCF Data Service with Entity Framework Provider. I have created an empty ASP.NET web application. Now let’s start by adding an ADO.NET Entity Data Model to the project. ADO.NET Entity Data Model Now I am...
    on7 Sep 2013

  • Wiki Page: C#: PPT to PDF-Unable to Cast COM Object of Type 'Microsoft.Office.Interop.PowerPoint. ApplicationClass' to Interface Type 'Microsoft.Office.Interop.PowerPoint. _Application

    My team have been struggling with COM Component issue for about one week, it almost frustrated the developer, me and project manager. Uff.. after intense amount of googling and trial method, several time repair and installation of office, the problem was still bugging all the team members. Finally...
    on7 Sep 2013

  • Wiki Page: Business Classes to TableServiceEntity Mapping Using Automapper

    Summary The following illustrates a convenient method of setting up a map between business classes to the Azure Table Storage entities using Automapper. Special Requirements For this example both Automapper and Azure Table Storage were used: Automapper 2.2.1 Windows Azure Storage 2.0.6...
    on7 Sep 2013

  • Wiki Page: T-SQL: How to Find Rows with Bad Characters

    One of the commonly asked questions in Transact SQL Forum on MSDN is how to filter rows containing bad characters. Also, often times these bad characters are not known, say, in one of the recent posts the question was to filter all the rows where characters were greater than ASCII 127. The...
    on7 Sep 2013

  • Wiki Page: Deploy Silverlight Application to Server/ IIS Site

    You might love to deploy the Silver-light application in localbox. I did lots of Bing searches but didn’t get short and sweet steps. But as this is again a Microsoft technology, everything is just a link away. Following are the simplest steps: 1) Right click on .web project (In Silverlight...
    on7 Sep 2013

  • Wiki Page: How do you manage unmanaged buffers used for P/Invoke

    This is a solution I posted to the C# forum answering an OP's question http://social.msdn.microsoft.com/Forums/vstudio/en-US/f569a375-5d5d-458f-a0ed-bff87bd97167/how-do-you-manage-unmanaged-buffers-used-for-pinvoke The OP needed to know a way to make a wrapper that cleans up after itself...
    on7 Sep 2013

  • Wiki Page: SQL Server 2008+: Group By with Wings

    This article includes information about a feature from SQL Server 2008 (and up) - Group by extensions. Table of Contents Problem Definition Solution Grouping Sets Cube: Conclusion References Problem Definition In SQL Server 2005 and earlier versions, we would have faced the situation...
    on7 Sep 2013

  • Wiki Page: How to Store Different Languages Data in the Same Database and Analyse them Effectively

    Reference # http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d6da2336-5208-4d1c-9406-dcccbb003dca/collation Today we got an interesting question from the user, where he is trying to store multiple collations consisting of multiple languages in the same database and he needs to manage it...
    on7 Sep 2013

  • Wiki Page: Windows Store Apps Issue with ComboBox Leads to Crash in ATOM Processor

    In Windows 8 Store apps, if a combobox is included inside a popup like a normal fly out, and the selection changed event cause the pop up to close, and the App running on ATOM processor machine then the App will crash most of the times. This issue just happens on ATOM processors. The Reason ...
    on6 Sep 2013

  • Wiki Page: BizTalk Server 2013: Consuming a RESTFul Endpoint using WCF-WebHttp

    Table of Contents Introduction REST API Consume a RESTFul endpoint Scenario Configure the Send-Port using the WCF-WebHttp HTTP Method and URL Mapping Variable Mapping WCF-WebHttp Transport Properties Wrap up Call for action See Also Introduction BizTalk Server 2013 offers few new adapters out-of...
    on6 Sep 2013

  • Wiki Page: BizTalk Server 2013: IAAS Provisioning a Virtual Machine

    Table of Contents Introduction Provisioning a BizTalk Virtual Machine Windows Azure Management Portal Quick Create From Gallery Connect to Virtual Machine PowerShell (Scripting) Uploading an existing VHD Deleting the Virtual Machine Wrap up Call to action See Also Introduction BizTalk Server 2013...
    on6 Sep 2013

  • Wiki Page: SSIS: How to Add Missing Control Flow Items / Data Flow Items to the SSIS Toolbox

    This article is about adding missing Control Flow Items / Data Flow Items to the SSIS Toolbox, which is one of the FAQs in MSDN SSIS forum - http://social.msdn.microsoft.com/Forums/en-US/07c2c57d-c133-47bf-80f4-a61b4d905b78/bids-2008-r2-where-is-toolbox-control-flow-items In SSIS, Tools - >...
    on5 Sep 2013

  • Wiki Page: SSRS: Multiple Ways to Split a String into Multiple Lines

    This post is about how to split a string inside textbox or field into multiple lines . Below are the options to split a string into multiple lines : i.) using VBCRLF ii.) using chr(10) iii.) using <br> HTML tag Consider for example that I have a string "Microsoft Reporting...
    on5 Sep 2013

  • Wiki Page: SSRS: How to Repeat Headers for Each Group

    This article is going to share the information on i) how to repeat headers for each group ii.) how to overcome this error: "An error occurred during local report processing . The definition of the report '/Report ' is invalid . The tablix 'Tablix' has a detailed member...
    on5 Sep 2013

  • Wiki Page: SSRS: How to set Column Visibility Property for Many Columns Based on Parameter's Value

    This article is about setting Column Visibility property for many columns based on Parameter value. We can set Column Visibility property for Tablix/Matrix columns by selecting the column and then right-click - > Column Visibility - > Show or hide based on expression and then enter our custom...
    on5 Sep 2013

  • Wiki Page: SSRS: How to Display Multiple Columns (Header and Value) Horizontally Stacked in one Row Cell

    This article is the outcome of my answer to this question in the MSDN SSRS forum . Example : Consider below query is my dataset : DECLARE @sample_data table ( Name varchar (50), AgeYears INT , WeightPounds INT , HeightInches INT ) insert...
    on5 Sep 2013
Page 4 of 9 (205 items) «23456»
Can't find it? Write it!

Post an Article