Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Abstract critique - T-SQL Code Sins


Abstract critique - T-SQL Code Sins

Author
Message
JenMidnightDBA
JenMidnightDBA
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 317
Here is the abstract I've started submitting for SQL Saturdays and whatnot this year. Thoughts on the abstract? Would this make you want to come see the session?


T-SQL Code Sins: The Worst Things We Do to Code and Why

It's impossible to follow every best practice all the time. Code sins are those things we do to our code that are either so horrendous that they can't be borne, or that have such tremendous consequences that your stored procedures wish they'd never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.



Thanks,
Jen
Roy Ernest
Roy Ernest
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2496 Visits: 6852
The abstract is pretty good. It states your intention quite well.
But in the abstract, you are stating that you are going to provide how to reverse the mistakes you have already made. Maybe something regarding that should be on the topic? Something like "How to clean up the mess you have made" ? Just a suggestion.

-Roy
Alan Vogan
Alan Vogan
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1093 Visits: 585
I think it's good. Wish I could attend!
Ninja's_RGR'us
Ninja's_RGR'us
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: 20941 Visits: 9671
What mistakes are you going to cover?
JenMidnightDBA
JenMidnightDBA
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 317
Alan Vogan (1/24/2011)
I think it's good. Wish I could attend!

Thanks! I have a recorded Code Sins session up on my blog (http://www.midnightdba.com/Jen/articles/) but the 2011 version is much revamped. I'll put up a new recording sometime in February, probably.
JenMidnightDBA
JenMidnightDBA
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 317
Roy Ernest (1/24/2011)
The abstract is pretty good. It states your intention quite well.
But in the abstract, you are stating that you are going to provide how to reverse the mistakes you have already made. Maybe something regarding that should be on the topic? Something like "How to clean up the mess you have made" ? Just a suggestion.

Thanks for the suggestion!

Ninja's_RGR'us
What mistakes are you going to cover?


I cover a lot of ground, from "meta" problems (like format and documentation) to project problems. But the meat of the session is actual code: architecture, poorly tuned querying, and a good deal more.
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17629 Visits: 32268
I'd be interested in attending. I do think it's slightly vague on what the attendee will be taking home. That's my one personal bugaboo. You've told me what it's about, but what will I get out of it? This one is almost there, but it doesn't quite get me all the way to the finish.

----------------------------------------------------
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
JenMidnightDBA
JenMidnightDBA
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 317
Grant Fritchey (1/24/2011)
I'd be interested in attending. I do think it's slightly vague on what the attendee will be taking home. That's my one personal bugaboo. You've told me what it's about, but what will I get out of it? This one is almost there, but it doesn't quite get me all the way to the finish.


Okay, excellent...will tack a "The attendee will" at the end. Thx!
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36280 Visits: 18752
It's pretty good. There are two things I'd say.

One, this part:

It's impossible to follow every best practice all the time. Code sins are those things we do to our code that are either so horrendous that they can't be borne, ...


they seem confusing. You are mention the bad things in the title, but then go to "best practices" and immediately drop it. I'd somehow link the idea that if we can't do the best, let's not do the worst.

The second thing is I'd like to see one or two concrete examples of what is bad. I don't think you want to surprise people with the items. Tell us a couple of the sins that you'll correct in this abstract so that the coder that does x or y, will come find out what they can do instead.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Philip Murad
Philip Murad
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 68
It was an AWESOME class!!!

I would leave the first sentence off.
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