Top 10 SQL Server Integration Services Best Practices

  • I am thoroughly shocked someone would even think about plagerising at that level. It's almost comical. I've never seen such blatant plagerism, and in a submission to a professional publication at that! (or however SQLServerCentral.com is classified)

    Just wow!

    Only thing I can say is thanks for bringing this article to light. First time I've read it. Great job to the actual authors!

    -------------------------------------------------------------------------------------------------
    My SQL Server Blog

  • r5d4 (9/13/2010)


    The article has served to remind me to re-read the original.

    I do hope Omeswar is not going to get paid for his Copy and Paste technique.

    I strongly suspect he will not.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Trevor R Udden (9/13/2010)


    Odanwada -

    Did I miss a major citiation at the end of your article? You might want to try not blantly plagirizing others work. The article you claim as yours was originally written by Thomas Kejser and Denny Lee, members of the SQL Customer Advisory Team, and published in 2008.

    Here is a link to the original article, and a wiki link to plagiarism, in case you are un familiar with its meaning.

    http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx

    http://en.wikipedia.org/wiki/Plagiarism

    Nice spot there. I was getting excited to read this article to find a message about it being plagiarized. Good thing it is on the SQL CAT site.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • amenjonathan (9/13/2010)


    I am thoroughly shocked someone would even think about plagerising at that level. It's almost comical. I've never seen such blatant plagerism, and in a submission to a professional publication at that! (or however SQLServerCentral.com is classified)

    Just wow!

    Only thing I can say is thanks for bringing this article to light. First time I've read it. Great job to the actual authors!

    It's surprising how much plagiarism actually takes place. A discussion here on SSC a while back that started with something along the line of "this person just plagiarised one of my blog postings." ended up with the discovery that many, if not all, of this MS MVP's blog postings were word for word copies of somebody else's blogs.

    I wonder if his MVP status has been revoke yet.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • amenjonathan (9/13/2010)


    I am thoroughly shocked someone would even think about plagerising at that level. It's almost comical. I've never seen such blatant plagerism, and in a submission to a professional publication at that! (or however SQLServerCentral.com is classified)

    Just wow!

    Only thing I can say is thanks for bringing this article to light. First time I've read it. Great job to the actual authors!

    Surprising as it may be - it happens frequently. Some have gone to the scale of plagiarizing books with only the cover picture changed.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Alvin Ramard (9/13/2010)


    amenjonathan (9/13/2010)


    I am thoroughly shocked someone would even think about plagerising at that level. It's almost comical. I've never seen such blatant plagerism, and in a submission to a professional publication at that! (or however SQLServerCentral.com is classified)

    Just wow!

    Only thing I can say is thanks for bringing this article to light. First time I've read it. Great job to the actual authors!

    It's surprising how much plagiarism actually takes place. A discussion here on SSC a while back that started with something along the line of "this person just plagiarised one of my blog postings." ended up with the discovery that many, if not all, of this MS MVP's blog postings were word for word copies of somebody else's blogs.

    I wonder if his MVP status has been revoke yet.

    That is just one example of many discussions we have had on the topic.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Aside from the copy & paste, the article is excellent. Although I think I wouldn't call it a best practices article as much as calling it something Optimizing your SSIS Packages.

  • It is a shame that this is plagiarized work as there's a comment I'd like to make about the article and I don't see a way to comment on the original.

    •If Integration Services and SQL Server run on the same server, use the SQL Server destination instead of the OLE DB destination to improve performance.

    This is not the case on Windows Server 2008. SQL Server destination doesn't work on that OS.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • I was fortunate enough to hear Thomas Kesjner at SQL Bits in London earlier this year.

    He started his presentation with "I'm not normally a transactional specialist but....." and proceeded to demonstrate that in performance terms it would be like a runner saying "sprinting isn't my thing" just before running a 6 second 100m.

  • Alvin Ramard (9/13/2010)


    It's surprising how much plagiarism actually takes place. A discussion here on SSC a while back that started with something along the line of "this person just plagiarised one of my blog postings." ended up with the discovery that many, if not all, of this MS MVP's blog postings were word for word copies of somebody else's blogs.

    I wonder if his MVP status has been revoke yet.

    Alvin

    I don't suppose you remember who that was do you?

    M

    Atlantis Interactive - SQL Server Tools
    My blog[/url]
    Why I wrote a sql query analyzer clone

  • Matt Whitfield (9/13/2010)


    Alvin Ramard (9/13/2010)


    It's surprising how much plagiarism actually takes place. A discussion here on SSC a while back that started with something along the line of "this person just plagiarised one of my blog postings." ended up with the discovery that many, if not all, of this MS MVP's blog postings were word for word copies of somebody else's blogs.

    I wonder if his MVP status has been revoke yet.

    Alvin

    I don't suppose you remember who that was do you?

    M

    No, I do not remember. I seem to remember that an MVP involved in the discussion did report him to those administering the MS MVP process.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Alvin Ramard (9/13/2010)


    No, I do not remember. I seem to remember that an MVP involved in the discussion did report him to those administering the MS MVP process.

    And rightly so. Thanks for getting back to me - I have just seen a few guys who, to me, have never seemed to deserve the MVP status because they write a lot, but not a lot of accurate, if you see what I mean. Just wondered if they were one and the same...

    Atlantis Interactive - SQL Server Tools
    My blog[/url]
    Why I wrote a sql query analyzer clone

Viewing 12 posts - 16 through 26 (of 26 total)

You must be logged in to reply to this topic. Login to reply