Invitation for T-SQL Tuesday #007

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:
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
- 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.
- Your post must link back to this post (by trackback or comment).
“T-SQL Tuesday #007” MUST be in the title of the post.- 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.
- 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.
- 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!
I don’t know if I can avoid that gremlins rule. I hope my entry will still be accepted. (looking forward to it)
There you go making me play with powerpivot. You don’t need to twist my arm. 🙂
In case my trackback doesn’t appear…
http://sqlblog.com/blogs/rob_farley/archive/2010/06/08/my-favourite-feature-of-sql-2008-r2.aspx
Here is the link to blog if trackback has any issue
http://blog.sqlauthority.com/2010/06/08/sql-server-merge-operations-insert-update-delete-in-single-execution/
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
Estimating data compression
http://www.englishtosql.com/english-to-sql-blog/2010/6/7/estimating-data-compression.html
Self Service Reporting with PowerPivot, is it a good thing?
http://sqlblogcasts.com/blogs/blakmk/archive/2010/06/08/self-service-reporting-with-powerpivot.aspx
BLOG: Better Bi with Reporting Services 2008 R2 for #TSQL2Sday http://speeddba.com/archive/2010/06/better-bi-with-reporting-services-2008-r2/
Give me my cores SSIS 2008!
http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/ssis-2008-multiproc-usage
and here is my entry:
http://blog.gre-sqlserver-solutions.com/2010/06/t-sql-tuesday-007-policy-based.html
http://northamerica.msteched.com/technicaltracks?fbid=6vOoBofFZCS#track10
http://www.sqlservercentral.com/blogs/steve_jones/archive/2010/06/08/t_2D00_sql-tuesday-_2300_7-_2D00_-streaminsight.aspx
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
Here is mine… http://littlekendra.com/2010/06/08/sql2008fav/
It was a difficult choice, but I picked the Data Collector.
Favorite New Feature: SQL Azure Integration In SQL Server 2008 R2. The SQL Azure Team’s First T-SQL Tuesday Post.
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2 by @SQLSoldier
Just in case the pingback spam that will probably happen… doesn’t:
http://phelabaum.com/archive/2010/06/t-sql-tuesday-7-t-sql-enhancements-in-sql-2008/
Just in case the tweet and the link-back don’t work.
http://jasonbrimhall.info/2010/06/08/data-compression/
Just in case my tweet and link-backs don’t work:
http://www.sqlfeatherandquill.com/2010/06/08/kids-these-dayst-sql-tuesday-007/
Here is a link to my post: http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!6956.entry
Here’s my last-minute entry…
http://bradsruminations.blogspot.com/2010/06/my-favorite-sql2008-feature.html
–Brad