Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  Awards
Tagged Content List

  • 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: 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: T-SQL Useful Links

    This article will share collection of links in regards to various aspects in Transact-SQL language I acquired over the years and saved in links.txt file. Many of these links come very handy answering various questions in SQL Server related forums. Table of Contents Select Top N Rows per Group Performance...
    on15 Sep 2013

  • 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: 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: 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: 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: 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: 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: TechNet Guru Contributions - July 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...
    on5 Sep 2013

  • Wiki Page: How SQL Server Determines Type of the Constant

    Table of Contents Problem Definition Explanation Conclusion See Also Problem Definition There was an interesting question asked recently in Transact-SQL forum "Basic doubt in Round function" . The problem was stated as following: SELECT ROUND(744, -3) produced...
    on4 Sep 2013

  • Wiki Page: SET ANSI_PADDING Setting and Its Importance

    Table of Contents Problem Description Investigation Resolution Script to correct problem in the whole database Default Database Settings See Also Other Languages Problem Description Recently I got an interesting escalation to solve for the client. Our VFP based application was getting the following...
    on4 Sep 2013

  • Wiki Page: T-SQL: Group by Time Interval

    Table of Contents Simple Problem Definition Solution Complex Problem Definition and Solution See Also Simple Problem Definition A question was posted today in Transact-SQL forum " Counts by Time Interval " The thread originator wanted to know how to find how many jobs were completed...
    on3 Sep 2013

  • Wiki Page: T-SQL: FIFO Inventory Problem - Cost of Goods Sold

    In this article I am going to explain the FIFO (first in first out) algorithm for calculating cost of goods sold. This is the real business problem I am working on now. Table of Contents Different methods of calculating Cost of Goods Sold in the Inventory Calculation Implementing FIFO Cost of Goods...
    on11 Aug 2013

  • Wiki Page: Using Custom Code in SSRS Reports for Advanced String Operations

    Overview SQL Services Reporting Services is a very powerful tool and with each new release, it grows in functionality. However many users find that the expression builder functions do not quite do what they need. Fortunately, Microsoft has provided a powerful means of extending the capabilities...
    on3 Aug 2013

  • Wiki Page: MTFC: Script pour mettre à jour les outils sysinternals

    Introduction MTFC: Microsoft Technical French Contributor est un Award conçu et réalisé par l'équipe des Wiki Ninjas dirigé par Ed Price. Cet Award à comme but de remercier toute personne qui à contribué dans les Forum TechNet France. Pour plus d'informations vous pouvez lire ceci: http...
    on2 Aug 2013

  • Wiki Page: MTFC: Guide Pas-à-Pas d'installation Propre de Windows 8 (fr-FR)

    Introduction MTFC: Microsoft Technical French Contributor est un Award conçu et réalisé par l'équipe des Wiki Ninjas dirigé par Ed Price. Cet Award à comme but de remercier toute personne qui à contribué dans les Forum TechNet France. Pour plus d'informations vous pouvez lire ceci: http...
    on26 Jul 2013

  • Wiki Page: MTFC: Mise en route & Gestion d'une infrastructure Microsoft VDI (fr-FR)

    Introduction MTFC: Microsoft Technical French Contributor est un Award conçu et réalisé par l'équipe des Wiki Ninjas dirigé par Ed Price. Cet Award à comme but de remercier toute personne qui à contribué dans les Forum TechNet France. Pour plus d'informations vous pouvez lire ceci: http...
    on26 Jul 2013

  • Wiki Page: MTFC: Erreur SDDL lors de l&#39;installation de SharePoint 2013 en mode autonome (fr-FR)

    Introduction MTFC: Microsoft Technical French Contributor est un Award conçu et réalisé par l'équipe des Wiki Ninjas dirigé par Ed Price. Cet Award à comme but de remercier toute personne qui à contribué dans les Forum TechNet France. Pour plus d'informations vous pouvez lire ceci: http...
    on26 Jul 2013

  • Wiki Page: TechNet Guru Contributions - June 2013

    Table of Contents Introduction How to Enter 1) Create a new TechNet article 2) Tell us about it Categories BizTalk SharePoint 2010 Small Basic SQL Server Analysis Services SQL Server Integration Services SQL Server Reporting Services/Power View Transact-SQL Visual Basic Visual C# Windows Phone Windows...
    on11 Jul 2013

  • Wiki Page: SQL Server Result Set In An HTML Email

    The Problem Picture the situation: you have a collection of data that you've been working on to summarise. You've finally found a way of displaying the data in an effective format, but you've overlooked one essential task: how are you going to relay this information back to the audience...
    on8 Jul 2013

  • Wiki Page: T-SQL: RIGHT, LEFT, SUBSTRING and CHARINDEX Functions

    Table of Contents ​RIGHT and LEFT CHARINDEX ​SUBSTRING ​USING THEM TOGETHER This article explains the functionality and uses of the LEFT, RIGHT, SUBSTRING and CHARINDEX functions in SQL. This article will leave you with sound knowledge and understanding that you can take away and questions...
    on8 Jul 2013

  • Wiki Page: EOMONTH() Function Usage in SQL Server 2012 and On

    The EOMONTH() function is new in SQL Server 2012. BOL link: http://technet.microsoft.com/en-us/library/hh213020.aspx In the previous version (SQL Server 2008), a popular albeit obscure way to get the end of the month: SELECT CONVERT ( DATE , dateadd(mm, datediff(mm,0, current_timestamp...
    on7 Jul 2013

  • Wiki Page: TechNet Guru Contributions - May 2013

    NOTES May 2013 is over. Find the most recent competitions here: TechNet Guru Contributions The results are in for May : TechNet Guru Awards - May 2013 Table of Contents Introduction How to Enter 1) Create a new TechNet article 2) Tell us about it Contributions for May in the Sections...
    on12 Jun 2013
Page 1 of 2 (26 items) 12
Can't find it? Write it!

Post an Article