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!

59 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. Thanks for providing this informative information you may also refer.
    http://www.s4techno.com/blog/2016/07/27/introduction-to-sql/

    ReplyDelete
  25. 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
  26. 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
  27. What a great content we have here buy blue dream online as we browse we also see this blog too and is pretty good buy purple haze online we also realize that blog are good for business we also bring buy og kush online best blog to visit
    buy khalifa kush online thanks for checking on this post

    ReplyDelete
  28. 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
  29. 카지노사이트 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
  30. 토토사이트 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
  31. 스포츠토토 That’s what I love about your content. You have pour out your heart on it.

    ReplyDelete
  32. Hello there, You have done a fantastic job. I’ll certainly digg it and individually recommend to my friends. I am sure they will be benefited from this website. Feel free to visit my website; 안전놀이터

    ReplyDelete
  33. 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
  34. 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
  35. I’m not that much of a online reader to be honest but your blogs really nice, keep it up! I’ll go ahead and bookmark your website to come back later. Many thanks Feel free to visit my website; 토토

    ReplyDelete
  36. 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
  37. Most valuable and fantastic blog I really appreciate your work which you have done about the electricians,many thanks and keep it up. Very useful info. Hope to see more posts soon! I really like to read this post, it shares lots of information to readers.a

    Graphic Design company in USA

    Label Design

    Box Packaging Design

    Packaging Host

    Die Cut Stickers

    Static Cling

    Smart City Lahore

    Nova City Islamabad

    Park View City Islamabad

    ReplyDelete
  38. 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
  39. 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
  40. 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
  41. It is in point of fact a nice and helpful piece of info. I’m happy that you shared this helpful info with us. Please stay us up to date like this. Thank you for sharing. 사설토토

    ReplyDelete
  42. Great job for publishing such a beneficial web site
    스포츠토토

    ReplyDelete
  43. I always think about what is. It seems to be a perfect article that seems to blow away such worries. 안전놀이터 seems to be the best way to show something. When you have time, please write an article about what means!!

    ReplyDelete
  44. 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