Posted on by admin

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:

    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!

    48 Replies 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
    5. Pingback: T-SQL Tuesday #007: My Favorite 2008 Feature | Bob Pusateri - The Outer Join
    7. Pingback: My Favorite New(ish) 2008 Feature (Resource Governor) « StefBauer's Blog – @StefBauer
    8. Pingback: SQL SERVER – Merge Operations – Insert, Update, Delete in Single Execution « Journey to SQL Authority with Pinal Dave
    19. Pingback: SQL Server 2008/2008R2: My Favorite Feature « LittleKendra.com
    25. Pingback: Kids these days…(T-SQL Tuesday #007) « SQL Feather and Quill
    28. Pingback: Data Inspirations » SQL Server 2008 R2: These are a Few of My Favorite Things
    30. Pingback: Stacia Misner : SQL Server 2008 R2: These are a Few of My Favorite Things
    31. Pingback: Looking at the Future of Databases | Jeremiah Peschka
    32. Pingback: Data Compression | SQL RNNR
    33. Pingback: T-SQL Tuesday #009: Beach Time | SQL RNNR
    34. Pingback: T-SQL Tuesday #008: Gettin’ Schooled | SQLSoldier
    35. Pingback: T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2 | SQLSoldier
    36. Pingback: T-SQL Tuesday Topics « Voice of the DBA
    37. Pingback: TSQL Tuesday #026 – Second Chances | Dave's SQL Blog
    38. Pingback: TSQL2sday #026 – Second Chances « Nancy Hidy Wilson's Blog
    39. Pingback: T-SQL Tuesday #026 – The Wrap Up | Dave's SQL Blog
    40. Pingback: T-SQL Tuesday Topics – Febuary 2012 « Voice of the DBA
    41. Pingback: #Meme15 Meets #T-SQL Tuesday « Chris Shaw's Weblog
    42. Pingback: T-SQL Tuesday Topics – December 2012 Update « Voice of the DBA
    43. Pingback: Less Than Dot - Blog - Awesome
    44. Pingback: 2010 T-SQL Tuesdays – T-SQL Tuesday
    45. Pingback: T-SQL Tuesday #007 – Summertime in the SQL – T-SQL Tuesday
    46. Pingback: A Year of Tuesdays: T-SQL Tuesday Meta-Roundup - Data Education
    47. Pingback: T-SQL Tuesday #007 and T-SQL Tuesday Has a Logo - Data Education
    48. Pingback: T-SQL Tuesday Participation Over the Years | SQL RNNR

    Comments are closed.