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!

Posted by at
Labels: ,

29 comments:

  1. Michael J. SwartNovember 1, 2011 at 5:52 AM

    Great topic! Can't wait!

    ReplyDelete
  2. Rob FarleyNovember 7, 2011 at 4:27 PM

    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
  3. Noel McKinneyNovember 7, 2011 at 5:54 PM

    Here's mine, thanks Brad!

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

    ReplyDelete
  4. Greg LucasNovember 7, 2011 at 6:56 PM

    Here's another

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

    Thanks Brad

    ReplyDelete
  5. Michael J. SwartNovember 7, 2011 at 7:15 PM

    This comment has been removed by the author.

    ReplyDelete
  6. Michael J. SwartNovember 7, 2011 at 7:16 PM

    Here you go Brad,
    http://michaeljswart.com/2011/11/t-sql-tuesday-024-procedures-by-the-numbers/
    Thanks for hosting! Great topic!

    ReplyDelete
  7. UnknownNovember 7, 2011 at 7:33 PM

    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
  8. SteveNovember 7, 2011 at 10:12 PM

    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
  9. Merrill AldrichNovember 7, 2011 at 11:11 PM

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

    ReplyDelete
  10. Aaron BertrandNovember 7, 2011 at 11:31 PM

    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
  11. Pinal DaveNovember 8, 2011 at 2:53 AM

    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
  12. _RichardABrownNovember 8, 2011 at 3:32 AM

    Thanks for hosting Brad!

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

    ReplyDelete
  13. Bob PusateriNovember 8, 2011 at 6:57 AM

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

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

    ReplyDelete
  14. Airborne GeekNovember 8, 2011 at 7:06 AM

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

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

    ReplyDelete
  15. Jes BorlandNovember 8, 2011 at 11:00 AM

    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
  16. AnonymousNovember 8, 2011 at 12:15 PM

    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
  17. AnonymousNovember 8, 2011 at 12:47 PM

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

    ReplyDelete
  18. JasonNovember 8, 2011 at 3:05 PM

    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
  19. Robert L DavisNovember 8, 2011 at 3:41 PM

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

    ReplyDelete
  20. AnonymousNovember 8, 2011 at 7:04 PM

    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
  21. David HowardNovember 8, 2011 at 10:33 PM

    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
  22. Brad SchulzNovember 9, 2011 at 2:02 PM

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

    --Brad

    ReplyDelete
  23. UnknownJuly 2, 2013 at 5:17 AM

    Nice post very helpful

    dbakings

    ReplyDelete
  24. WiptubeDecember 23, 2013 at 3:03 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  25. seko2April 30, 2014 at 5:55 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  26. UnknownJanuary 5, 2015 at 2:39 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  27. shivJanuary 4, 2017 at 3:24 AM

    Thanks for providing this informative information you may also refer.
    http://www.s4techno.com/blog/2016/07/27/introduction-to-sql/

    ReplyDelete
  28. latesttechnologyblogsJuly 20, 2018 at 4:51 AM

    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

Subscribe to: Post Comments (Atom)