UPDATE: The Wrap-Up is here.
Happy New Year everyone! Welcome to 2012.
Every new year brings with it a fresh start, a second chance to do things differently. In the spirit of second chances, for this month’s T-SQL Tuesday, please pick any one of the previous 25 T-SQL Tuesday topics and write about it. You can choose one of the topics you participated in before, or you can choose one you missed for some reason.
Maybe you were just too busy when Michael Swart invited everyone to write about indexes. Or maybe you weren’t quite happy with the CTE post you came up with when Bob Pusateri hosted. Or maybe you have a ton to say about IO, but like me, you didn’t know anything about T-SQL Tuesday until long after Mike Walsh’s month.
Well now is your chance to set things straight! In fact, if you like, you can even throw down a few resolutions for the new year (see Jen McCown’s #14). And if this is your first T-SQL Tuesday, just pick a topic and jump in.
As with any T-SQL Tuesday, the standard rules apply:
- Your post must go live next Tuesday GMT (between 00:00:00 GMT on Tuesday January 10 and 00:00:00 GMT on Wednesday January 11).
- Your post should link back to this post, and you should leave a comment or a trackback here regarding your post.
- “T-SQL Tuesday #026″ should be included in the title of the post.
- If you’re on Twitter, tweet about your post using the hash tag #TSQL2sDay
Since this month is a bit unusual, here are a couple additional rules:
- Your post should be new in content, in other words don’t just repost a previous T-SQL Tuesday entry (yours or anyone else’s )
- Somewhere in your post, you should say what T-SQL Tuesday topic name and/or number you chose to write about.
I can’t wait to see which topics everyone chooses and the posts that come out of those. And of course after it’s done, I’ll summarize the posts on this blog within a couple of days.
To refresh your memory, below is a history of all T-SQL Tuesday topics to date. It’s a pretty amazing list.
- Adam Machanic – Date/Time Tricks
- Adam Machanic – A Puzzling Situation
- Rob Farley – Relationships
- Mike Walsh – IO
- Aaron Nelson – Reporting
- Michael Coles – “What about BLOB?”
- Jorge Segarra – Summertime in the SQL
- Robert Davis – Gettin’ Schooled
- Jason Brimhall – Beach Time
- Michael Swart – Indexes
- Sankar Reddy – Misconceptions in SQL Server
- Paul Randal – Why are DBA skills necessary?
- Steve Jones – What the Business Says is not What the Business Wants
- Jen McCown – Resolutions
- Pat Wright – Automation in SQL Server
- Jes Borland – Aggregations
- Matt Velic – Apply Knowledge
- Bob Pusateri – CTEs
- Allen Kinsel – Disasters & Recovery
- Amit Banerjee – T-SQL Best Practices
- Adam Machanic – Inelegant Yet Educational
- Robert Pearl – Data Presentation
- Stuart Ainsworth – Joins
- Brad Schultz – Prox ‘n’ Funx
- Allen White – T-SQL Tricks
Thanks in advance for participating!
Pingback: T-SQL Tuesday in Local Time | Dave's SQL Blog
Pingback: Rob Farley : APPLY – not exactly set-based
Mine’s at http://sqlblog.com/blogs/rob_farley/archive/2012/01/10/apply-not-exactly-set-based.aspx
I picked #17 and I guess a bit of #25.
Pingback: Index Misconceptions [TSQL Tuesday #026 - Second Chances] | sqlity.net
Took the easy way out and revisited #14 (Resolutions) – will have to see if I can keep myself honest for 12 months: http://dba-in-exile.blogspot.com/2012/01/t-sql-tuesday-14-er-26-second-chances.html
Pingback: JOINS In SQL Server | SQL RNNR
Resolutions Goals –
http://jgrobe.wordpress.com/2012/01/09/t-sql-tuesday-026-its-2012-already/
Ugh. Can you clean this up for me? Evidently I have forgotten how to do html tags! LOL!
It looks good now.
Mine is at: http://nancyhidywilson.wordpress.com/2012/01/10/tsql2sday-026-second-chances/
Thanks for hosting, Dave!
Pingback: T-SQL Tuesday(#tsql2sday) #26 – Lazy Restore Commands | Art of the DBA
I’m recapping the most recent Tips ‘n Tricks with my RESTORE build script:
http://www.mikefal.net/2012/01/10/t-sql-tuesdaytsql2sday-26-lazy-restore-commands/
Thanks for the host Dave!
Here is my T-SQL Tuesday #26 entry.
http://www.sqlservercentral.com/blogs/pearlknows/2012/01/10/t-sql-tuesday-26-second-chances-correlate-missing-index-with-related-query/
Thanks for hosting, David!
Looks like my trackback did not work.
http://jasonbrimhall.info/2012/01/10/tsql-tuesday-26-or-23-identity-crisis/
Pingback: Aaron Bertrand : T-SQL Tuesday #26 : Second Chances
Pingback: T-SQL Tuesday #26 – Segundas Chances | Blog do Leka
I see a pingback, but in case that isn’t sufficient:
http://sqlblog.com/blogs/aaron_bertrand/archive/2012/01/10/t-sql-tuesday-26-second-chances.aspx
Pingback: T-SQL Tuesday #26 – Second Changes with Date/Time « Voice of the DBA
Looks like the pingback didn’t work, so here’s mine:
http://colleenmorrow.com/2012/01/10/tsql-tuesday-026-%E2%80%93-second-chances/
Pingback: T-SQL Tuesday #26 – DBA Skillz | Dave's SQL Blog
Did I just get in under the gun: http://wp.me/puoH4-8v
And forgot to say that my post is on T-SQL windowing functions.
Here’s the full link: http://carlosbossy.wordpress.com/2012/01/10/tsql-tuesday-026-second-chances/
Pingback: TSQL Tuesday #026 – Second Chances « Carlos Bossy's Blog
Pingback: T-SQL Tuesday #26 - Second Chances - Correlate Missing Index with Related Query - Robert Pearl's Blog
Pingback: T-SQL Tuesday Topics – Febuary 2012 « Voice of the DBA