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!

45 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
  21. This comment has been removed by a blog administrator.

    ReplyDelete
  22. This comment has been removed by a blog administrator.

    ReplyDelete
  23. This comment has been removed by a blog administrator.

    ReplyDelete
  24. 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
  25. If you're trying hard to lose weight then you absolutely need to start using this brand new custom keto meal plan.

    To create this keto diet service, certified nutritionists, personal trainers, and professional cooks have united to produce keto meal plans that are productive, convenient, price-efficient, and satisfying.

    Since their first launch in early 2019, 1000's of clients have already completely transformed their body and health with the benefits a great keto meal plan can provide.

    Speaking of benefits: clicking this link, you'll discover 8 scientifically-certified ones provided by the keto meal plan.

    ReplyDelete
  26. Thank you for the good writeup. It in fact was
    a amusement account it. Look advanced to more added agreeable from
    you! By the way, how could we communicate? 바카라사이트


    ReplyDelete
  27. 카지노사이트 Welcome to the party of my life here you will learn everything about me.
    it’s really cool blog. Linking is very useful thing.you have really helped

    ReplyDelete
  28. 토토사이트 I personally appreciate your work. I’m quite new in this field. And I want to say thanks for the great info.. Please add more post.

    ReplyDelete
  29. What’s up everybody, here every person is sharing such familiarity, therefore it’s good to read this webpage, and I used to pay a visit this web site every day. Feel free to visit my website; 온라인카지노

    ReplyDelete
  30. This is one very interesting post. I like the way you write and I will bookmark your blog to my favorites. Feel free to visit my website; 카지노

    ReplyDelete
  31. Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. Feel free to visit my website; 온라인카지노

    ReplyDelete
  32. I wouldn’t mind composing a post or elaborating on a number of the subjects you write in relation to here. Again, awesome web log! 토토

    ReplyDelete
  33. excellent post, very informative. I wonder why the other experts of this sector don’t notice this. You should continue your writing. I am confident, you have a huge readers’ base already!
    온라인경마
    경마사이트

    ReplyDelete
  34. Wonderful post however , I was wanting to know if you could write a litte more on this subject? I’d be very grateful if you could elaborate a little bit further. Bless you! 바카라

    ReplyDelete
  35. Hello, my name is Jennette. I want to know how much it will cost to post a sponsored post on your site.Please send me the details, price, word count, any other information will be highly appreciated. Also, I would like to know if can be possible to get a discount for a sponsored post? Wait for your answer.
    Best regards Jennette
    jennettecasarz@gmail.com

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

    ReplyDelete
  37. Great things you’ve always shared with us. Just keep writing this kind of posts.
    먹튀사이트

    ReplyDelete
  38. I appreciate you sharing this useful information. What a fantastic website you have. The level of detail on your website is impressive. It demonstrates how well you comprehend this subject. I bookmarked this page of the website and will return to read more stuff. I recently came across a profile about how to react fast in games ? Go to reaction time tester and leave your comments if you want to read the entire tale.

    ReplyDelete
  39. Elevate your business with our managed ibm cloud solutions. Let our experts handle your infrastructure while you focus on growth.

    ReplyDelete