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: 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

  • Wiki Page: BizTalk: Generating Flat File Schema for File with Tag Identifiers not at the Beginning, Grouping Data by Element and Debatching

    Table of Contents Introduction Scenario/Question Flat File Schema for a file with tag identifiers not at the beginning of the record Group By Date Debatching Output Source Code References See Also Introduction Recently there was a question posted in BizTalk forum , where an user wanted to:...
    on18 Sep 2013

  • Wiki Page: SharePoint 2013: How to Achieve an Excel Document Repository with Multiple Checkouts

    Below are the detailed requirements of what we are trying to solve here: I have 10 clients with Windows 8 Pro edition (planning to upgrade to Windows 8 Enterprise if required.) I have 1 server with 16 GB RAM ; i5 3rd Gen ; 500GB HDD ; Windows server 2012 DC edition. Now I want...
    on18 Sep 2013

  • Wiki Page: SharePoint 2010: Importing Data from an Excel File into a SharePoint List Using PowerShell

    There are several different ways to import data from a spreadsheet into a SharePoint list. Depending on your requirements, you can copy data into SharePoint lists using the DataSheet view, for example. However, there are some circumstances where this won't work (i.e. lack of support for certain...
    on18 Sep 2013

  • Wiki Page: BizTalk Developer Interview Questions and Answers - Schema

    Table of Contents Introduction Questions and Answers Author Contributors See Also Introduction This article intends to cover the answers to BizTalk schema related questions, which a BizTalk developer can face during an interview. Questions and Answers What is the purpose of a document...
    on17 Sep 2013

  • Wiki Page: SQL VDI Backups Fail with Error 9001

    Problem The issue was with SQL backups failing in SQL 2008 server due to the SQL Server VSS writer as posted by the user in the forum . Explanation When backup is occurring through SQL VDI Backups , it requires 3 threads to perform the backups for a single database. The link below...
    on17 Sep 2013

  • Wiki Page: SSRS (Matrix): How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling

    This article is an outcome of my answer to this question on MSDN SSRS forum . Previously I wrote similar article on SSRS: How to Repeat Headers on Each Page and keep headers fixed while scrolling for a table. In this article , let us see an example on how to repeat headers on each page and keep headers...
    on17 Sep 2013

  • Wiki Page: SSRS: Multi-valued Parameter as Stored Procedure Input

    Few months back I wrote an article on Multi-valued Parameter as Stored procedure Input, which will work only for single character multi-valued input parameter . Now let us see an example for SSRS report with Multi-valued Parameter as Stored procedure Input, which will work in all cases. ...
    on17 Sep 2013

  • Wiki Page: Ubicación API en Windows Phone 8 (es-ES)

    Tabla de Contenidos Resumen Introducción Tecnologías de localización proveedor A la ubicación actual en Windows Phone 7.5 Capacidades Geolocalizador en Windows Phone 8 Seguimiento de la ubicación de fondo Resumen Este artículo presenta las características de ubicación de...
    on17 Sep 2013

  • Wiki Page: Fixing Missing Data Based on Prior Row Information

    One of the commonly asked problems in the Transact-SQL forum is how to provide missing information based on the information in the first prior row that has data (or alternatively in the next row (by date)). One of the examples where this problem was discussed is this thread . In this thread...
    on16 Sep 2013

  • Wiki Page: Custom Styling the Alternate Rows inside ListView/GridView

    To style the items inside ListView/GridView based on item index we will use StyleSelector to define custom styling for each item. To implement this, we will define the class derived from StyleSelector as shown below. Inside this class we are just returning the style which will apply...
    on16 Sep 2013

  • Wiki Page: SharePoint 2010: Freeze Header Row of SharePoint List View

    When a SharePoint list contains lots of data then it becomes hard to understand the data when you scroll down and header row is not visible , every time you have to scroll up to see what data in this particular cell is, you tend to check the column in the header. It will be easy to understand the data...
    on16 Sep 2013

  • Wiki Page: BizTalk Developer Interview Questions and Answers - Functoid

    Table of Contents Introduction Questions and Answers Author Contributors See Also Introduction This article intends to cover the answers to BizTalk functoid based questions, which a BizTalk developer can face during an interview. Questions and Answers What is functoid? The term functoids...
    on16 Sep 2013
Page 1 of 9 (205 items) 12345»
Can't find it? Write it!

Post an Article