XML Feeds
One day, Adam Machanic (Twitter | Blog) had the most brilliant idea of his life to that point: T-SQL Tuesday. (That may be a slight exaggeration.) This is "a recurring, revolving blog party", hosted by a guest blogger on the second Tuesday of each month. We've had 15 fantastic parties so far. I am lucky enough to host T-SQL Tuesday #016 on March, 8, 2011!
The Topic: Aggregation
No, not aggravation (although I've used the two interchangably before). I want to hear how you solved business problems with aggregate functions. I want to see your cool T-SQL tricks. How are aggregates used in SSRS, SSAS, or SSIS? What have you learned about aggregate functions?
Let's SUM(thoughts), COUNT(ways we've done things), and set MAX(awesome) on our posts!
Remember: "any post that is related to both SQL Server and the theme is fair game. So feel free to post about SSIS, SSRS, Java integration, or whatever other technologies you're working with in conjunction with SQL Server. Even if your post includes no T-SQL we still want to see it."
The Rules
The first rule of T-SQL Tuesday is: talk about T-SQL Tuesday!
- Post your blog between 00:00 GMT Tuesday, March 8 and 00:00 GMT Wednesday, March 9. (This is equivalent to 8:00 PM EST Monday, March 7 and 8:00 PM EST Tuesday, March 8.)
- Come back here and leave a comment or a pingback to your post.
- In the body of the blog, you must include the T-SQL Tuesday logo, with a link back to this blog. (Sample HTML:
<a href:"http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/come-one-come-all-to"><img src="http://blogs.lessthandot.com/media/blogs/DataMgmt/olap_1.gif"></a>)
Bonus Points
- In the post title, include "T-SQL Tuesday #016".
- Tweet your blog post with the hash tag #tsql2sday.
- Consider hosting in the future, and contact Adam if you're interested.
I'll be reading through all the blog posts and posting a round-up. I can't wait to read your thoughts!
Jes Schultz Borland is a Consultant with Brent Ozar PLF, and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree, and has worked with SQL Server since 2007, focusing on Reporting Services and day-to-day administration. She is an active member of PASS, Director of Communication for MADPASS, founder of Tech on Tap, and a LessThanDot.com blogger. She's a frequent presenter at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef. 
Here's my contribution 
Mine's up: 
Here we go!
Here's mine: Using Aggregate Functions in XML: 
Here is my contribution: 
Here's my blog for T-SQL Tuesday :)
Thanks for hosting, Jes!
Here's my T-SQL Tuesday Two cents worth ;)
Here is my contribution:
Here's mine, thanks, it was a fun topic!
I cheated but it is almost midnight ;-)
Tah-dah!
Mine's here:
Mine is there as well 
Here you go, Jes: 
Great topic, Jes! Here's my pithy contribution:
Good morning Jes. Thanks for hosting this T-SQL Tuesday and sorry about the scheduling misfire. Thats twice my blog out smarted me :) Hope to cross paths with you at #sqlsat67.
Here's mine... 
Et voila! CLR functions for Median, Percentile, and Covariance...
Seems that trackbacks are not working.
Here's my entry 
Thanks for hosting, Jes! Here's my two Craisins' worth: 
Hi Jes, thanks for the fun topic! Voila:
Tweeted earlier, but here's my post. Thanks! 
Here's my contribution:
My entry isn't nearly as pithy as Bob's, but here goes:
For trackback purposes
Trackback link: 
Here is my post for T-SQL Tuesday on how Aggregate functions help while analyzing data loaded into a SQL Nexus database:
Here's my entry:
Wow, quite a crowd! Here's mine: 
Late to the party, as usual... Here's mine:
Thanks Jes! Here's my entry:
Here's mine:
Just about waited to the last minute.
And mine: 
My contribution: 
My contribution is here 
Doh, just realised that my scheduled post did not show up here, so here's he link:
I'm late, but here's mine: 
Jes, thanks again for hosting and the kind comments.
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.