Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Picking Your Packaging Expand / Collapse
Author
Message
Posted Monday, January 20, 2014 9:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 291, Visits: 518
The greatest factor in our decision process was the quantity of servers. For a smaller number, 10-50, single threaded options, such as SSIS, completed in a timely manner. We now have 4,500 servers, and even with each store completing in 1 second, it would be more than one hour to complete. This is acceptable for our internal system checks, but does not enable business users to answer questions in a timely manner.
Post #1532711
Posted Monday, January 20, 2014 9:39 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 1:53 PM
Points: 6,705, Visits: 1,684
Eric, that makes sense. What I did recently was write multi-threaded code and drop in a script task - worlds of difference. Using or abusing the tools? Depends!

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1532734
Posted Tuesday, January 21, 2014 8:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 1,282, Visits: 741
Being mainly a SQL person of course I tend to stick with T-SQL (or SSIS when needed), but also not too worried about using C# CLRs when needed. Having originated from programming in C and C++, this might scare me a lot less than some that have not maybe.

Also used PowerShell for a few things, but it seems clumsy to me still (which is mostly just a lack of experience indicator in my experience with other tools!).

But, if I use C# in CLRs, I tend to get one of our C# developers involved in it, since they are 100x better at it than I am. =)
Post #1533147
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse