
So, without further ado…
You are hereby invited to this month’s T-SQL Tuesday #024, which will take place on November 8, 2011.
So, all you T-SQL Bloggers out there, please join the blog party and write up something revolving around this month’s topic: Prox ‘n’ Funx (which is just a coo-ul way of referring to Procedures and Functions).
This topic covers a lot of ground, so there’s a myriad of possibilities in what you can write about. You could discuss a really cool stored procedure or function that you wrote. You could write about a Dynamic Management Function that you can’t live without… or perhaps write about some of the new functions that are coming in SQL2012. How about limitations or “gotchas” or performance issues in working with procedures and functions? And on and on and on…
Now for those nasty rules:
1) Your post must go live between 00:00:00 GMT on Tuesday November 8 and 00:00:00 GMT on Wednesday November 9. If you’re unsure exactly when that is, well, guess what? There’s a function for that! It’s called GETUTCDATE().
2) Your post must link back to this post, and the link must be anchored from the logo (found above) which must also appear at the top of your post.
3) Make sure you leave a comment or a trackback here on this blog regarding your post (so that I can collect the posts and write a round-up).
Optionally:
4) “T-SQL Tuesday #024” should be included in the title of the post.
5) Tweet about your post using the hash tag #TSQL2sDay.
(I have to admit… that last rule is kind of amusing since I don’t have a Twitter account myself… A big thank-you to Rob Farley for initially tweeting this invitation).
I’m looking forward to reading your submissions. But don’t delay in composing your post! T-SQL Tuesday 24 is coming fast! I can almost hear the clock ticking down… Ka-chink! Ka-chunk! Ka-chink! Ka-chunk!

Great topic! Can't wait!
ReplyDeleteReally good tips! Thanks so much.
DeleteHere's mine:
ReplyDeletehttp://sqlblog.com/blogs/rob_farley/archive/2011/11/08/when-is-a-sql-function-not-a-function.aspx
Thanks for hosting, Brad.
Here's mine, thanks Brad!
ReplyDeletehttp://noelmckinney.com/2011/11/t-sql-tuesday-024-stored-procedures/
Here's another
ReplyDeletehttp://datacentricity.net/2011/11/t-sql-tuesday-024-exception-handling-made-simple/
Thanks Brad
This comment has been removed by the author.
ReplyDeleteHere you go Brad,
ReplyDeletehttp://michaeljswart.com/2011/11/t-sql-tuesday-024-procedures-by-the-numbers/
Thanks for hosting! Great topic!
Thanks Brad.
ReplyDeleteConverted a TSQL function to CLR and it coincided with this months topic so....
http://blog.sqlconcepts.co.nz/2011/11/t-sql-tuesday-024-calculating-easter.html
Here's my entry. First time participating, thought I'd compare the differences between Oracle and SQL Server since I have to cross to both sides all day every day:
ReplyDeletehttp://dba-in-exile.blogspot.com/2011/11/t-sql-tuesday-024-prox-n-funx.html
One more! http://sqlblog.com/blogs/merrill_aldrich/archive/2011/11/07/t-sql-tuesday-24-ode-to-composable-code.aspx
ReplyDeleteHere's my entry: http://sqlblog.com/blogs/aaron_bertrand/archive/2011/11/08/t-sql-tuesday-24-dude-where-s-the-rest-of-my-procedure.aspx
ReplyDeleteWow excellent entries so far. I decided "not" to be innovative and start new series of SQL Server 2012 Analytic Functions - http://wp.me/p2NUQ-44r
ReplyDeleteThanks for hosting Brad!
ReplyDeletehttp://richbrownesq-sqlserver.blogspot.com/2011/11/ssrs-use-stored-procedures-in-datasets.html
Hi Brad, here's my contribution. Thanks for hosting!
ReplyDeletehttp://www.bobpusateri.com/archive/2011/11/t-sql-tuesday-24-functions-v-procedures/
Here's my entry. Thanks for hosting this month!
ReplyDeletehttp://www.airbornegeek.com/2011/11/t-sql-tuesday-24-prox-n-funx/
Hi Brad! Here's another one: T-SQL Tuesday #024: Reporting Services, Stored Procedures, and Multiple Result Sets -
ReplyDeletehttp://blogs.lessthandot.com/index.php/DataMgmt/ssrs/t-sql-tuesday-024-reporting
Hi Brad. Here's one for you. Not my best work, I know... http://thelonedba.wordpress.com/2011/11/08/t-sql-tuesday-024-prox-n-funx-procedures-functions/
ReplyDeleteAh, heck with it. Have another. http://thelonedba.wordpress.com/2011/11/08/t-sql-tuesday-024-prox-funx-maintenance-release-tip/
ReplyDeleteMy pingback looks to not have posted at this moment. Here it is just in case:
ReplyDeletehttp://jasonbrimhall.info/2011/11/08/t-sql-tuesday-024-prox-%E2%80%98n%E2%80%99-funx/
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs: http://www.sqlsoldier.com/wp/sqlserver/usingsystemrestrictschemafunctioninmdxtoquerydmvs
ReplyDeleteBrad,
ReplyDeleteDidn't see my pingback, so here it is:
http://nancyhidywilson.wordpress.com/2011/11/08/tsql2sday-024-prox-n-funx/
Thanks for hosting!
Nancy Hidy Wilson
Better late than never! Thanks for hosting, Brad. http://davidbrycehoward.com/archive/2011/11/fixing-the-query-plan-for-a-stored-procedure-t-sql-tuesday-24/
ReplyDeleteThank you everyone for all the submissions. I'll put together a roundup in the next few days.
ReplyDelete--Brad
Nice post very helpful
ReplyDeletedbakings
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThanks for providing this informative information you may also refer.
ReplyDeletehttp://www.s4techno.com/blog/2016/07/27/introduction-to-sql/
I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision even you have explained the concept as deep clean without having any uncertainty, keep blogging. SQL server dba Online Training
ReplyDelete