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...
  • 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...
  • 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 ...
  • 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 ...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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)
  • 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...
  • 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...
  • 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...
Page 5 of 62 (1,550 items) «34567»