Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL Server
Tagged Content List

  • 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: 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: Hyperion (Star Analytics)

    Star Integration Server (SIS) authored by Star Analytics , generates star schemas directly from the proprietary storage of Essbase, Hyperion Financial Management and Hyperion Planning. All data, metadata, supporting details and security (filters and users) from the 3 apps are re-instantiated in ...
    on10 Sep 2013

  • Wiki Page: ETI High Performance Data Integration

    ETI products provide high performance data integration capabilities for data synchronization, migration and composite data services for SOA initiatives. As a complement to ETL, EAI, SOA and data warehousing technologies, ETI’s data integration platform extends the value of IT investments by providing...
    on10 Sep 2013

  • Wiki Page: SSIS: 64-bit Story

    With the introduction of 64-bit processors, there seem to evolve two main flavors of this new processor architecture: x86-64 and IA64. First, let's take a look at different flavors of 64-bit, namely x86-64 and IA-64. And then, I'll explain what the WOW64 feature is, and how Windows applications...
    on10 Sep 2013

  • Wiki Page: SSIS Connectivity White Paper

    Data Source Compatibility of SSIS Components In this section, we'll cover SSIS components and supported connectivity options in each component. It's worth mentioning the Connection Managers in SSIS , the components handling all different types of connection types including ADO.NET, OleDB...
    on10 Sep 2013

  • Wiki Page: SSIS Connection Managers

    In SSIS, almost all of the built-in components are configured by using Connection Managers. There are a plethora of connection managers built-in, and you can also write your own to plug in to the architecture. Only a subset of them applies to databases and traditional data access. The database-specific...
    on10 Sep 2013

  • Wiki Page: Aspects of Backup for BizTalk Databases

    Table of Contents Introduction Why and how to make Log Shipping Backups How to add/remove custom databases to the backup Clean up backup artifacts See Also Introduction When it comes to making backups of BizTalk, there is only one way that is supported by Microsoft; you need to make Log Shipping...
    on10 Sep 2013

  • Wiki Page: FCS Supported SQL Server Versions

    The information below originates here . It is presented here in a slightly different format for ease of editing. Version Notes SQL Server 2005 Standard or Enterprise, SP3 or later Server roles (32 bit ONLY)
    on10 Sep 2013

  • Wiki Page: Configuring RunAs Accounts for the SQL Server 2008 R2 Management Pack for System Center Operations Manager

    Kevin Holman has some great practical advice on how to configure RunAs account for the SQL Server management pack for System Center Operations Manager 2007 SP1 and R2 especially when low-privilege isn't an issue for your enterprise. Check out his blog article at http://blogs.technet.com/b/kevinholman...
    on10 Sep 2013

  • Wiki Page: BizTalk Health Check

    Table of Contents Health checking Patching: Update COM+ and MSDTC. General Network DTCPing of all the servers Transfer 100MB data Pathping TCP/IP port Exhaustion DBNETLIB Exceptions TCP/IP Server general Time synchronization BIOS Version Update the Certificate RevocationListUpdates BizTalk in general...
    on10 Sep 2013

  • Wiki Page: How to Configure SQL Server Log Shipping for OpsMgr 2007 and OpsMgr 2012

    Table of Contents Introduction SQL Log Shipping Overview and Recommendations Operations Manager Prerequisites Selecting an Account for the SQL Server Agent Service Firewall Access for SQL Server Create the Backup Folder Set the Full Recovery Model for the OperationsManager Database Enable Log Shipping...
    on9 Sep 2013

  • 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
Page 3 of 31 (766 items) 12345»
Can't find it? Write it!

Post an Article