sql

  • Let me Introduce Nodinite: An Integration Monitoring and Logging Tool Plus More

    Let me Introduce Nodinite: An Integration Monitoring and Logging Tool Plus More

    Nodinite is a tool that I have used for several years now to monitor and log data within my integration process flow. Nodinite also provides a central repository for your integrations. What I love about Nodinite is the total flexibility of what is installed and how it is installed. I believe it is also very…

    Know More

  • Remove Duplicate Rows from a SQL Table

    A small reminder for myself: delete t from ( SELECT * , DupRank = ROW_NUMBER() OVER (               PARTITION BY PurchaseOrderNumber, LineNumber               ORDER BY (SELECT NULL)             ) FROM [PurchaseOrderLines] ) as t where DupRank > 1

    Know More

  • Connection String

    Open Notepad Save the blank file as myConnection.udl Close notepad Double-click the udl file you just saved Fill it in and test it until successful Once succesful, close the udl Right-Click the udl and Open With Notepad There’s your connection string. Note: SQL client doesn’t require the Providor element so you can remove that from…

    Know More