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


2 Sessions im considering for PASS


2 Sessions im considering for PASS

Author
Message
Dave Ballantyne
Dave Ballantyne
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6910 Visits: 8370
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
Evil Kraig F
Evil Kraig F
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19889 Visits: 7660
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
WayneS
WayneS
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20928 Visits: 10652
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
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

GilaMonster
GilaMonster
SSC Guru
SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)

Group: General Forum Members
Points: 216865 Visits: 46278
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

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


Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)

Group: General Forum Members
Points: 95627 Visits: 33013
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Dave Ballantyne
Dave Ballantyne
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6910 Visits: 8370
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
Dave Ballantyne
Dave Ballantyne
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6910 Visits: 8370
Ok , going to forget about the cursor one.

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



Clear Sky SQL
My Blog
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