T-SQL Tuesday #007: Summertime in the SQL

Posted on

Invitation for T-SQL Tuesday #007

New hotness

Welcome back to the blog party known as T-SQL Tuesday. I’m honored to be hosting this month and since its Summer I’ve decided to talk about hotness…feature hotness. In the last few months we’ve had the release of SQL Server 2008 R2 which brought along with it a slew of new features. So this T-SQL Tuesday I ask: What’s your favorite hot new feature in the R2 (I’ll be nice and include 2008 in general) release? Got some code that takes advantage of a new feature? Post it! Got an example of how PowerPivot let you slice and dice data you simply couldn’t before due to contraints? Show us! Make sure to apply your SPF 1433 and get to writing.

Cabana Rules

This whole party started when Adam Machanic (Blog | Twitter) decided to start this awesome blogger party where one topic is chosen by the monthly host, everyone submits their posts, and those posts are then rounded up. Catch is these posts must all go up within the same 24 hour period. Here’s a list of the parties held so far:

  • #001 Adam Machanic asked for your favorite Date/Time tricks
  • #002 Adam followed up by asking for your favorite Puzzling Situations
  • #003 Rob Farley made the commitment with his topic: Relationships
  • #004 Mike Walsh kicked asked for your input on IO
  • #005 Aaron Nelson asked us to report on “Reporting
  • #006 Michael Coles wanted to know All About BLOB
  • So write up your post and make sure to link back to this post for your entry to count.

    To participate your post must go live between 00:00:00 GMT on Tuesday the 8th of June and 00:00:00 GMT on Wednesday the 9th.

    Don’t Run on the Pool Deck

    Here are the posted rules for this shindig:

    ATTENTION: RULES HAVE CHANGED, SEE BELOW

    1. Your post must go live between 00:00:00 GMT on Tuesday the 8h of June and 00:00:00 GMT on Wednesday the 9th. If your post doesn’t go live in the time limits, it won’t be included in the round-up post.
    2. Your post must link back to this post (by trackback or comment).
    3. “T-SQL Tuesday #007” MUST be in the title of the post.
    4. The above rule has been CHANGED! The new rule is that the title of the participating post no longer has to reference T-SQL Tuesday (although it’s still recommended). The post still has to link back to the hosting blog, but the link needs to be anchored from the NEW LOGO (found above), which must appear at the top of the post.
    5. It is your responsibility to verify the trackback or comment appears here on this post. If you don’t see your trackback add your own comment with a link back to your T-SQL Tuesday post and it will be included in the roundup.
    6. Don’t feed Gremlins after midnight
    Lifeguard on Twitter Duty

    A lot of the T-SQL Tuesday bloggers and bloggees are on Twitter. Follow the hashtag #TSQL2sDay and when your post goes live, tweet a link to it with that tag.

    Hosting

    You too can host this event! Just have participated in at least two previous #TSQL2sDay and let Adam Machanic know you wish to host. That’s it!

    43 thoughts on “T-SQL Tuesday #007: Summertime in the SQL

    1. […] This post was mentioned on Twitter by Jorge Segarra, Laerte Junior. Laerte Junior said: RT @SQLChicken: [NEW BLOG POST]: T-SQL Tuesday #007: Summertime in the SQL http://bit.ly/9vBnvJ #TSQL2sDay […]

    2. […] artykuł na: T-SQL Tuesday #007: Summertime in the SQL – The SQL UPDATE Statement Tags: month, month-and, party-known, since-its, sql, summer, tuesday, welcome Comments RSS […]

    3. I don’t know if I can avoid that gremlins rule. I hope my entry will still be accepted. (looking forward to it)

    4. There you go making me play with powerpivot. You don’t need to twist my arm. :)

    5. […] by Bob Pusateri in SQL Server , TSQL Tuesday with zero comments This post is my contribution to T-SQL Tuesday #007, hosted this month by the SQLChicken himself, Jorge Segarra (Blog | […]

    6. […] up the resource governor, which I am counting as my favorite new(ish) feature, so I am taking this TSQL2sday post opportunity do my promised followup for monitoring of the resource […]

    7. […] 8, 2010 by pinaldave This blog post is written in response to T-SQL Tuesday hosted by Jorge Segarra (aka […]

    8. Since I have no idea whether I’ve done things correctly, I’ll just drop my link here. http://billfellows.blogspot.com/2010/06/t-sql-tuesday-007-summertime-in-sql.html

    9. BLOG: Better Bi with Reporting Services 2008 R2 for #TSQL2Sday http://speeddba.com/archive/2010/06/better-bi-with-reporting-services-2008-r2/

    10. Oh yeah, I suppose I should say that I blogged on Table Valued Parameters with my submission http://billfellows.blogspot.com/2010/06/t-sql-tuesday-007-summertime-in-sql.html

    11. […] post is part of T-SQL Tuesday, 007 Edition. For this T-SQL Tuesday, we are tasked with picking our favorite New Hotness feature for SQL Server […]

    12. Here is mine… http://littlekendra.com/2010/06/08/sql2008fav/

      It was a difficult choice, but I picked the Data Collector.

    13. Favorite New Feature: SQL Azure Integration In SQL Server 2008 R2. The SQL Azure Team’s First T-SQL Tuesday Post.

    14. Just in case the tweet and the link-back don’t work.

      http://jasonbrimhall.info/2010/06/08/data-compression/

    15. […] Jorge Segarra, (blog/twitter) is hosting this months T-SQL Tuesday.  It’s called “T-SQL Tuesday #007: Summertime in the SQL”.   The question is “What’s your favorite hot new feature in the R2 (I’ll be nice […]

    16. […] month’s T-SQL Tuesday is hosted by Jorge Segarra (blog | twitter) who decided that we should write about our favorite new […]

    17. […] month's T-SQL Tuesday is hosted by Jorge Segarra (blog | twitter) who decided that we should write about our favorite new […]

    18. […] As in, I didn’t participate in the most recent T-SQL Tuesday about my favorite feature in SQL 2008 R2. […]

    19. […] than include the TSQL Tuesday in our blog title.  BTW, this month we are discussing features in SQL 2008 (supposed to be R2, but I am only discussing something that came out with […]

    20. […] #007 Jorge Segarra invited us to his party to celebrate Summertime in the SQL […]

    21. […] #001 Adam Machanic asked for your favorite Date/Time tricks #002 Adam followed up by asking for your favorite Puzzling Situations #003 Rob Farley made the commitment with his topic: Relationships #004 Mike Walsh kicked asked for your input on IO #005 Aaron Nelson asked us to report on “Reporting“ #006 Michael Coles wanted to know All About BLOB #007 Jorge Segarra invited us to his party to celebrate Summertime in the SQL […]

    22. […] this month by Jorge “@SQLChicken” Segarra (Blog|Twitter). You are invited to visit his blog to join the party and read more blogs participating in this month’s theme: Summertime in the SQL. […]

    23. […] T-SQL Tuesday #007: Summertime in the SQL […]

    24. […] Jorge Segarra – Summertime in the SQL […]

    25. […] foray into this event wasn’t until the 14th occurrence, I really like this idea and selected “TSQL2sday #007 Summertime in the SQL” as my second chance topic. Okay, so it is January, but it was 70+ degrees in Houston today, so […]

    26. […] 6. Nancy Hidy Wilson (blog | @NancyHidyWilson) extols the virtues of her favorite “new” features in SQL 2008 R2: CMS (Central Management Server) and PBM (Policy Based Management). Original T-SQL Tuesday 7 […]

    27. […] T-SQL Tuesday #007: Summertime in the SQL […]

    28. […] T-SQL Tuesday #007: Summertime in the SQL […]

    29. […] into the T-SQL Tuesday fun this week. The very well known, Jorge Segarra (blog | twitter) is hosting the fun this time around. It is a busy week at that with SQL University writing and everything going on in […]

    Comments are closed.