April 18, 2011 at 2:41 pm
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 ?
April 18, 2011 at 3:32 pm
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?
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 18, 2011 at 3:51 pm
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
Author - SQL Server T-SQL Recipes
April 18, 2011 at 3:53 pm
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 5:40 pm
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 18, 2011 at 11:57 pm
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....
May 4, 2011 at 7:39 am
Ok , going to forget about the cursor one.
Custom components it is , see you in Seattle (hopefully :))
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply