Monday, October 31, 2011

Invitation for T-SQL Tuesday #024: Prox ‘n’ Funx

T-SQL TuesdayBoy, time really flies, doesn’t it? It’s hard to believe, but we are finishing up our second year of T-SQL Tuesdays! Adam Machanic started the whole concept back in November 2009 with T-SQL Tuesday #001, and here we are already up to #024.

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!

25 comments:

  1. Here's mine:
    http://sqlblog.com/blogs/rob_farley/archive/2011/11/08/when-is-a-sql-function-not-a-function.aspx

    Thanks for hosting, Brad.

    ReplyDelete
  2. Here's mine, thanks Brad!

    http://noelmckinney.com/2011/11/t-sql-tuesday-024-stored-procedures/

    ReplyDelete
  3. Here's another

    http://datacentricity.net/2011/11/t-sql-tuesday-024-exception-handling-made-simple/

    Thanks Brad

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Thanks Brad.

    Converted 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

    ReplyDelete
  6. 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:
    http://dba-in-exile.blogspot.com/2011/11/t-sql-tuesday-024-prox-n-funx.html

    ReplyDelete
  7. One more! http://sqlblog.com/blogs/merrill_aldrich/archive/2011/11/07/t-sql-tuesday-24-ode-to-composable-code.aspx

    ReplyDelete
  8. Here'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

    ReplyDelete
  9. Wow 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

    ReplyDelete
  10. Thanks for hosting Brad!

    http://richbrownesq-sqlserver.blogspot.com/2011/11/ssrs-use-stored-procedures-in-datasets.html

    ReplyDelete
  11. Hi Brad, here's my contribution. Thanks for hosting!

    http://www.bobpusateri.com/archive/2011/11/t-sql-tuesday-24-functions-v-procedures/

    ReplyDelete
  12. Here's my entry. Thanks for hosting this month!

    http://www.airbornegeek.com/2011/11/t-sql-tuesday-24-prox-n-funx/

    ReplyDelete
  13. Hi Brad! Here's another one: T-SQL Tuesday #024: Reporting Services, Stored Procedures, and Multiple Result Sets -
    http://blogs.lessthandot.com/index.php/DataMgmt/ssrs/t-sql-tuesday-024-reporting

    ReplyDelete
  14. 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/

    ReplyDelete
  15. Ah, heck with it. Have another. http://thelonedba.wordpress.com/2011/11/08/t-sql-tuesday-024-prox-funx-maintenance-release-tip/

    ReplyDelete
  16. My pingback looks to not have posted at this moment. Here it is just in case:
    http://jasonbrimhall.info/2011/11/08/t-sql-tuesday-024-prox-%E2%80%98n%E2%80%99-funx/

    ReplyDelete
  17. T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs: http://www.sqlsoldier.com/wp/sqlserver/usingsystemrestrictschemafunctioninmdxtoquerydmvs

    ReplyDelete
  18. Brad,
    Didn'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

    ReplyDelete
  19. 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/

    ReplyDelete
  20. Thank you everyone for all the submissions. I'll put together a roundup in the next few days.

    --Brad

    ReplyDelete