SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Top 10 SQL Server Integration Services Best Practices


Top 10 SQL Server Integration Services Best Practices

Author
Message
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63413 Visits: 18570
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

Daniel Bowlin
Daniel Bowlin
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7564 Visits: 2629
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.
Sioban Krzywicki
Sioban Krzywicki
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4190 Visits: 8096
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
Dave Poole
Dave Poole
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16066 Visits: 3403
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.

LinkedIn Profile
www.simple-talk.com
Matt Whitfield
Matt Whitfield
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2131 Visits: 719
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
Why I wrote a sql query analyzer clone
Alvin Ramard
Alvin Ramard
SSCrazy Eights
SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)

Group: General Forum Members
Points: 8686 Visits: 11682
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

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
Matt Whitfield
Matt Whitfield
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2131 Visits: 719
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
Why I wrote a sql query analyzer clone
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search