SQL Server DBA Tips & Tricks


T-SQL Tuesday #007: Summertime in the SQL

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:


    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.


    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 Responses to T-SQL Tuesday #007: Summertime in the SQL

    1. Pingback: Tweets that mention T-SQL Tuesday #007: Summertime in the SQL - The SQL UPDATE Statement -- Topsy.com

    2. Pingback: T-SQL Tuesday #007: Summertime in the SQL – The SQL UPDATE Statement - sql

    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. Pingback: T-SQL Tuesday #007: My Favorite 2008 Feature | Bob Pusateri - The Outer Join

    6. Pingback: My Favorite New(ish) 2008 Feature (Resource Governor) « StefBauer's Blog – @StefBauer

    7. Pingback: SQL SERVER – Merge Operations – Insert, Update, Delete in Single Execution « Journey to SQL Authority with Pinal Dave

    8. Bill Fellows says:

      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. John says:

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

    10. Bill Fellows says:

      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. Pingback: SQL Server 2008/2008R2: My Favorite Feature « LittleKendra.com

    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 pingback spam that will probably happen… doesn’t:


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


    16. Pingback: Kids these days…(T-SQL Tuesday #007) « SQL Feather and Quill

    17. Pingback: Data Inspirations » SQL Server 2008 R2: These are a Few of My Favorite Things

    18. Pingback: Stacia Misner : SQL Server 2008 R2: These are a Few of My Favorite Things

    19. Pingback: Looking at the Future of Databases | Jeremiah Peschka

    20. Pingback: Data Compression | SQL RNNR

    21. Pingback: T-SQL Tuesday #009: Beach Time | SQL RNNR

    22. Pingback: T-SQL Tuesday #008: Gettin’ Schooled | SQLSoldier

    23. Pingback: T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2 | SQLSoldier

    24. Pingback: T-SQL Tuesday Topics « Voice of the DBA

    25. Pingback: TSQL Tuesday #026 – Second Chances | Dave's SQL Blog

    26. Pingback: TSQL2sday #026 – Second Chances « Nancy Hidy Wilson's Blog

    27. Pingback: T-SQL Tuesday #026 – The Wrap Up | Dave's SQL Blog

    28. Pingback: T-SQL Tuesday Topics – Febuary 2012 « Voice of the DBA

    29. Pingback: #Meme15 Meets #T-SQL Tuesday « Chris Shaw's Weblog

    30. Pingback: T-SQL Tuesday Topics – December 2012 Update « Voice of the DBA

    31. Pingback: Less Than Dot - Blog - Awesome