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

  • Wiki Page: How To Create A Sync Service

    In this walk-through you will create a simple Sync service. Pre-requisites You must have the following products installed on your computer to complete this walk-through. Visual Studio 2008 SP1 or Visual Studio 2010 with C# language components If you are using x86 Windows computer, install...
    on9 Sep 2013

  • Wiki Page: White Paper Gallery for SQL Server

    Download white papers for SQL Server in DOC, PDF, and other formats. All the content is free. This page aggregates Microsoft content from multiple sources – feel free to fill in the gaps and add links to other content. To view Microsoft e-book content that is available in EPUB and MOBI...
    on9 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

  • Wiki Page: Generate XML - Column Names with their Values as text() Enclosed within their Column Name Tag

    The most commonly used XML format is the following: (column names with their values as text() enclosed within their column name tag) Lets find out how to generate the following XML for table provided below: < Employees > < field Name = "ID" >1</ field >...
    on8 Sep 2013

  • 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: Avoid T (space) while generating XML using FOR XML clause

    The following code shows an example on how to avoid T (space) while generating XML using FOR XML clause Sample Data: DECLARE @Employee TABLE (ID INT , Name VARCHAR (100), DOJ DATETIME) INSERT @Employee SELECT 1, 'Sathya' , '2013-06-08 08:50...
    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: 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: Presentation Transcript: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas

    SQL11UPD01-TSCRIPT-05 This wiki is a transcript of a previously recorded video. Related content assets: Presentation: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas ( SQL11UPD01-DECK-03 ) Video: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas ( SQL11UPD01...
    on7 Sep 2013
Page 6 of 62 (1,550 items) «45678»