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

2 Sessions im considering for PASS Expand / Collapse
Author
Message
Posted Monday, April 18, 2011 2:41 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 1,949, Visits: 8,311
SSIS Custom Components

Designing custom components for SSIS is a complex task.

Much of the available documentation is not very intuitive, and although technically correct, can be simply unfathomable.

There is a step learning curve , with many trips and false starts upon the way. Once understood though, the benefits in code reuse and overall performance can be well worth the effort.

Once you have understood the data flow functionality, then the hurdle of creating a UI will then have to be crossed.

Starting with a blank project , the end to end process will be demonstrated to allow you to get all the benefits.



"Just make it go faster”

That’s a standard command that gets filtered down through the management on an all too frequent basis.

How can that best be achieved? Sure you could throw hardware at the problem, but how do you know that that will solve the problem and at what financial cost. Alternatively you could partition tables, use created clustered views or any manor of tweaks.

But are you just papering over the cracks? Without addressing the underlying problems then you are not going to achieve real performance, scalability and create a system that performs in a predictable fashion.

By re-engineering some cursor ridden code, we'll see how that can be achieved


Opinions ?




Clear Sky SQL
My Blog
Kent user group
Post #1095306
Posted Monday, April 18, 2011 3:32 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:15 PM
Points: 6,237, Visits: 7,391
How honest you want 'em?

The Custom Controls I can't speak to how much interest there would be. I regularly work with SSIS and third party tools are usually heavily quality controlled so we don't touch them, and designing my own would be painful and overkill under most circumstances. I can't see ever having much of an interest in doing that unless I was a company specializing in third party tools. I could certainly see enough people that do care at PASS though.

Optimizations are always good, but you'd end up competing with the majority of folks who know optimization and are trying to do their own, with PASS being a great place to attract other well known names. Not sure, honestly, but how many people do you expect to attend PASS that don't know how to remove cursors for speed?



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1095331
Posted Monday, April 18, 2011 3:51 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, August 22, 2014 8:50 PM
Points: 6,594, Visits: 8,877
I'd be pretty intrigued to go see the SSIS custom components - it would depend on what is competing with you in that timeslot. Not so sure about the "Just make it go faster", unless it covers something new (and which doesn't appear to be mentioned).

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1095344
Posted Monday, April 18, 2011 3:53 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:19 AM
Points: 42,806, Visits: 35,927
Craig Farrell (4/18/2011)
Not sure, honestly, but how many people do you expect to attend PASS that don't know how to remove cursors for speed?


There will be some, the problem I see with that abstract is that it's vague. There will be a lot of us talking about performance tuning there, from various aspects, you need to be very specific about what exactly you're talking about. Cursor is mentioned once in the last line. I could (and did) read that as a general performance tuning, maybe focused on database design ("the underlying problems"). If it was then a session purely on cursors I would be a little miffed.

Also (and sorry for the harsh, it's not been a good day), clustered views is not a correct term. I assume you mean indexed views. Partitioning is not necessarily for performance, it's manageability, easy of load and drop of data.

It's that kind of detail that can get your abstract thrown out, if the program committee feels the abstract suggests you don't know the material they're likely to throw the abstract out.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1095346
Posted Monday, April 18, 2011 5:40 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 5:23 AM
Points: 15,660, Visits: 28,046
Just to pile and beat on your bruises a bit, you're spending too much time, especially in the second abstract defining the problem. You need to define the problem space within one - three sentences and then talk about what the attendees are going to get out of your session. I try to focus there. If I were attending, would I understand what it was I was getting ready to go over. If I didn't, you had better be a known speaker or I'm just going to skip your session. Time at the Summit is very tight, so picking and choosing sessions is really a matter of triage. If I'm unsure you're going to make it, we're sending you to the dying room.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1095370
Posted Monday, April 18, 2011 11:57 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 1,949, Visits: 8,311
Thanks people

Thats what this forum is for, im big enough to take it on the chin.

Starting again with the performance one, but yes i do agree that there will be a glut of performance presentations.

The custom component is a bit of a 'niche' subject, maybe a line or two about trying to bring them to the mainstream wouldnt go a miss....





Clear Sky SQL
My Blog
Kent user group
Post #1095422
Posted Wednesday, May 4, 2011 7:39 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 1,949, Visits: 8,311
Ok , going to forget about the cursor one.

Custom components it is , see you in Seattle (hopefully :))




Clear Sky SQL
My Blog
Kent user group
Post #1103118
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse