Resources For IT Professionals
Get this Tag RSS feed
Tag Cloud
Wiki  > All Tags > TechNet Guru
Tagged Content List

  • Wiki Page: IEnumerable<T> Vs. IQueryable<T>

    I am sure most of you have seen the following interfaces when you write code with .NET Framework. IEnumerable IEnumerable<T> IQueryable IQueryable<T> Have you ever wondered what these really are. Let’s see the beauty of them and let’s have a dig into IEnumerable<T>...
    on22 Sep 2013

  • Wiki Page: How to Compare Two Tables Definition / Metadata in Different Databases

    This article is about the example on T-SQL Script to compare two tables definition / metadata in different databases . The T-SQL Script [used to compare two tables definition / metadata in different databases] in this article can be used from SQL Server 2012 and above version because I have used...
    on22 Sep 2013

  • Wiki Page: How to Check the Syntax of Dynamic SQL Before Execution

    This article is about the system function sys.dm_exec_describe_first_result_set that can be used to check the syntax of dynamic SQL before execution. This system function sys.dm_exec_describe_first_result_set was introduced in SQL Server 2012. Create sample table and insert sample data : ...
    on22 Sep 2013

  • Wiki Page: FIM 2010 R2: Creating a Custom Metaverse Object Deletion Rule Using C#

    Table of Contents Overview Solution requirement Contoso synchronization information Proposed design Code logic MV Extension Object deletion code I recently wanted to create a custom object deletion rule, and searched for some sample code on the Web that I could reuse. Since I could not find any...
    on22 Sep 2013

  • Wiki Page: BizTalk Server 2013: How to use SFTP Adapter

    Table of Contents Introduction How to prepare a testing environment to communicate with the SFTP adapter? How to configure BizTalk SFTP Adapter? How to test BizTalk Adapter? Conclusion See Also Introduction BizTalk server has supported the FTP (File Transfer Protocol ) adapter since its early release...
    on22 Sep 2013

  • Wiki Page: BizTalk Server 2013: WCF-SQL executing a stored procedure in Windows Azure SQL Database

    Table of Contents Introduction Use Case Scenario Creating a database, table, and stored procedures in Windows Azure SQL Database Create a database Create a table in Windows Azure SQL Database through the management portal (Silverlight) Create stored procedures in Windows Azure SQL Database through the...
    on22 Sep 2013

  • Wiki Page: TechNet Guru Contributions for September 2013

    Table of Contents Introduction How to Enter 1) Create a new TechNet article 2) Tell us about it Categories BizTalk Forefront Identity Manager SharePoint 2010 / 2013 Small Basic SQL Server Analysis Services, PowerPivot SQL Server Database Engine SQL Server Reporting Services, Power View, & SQL Server...
    on21 Sep 2013

  • Wiki Page: Custom MDX Query for Excel Filters

    More Often we may want to write custom Filters for Cube Data retrieved through Excel. You can achieve it through VBA or simply by adding few iterations on Excel. We can Achieve Custom calculations by simply adding OLAP PIVOT TABLE Extension to EXCEL . A common scenario would be building a 13 week...
    on20 Sep 2013

  • Wiki Page: BizTalk Server: Tracking Data Using BizTalk Admin Console

    This article intends to show how data can be tracked using Admin Console, resulting from this forum question. Table of Contents Introduction What are the artifacts where tracking can be applied How to Access BizTalk Server Admin Console Available options for tracking Applying tracking on...
    on19 Sep 2013

  • Wiki Page: BizTalk Server: Monitor BizTalk Server Job

    Table of Contents Introduction Monitor BizTalk Server Job Custom View Considerations Resolving detected issues See Also Introduction A new feature in BizTalk Server 2010 is a new SQL job called Monitor BizTalk Server . This job and other database jobs are created when you configure a BizTalk group...
    on19 Sep 2013

  • Wiki Page: Dropping a Clustered Index Will Not Reorganize the Heap

    If a clustered index will be turned into a HEAP, no reorganization of the data will occur. This "myth" is sometimes popping up in forums or blogs. A view "behind the scenes" will describe how Microsoft SQL Server is handling this operation. Before the deep dive into the internals...
    on19 Sep 2013

  • Wiki Page: Validating Data in WPF 4.5 Using the INotifyErrorDataError Interface

    Table of Contents Introduction Multiple errors per property Asynchronous validation Visual feedback Custom error objects Cross-property errors Introduction This post is about how you can validate data in a WPF application using the System.ComponentModel.INotifyDataErrorInfo interface that was...
    on19 Sep 2013

  • Wiki Page: How to Use SQLite with a Windows Phone 8 Application

    Table of Contents Introduction Building the Sample Before you compile you will need to add some conditional compilation constants in the application Introduction How to use SQLite with a Windows Phone 8 application Building the Sample To build this sample you will need Visual Studio 2012...
    on18 Sep 2013
Page 1 of 15 (375 items) 12345»