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: TechNet Guru Contributions

    Table of Contents What this Competition is About? List of Existing (past and present) Competitions Winners See Also What this Competition is About? Starting from May 2013 , TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert...
    on12 Sep 2013

  • Wiki Page: SQL Server PIVOT

    Table of Contents Problem Definition Common Problem Other Blogs See also Problem Definition Recently in this thread I helped to solve a relatively simple problem. I will quote my solution and then I will explain the main problem people often encounter with PIVOT solutions ; WITH...
    on12 Sep 2013

  • Wiki Page: T-SQL: Dynamic Pivot on Multiple Columns

    Table of Contents How to make a dynamic PIVOT on multiple columns See also Other Languages How to make a dynamic PIVOT on multiple columns The problem of transposing rows into columns is one of the most common problems discussed in MSDN Transact-SQL forum . Many times the problem of creating...
    on12 Sep 2013

  • Wiki Page: SSIS: Flat File Source - Datetime Column Format Issue & Solution

    Table of Contents 1.0 Introduction 2.0 Problem Definition 3.0 How does it work 4.0 Solution 1.0 Introduction Flat files as Source are widely used in SQL Server Integration Services Tool. This article will discuss about one common issue with Flat File Date time Columns. (Details can be found...
    on12 Sep 2013

  • Wiki Page: Multiple Columns in WPF ListBox

    In this article we will discuss ways to have multiple columns in WPF ListBox control and layout the ListBox such that each row has 3 items. All WPF controls deriving from ItemsControl provide an ' ItemsPanel' property that allows us to replace the internal layout panel that arranges the items...
    on12 Sep 2013

  • Wiki Page: SharePoint 2013: Social Features, Community Site

    Table of Contents SharePoint Social components Community Site Which things can be achieved in Community site? Create Community Site 1. By choosing 'Community' site template and create stand-alone community. 2. By activating Community features on the existing sites Community Site features ​1....
    on12 Sep 2013

  • Wiki Page: BizTalk Server Installation and Configuration Checklist

    Table of Contents Introduction General information regarding updating this article General advices before Installation of BizTalk and SQL machine SQL Server Installation Install BizTalk After installation SQL BizTalk See Also Introduction This list is intended as a simple checklist to verify the...
    on11 Sep 2013

  • Wiki Page: Azure Mobile Services Custom API - Exploring Server Side Capability

    This Wiki Article explores some of the capabilities of Azure Mobile Services API that might be of interest in some scenarios. Note: this article assumes some familiarity with Azure Mobile Services. For a great introduction see the Microsoft documentation . Node.js It is important...
    on11 Sep 2013

  • Wiki Page: Bitmap.Lockbits De-Mystified .Net

    How To Use Bitmap.Lockbits Many people may have noticed in the past how intimidating using Bitmap.Lockbits has been due to a lack of clarification/documentation on its usage. This article attempts to do an in depth review of its usage. It does not focus on alternate methods to lockbits. I remember...
    on11 Sep 2013

  • Wiki Page: Visual Basic - Knife Thrower!

    Table of Contents What is this article about? Glossary/MSDN Library Cross Reference of terms What is GDI+? What is a polygon in Visual Basic? How does polygon rotation work? Part1 Form Initialization Part2 Form1's Load event Part 3 - Waiting for input Part 4 - The polygon Class Project Source...
    on11 Sep 2013

  • Wiki Page: Convert System.Decimal to and from Byte Arrays (VB & C#)

    Table of Contents Introduction ​ Getting the bytes of a System.Decimal Creating an instance of the System.Decimal from bytes Summary References Introduction ​ At first glance converting the datatype (System.Decimal) to and from bytes may appear to be a challenge, this is because the...
    on11 Sep 2013

  • Wiki Page: T-SQL: Script to Find the Names of Stored Procedures that Use Dynamic SQL

    This script was developed to answer the question in this thread I need query find all the SPs that used dynamic SQL We can execute dynamic sql using sp_executesql or just with Exec / Execute . To find the names of the StoredProcedure that may have used dynamic SQL, this script can be used...
    on11 Sep 2013

  • Wiki Page: Understanding NOLOCK Query Hint

    In our day to day T-SQL querying we use lot of query hints to modify the way a particular query will be executed. When we specify query hint SQL Server produces optimized plan using this query hint. This can be dangerous if it is not tested before in UAT as it is known fact that query plan which SQL...
    on11 Sep 2013

  • Wiki Page: How to Get the Textual Representation of a Number (Convert Number to Words) in VB.Net

    Table of Contents Introduction Designing the Class Converting Decimal Values Usage Example Summary Appendix A: Complete Code Sample Introduction Converting a decimal number into its textual representation is nothing new and the Internet is full of examples on ways to do so. The basic idea...
    on11 Sep 2013

  • Wiki Page: T-SQL: Applying APPLY Operator

    This article originates from the following MSDN Transact SQL Forum's question: Complex logic to be implemented in SQL - Please help! and I hope I made a pun with its title. In my solution to the problem presented by the thread's originator I am going to show how to use OUTER APPLY...
    on11 Sep 2013

  • Wiki Page: T-SQL: Date-Related Queries

    In this article I plan to add various interesting date related queries. This article will expand when new problems will present themselves in the Transact-SQL forum. Table of Contents Finding Day Number from the Beginning of the Year Finding Beginning and Ending of the Previous Month See Also ...
    on11 Sep 2013

  • Wiki Page: T-SQL: Gaps and Islands Problem

    This article will consider a simple classical Gaps & Islands problem asked recently in Transact-SQL Forum at MSDN with non original title "Query Help" . Table of Contents Problem Definition Solution See Also Problem Definition The thread originator was kind enough...
    on11 Sep 2013

  • Wiki Page: SharePoint 2013: How to Get Following and Followers of User by using JSOM or JavaScript

    Table of Contents ​ Using Social Information in SharePoint 2013 First step Second Step See Also Other languages ​ Using Social Information in SharePoint 2013 Getting Following and followers of a specific or current user in SharePoint 2013 is very easy. SharePoint 2013 has provided client side...
    on11 Sep 2013

  • Wiki Page: TechNet Guru Contributions - August 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...
    on10 Sep 2013

  • Wiki Page: BizTalk Message Based Routing: why is my file not transferred to the location of the Send Port

    Table of Contents Introduction Scenario The Receive Location listens to the wrong folder or contains a typo The Receive Location is not enabled Mismatch of the file mask on the Receive Location Tricked by Windows Explorer A Service Window or Start/Stop Date prevents the Receive Location to poll for incoming...
    on10 Sep 2013

  • Wiki Page: BizTalk: Monitoring and Automatically Starting Host Instances Via A Scheduled Task

    by Ron Phillips, aka El Bo on Technet Table of Contents Introduction Building the Sample See Also Introduction If you've ever gotten a phone call at 2 am asking you to figure out why a system is down, you'll appreciate the utility of self-healing systems. With a little work with...
    on10 Sep 2013

  • Wiki Page: SSRS: Multi Font Color / Multi Font Size within a Single Field / Textbox

    This article explains how to format the characters within a single Field or Textbox with varying font size and font color in SSRS. Consider the below code sample as the requisite dataset query: DECLARE @UnitsOfMeasurement TABLE (Measurement VARCHAR (50),Units VARCHAR (20)) ...
    on9 Sep 2013

  • Wiki Page: BizTalk Server: WCF-SQL Adapter Table Operations

    Table of Contents Introduction WCF-SQL Adapter WCF-SQL Features Adding the WCF-SQL Explicitly Adapter Metadata Wizard Table Operations Create BizTalk project and generate schema Create messages instances Build and deploy the BizTalk project Configure the application Wrap up Call for action See Also ...
    on9 Sep 2013

  • Wiki Page: How to Generate Index Creation Scripts for all Tables in a Database using T-SQL

    The need often arises to create or recreate the indexes for all tables in a database, especially in development and testing scenarios. This article presents a script to generate Index Creation Scripts for all tables in a database using Transact-SQL (T-SQL). The code block below will generate Index...
    on8 Sep 2013

  • Wiki Page: We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced

    by Paul Turley , Mentor, SolidQ from SQLServerBiBlog.com Table of Contents Power BI: a new suite of Business Intelligence tools Power Query Power Map Power Pivot Power View Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several...
    on8 Sep 2013
Page 3 of 9 (205 items) 12345»
Can't find it? Write it!

Post an Article