T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate and I’d encourage you to write on these topics, whether you do so on that particular month or not.
This is an Updated list of all the topics. I was looking for a static list of all the T-SQL Tuesday topics and couldn’t find one. The domain moves around to the current hosting blog, so when it was my turn to host it, I made a list just so I could reference what was out there. After a few more months, I decided to update my list with the latest topics. That will give me the chance to plan for my own future hosting of the party if Adam will have me again.
February – T-SQL Tuesday #87 –Fixing Old Problems with Shiny New Toys (roundup) – What I’d like to see from the blog responses for this T-SQL Tuesday is how you’ve used a “new” Microsoft data platform toy to fix an old problem. We’ll define new toys as something from SQL Server 2014’s release date until now. We’ll even accept a SQL Server vNext response if you’ve got one!
Find the most interesting bug or enhancement request (and it can be your own), and write a blog post about it
|December 2016||#85 – Backup and Recovery||Rollup||Backups are one of the most common things DBAs discuss, and they are at once one of the simplest and most complicated parts of our whole job. So let’s hear it for backup and recovery!|
|November 2016||#84 – Growing New Speakers||Roundup||For T-SQL Tuesday, I am giving differing topics if you are currently a Speaker or have never have spoken.If you are a presenter, help new speakers. If you have never spoken, start thinking about your first presentation.|
|October 2016||#83 – We’re Still Dealing with the Same Old Problems||Roundup||I offer two fill-in-the-blank topics:
|September 2016||#82 – To the Cloud… And Beyond!||When Adam asked me if I wanted to host another T-SQL Tuesday, I immediately knew a topic I wanted to talk about: The cloud, and (if you want to) specifically about Azure SQL database.|
|August 2016||#81 – Sharpen Something ()||Roundup||This month I am asking you to not only write a post but to do a little homework – first. In other words, plan to do something, carry out that plan, and then write about the experience.|
|July 2016||#80 – My Birthday||Roundup||Treat yourself to a birthday gift and come up with a present for yourself SQL related – no limitations.|
|June 2016||#79 – It’s 2016||Roundup||SQL Server 2016 went RTM this week and so naturally, we’re going to write about it.|
|May 2016||#78 – Learn Something New||I’m challenging you to learn something new and blog about it!|
|April 2016||#77 – Favorite SQL Server Feature||Roundup||The topic is: What is My Favorite SQL Server Feature.This can be anything from Reporting Services as a report creating tool, down to the Columnstore Indexes. Anything goes!
I selected this topic precisely to illustrate the breadth and depth of what SQL Server has evolved into over the last decade+.
|March 2016||#76 – Text Searching/Processing||Wrap-up||If you’re using SQL Server Full-Text Search, I’d love to hear from you. But I’d also love to hear from anyone using any other kind of text searching or processing methods.|
|February 2016||#75 – Power BI||roundup – 11 responses||Your challenge, if you choose to accept it, is to create and publish your very own Power BI report!|
|January 2016||#74 – Be the Change||roundup – 11 responses||How do you track changing data? How do you do your ETL? How do you clean or scrub your data? Anything related to changing data.|
|December 2015||#73 – Naughty or Nice?||() 6 responses||As you work with SQL Server look around you. Is your environment Naughty or Nice?|
|November 2015||#72 – Data Modeling Gone Wrong||summary||I would like to invite you to share some data modeling practices that should be avoided, and how to fix them when they do occur.|
- December – T-SQL Tuesday #73 – Naughty or Nice? – As you work with SQL Server look around you. Is your environment Naughty or Nice?
- November – T-SQL Tuesday #72 – Data Modeling Gone Wrong (summary)- I would like to invite you to share some data modeling practices that should be avoided, and how to fix them when they do occur.
- October – T-SQL Tuesday #71 – SQL Server Audit () – For this month, I would like to invite you to write about Auditing. Auditing is certainly a security related topic, and with that fits right in with the August topic (Encryption).
- September – T-SQL Tuesday #70 – The Enterprise (roundup) – How do you manage an enterprise? What tricks do you use? What are the challenges?
- August – T-SQL Tuesday #69 – Encryption (roundup) – Write about how you use encryption, why not, what’s blocking you, or what you just learned.
- July – T-SQL Tuesday #68 – Just Say No to Defaults (roundup) – running with defaults is far from ideal. We all change things after we install an instance, sometimes not until we encounter a problem. Write about something you’ve dealt with as far as defaults go.
- June – T-SQL Tuesday #67 – Extended Events (Wrap-up) – How have you used extended events? If you haven’t, try to learn something, set up a session, and write about it.
- May – T-SQL Tuesday #66 – Monitoring (roundup) – you must monitor your systems, your SSIS packages, your reports, something. Talk about monitoring in SQL Server.
- Apr – T-SQL Tuesday #65 – Teach Something New (roundup) – Completely open ended. Teach yourself something new, anything, about SQL Server and write about it. Bonus for talking about how you learned something new.
- Mar – T-SQL Tuesday #64 – Calling All Tuners and Gearheads (roundup) – Russ wants posts tackling “focused” performance tuning. By “focused,” he means tackle something head on; the more secret sauce, tricks, code samples, operator costs, or demonstrable metrics against a defined problem the better.
- Feb -T-SQL Tuesday #63 – How Do You Manage Security? (roundup) – What tips, tricks, techniques, or philosophies do you have around security?
- Jan – T-SQL Tuesday #62 – HealthySQL (roundup) – How do you ensure your instances are healthy? Monitoring? Maintenance? Something else?
- Dec – T-SQL Tuesday #61 – Giving Back (roundup) – How can you, or will you, give back to the community? Speaking, answering questions, writing software?
- Nov – T-SQL Tuesday #60 – Something New Learned (Roundup) – Have you challenged yourself lately? How are you going to jump start your learning?
- Oct – T-SQL Tuesday #59 – My Hero – Write about your heros and how you met them, learned about then, got inspired, or something else.
- Sep – T-SQL Tuesday #58 – Passwords (Roundup) – Write something about passwords. How you manage them, pick them, check them, etc.
- Aug – T-SQL Tuesday #57 – SQLFamily and Community (Recap) – Time to talk about community and the SQLFamily.
- Jul – T-SQL Tuesday #56 – Assumptions (Wrap) – We all have assumptions about various aspects of our jobs. What happens if those assumptions aren’t true?
- Jun – T-SQL Tuesday #55 – SQL Server 2014, The Good, The Bad, and The Ugly (The Wrap) – Talk about something you like, or dislike, or think isn’t a good implementation in SQL Server 2014.
- May – T-SQL Tuesday #54 – Interviews and Hiring (The Summary) – Put down anything about interviewing and hiring. How you conduct one, how your last one went, what are good questions, what’s stumped you?
- Apr – T-SQL Tuesday #53 – Why So Serious? –
- Mar – T-SQL Tuesday #52 – Argue Against a Popular Opinion – Round-up
- Feb – T-SQL Tuesday #51 – Place Your Bets – Jason Brimhall – roundup
- Jan – T-SQL Tuesday #50 – Automation – SQLCHOW
- Dec – T-SQL Tuesday #49: My Go-To Query For Waiting Tasks – Robert Davis (roundup)
- Nov – T-SQL Tuesday #48 – Cloud Atlas – Jorge Segarra (roundup)_
- Oct – T-SQL Tuesday #47 – Your Best SQL Saturday SWAG – Kendal Van Dyke
- Sep – T-SQL Tuesday #46 – Rube Goldberg Machine – Rick Krueger – (wrap up)
- Aug – T-SQL Tuesday #45 – Follow the Yellow Brick Road – Mickey Stuewe(summary)
- Jul – T-SQL Tuesday #44 – Second Chance – Bradley Balls (roundup)
- Jun – T-SQL Tuesday #43 – Hello, Operator? – Rob Farley (roundup)
- May – T-SQL Tuesday #42 – The Long and Winding Road – Wendy Pastrick
- Apr – T-SQL Tuesday #41 – Presenting – Bob Pusateri (Recap)
- Mar – T-SQL Tuesday #40 – Files and Filegroups – Jen McCown (roundup)
- Feb – T-SQL Tuesday #39 – Can You Shell What the PoSH is Cooking? –Wayne Sheffield (recap)
- Jan – T-SQL Tuesday #38 – Standing Firm – Jason Brimhall
- Jan – T-SQL Tuesday #26 : Second Chances (summary)
- Feb – T-SQL Tuesday #27 – Big Data (Round up)
- Mar – T-SQL Tuesday #28 – Jack of All Trades, Master of None?
- Apr – T-SQL Tuesday #29 – The Most Useful Feature of SQL Server 2012
- May – T-SQL Tuesday #30 – A DBA’s Ethics
- Jun – T-SQL Tuesday #31 – Logging
- Jul – T-SQL Tuesday #32 – A Day in the Life (roundup)
- Aug – T-SQL Tuesday #33 – Trick Shot (roundup)
- Sep – T-SQL Tuesday #34 – Help! I Need Somebody –
- Oct – T-SQL Tuesday #35 – Soylent Green – (Roundup)
- Nov – T-SQL Tuesday #36 – What Does Community Mean to You? (roundup)
- Dec – T-SQL Tuesday #37 – A Month of Joins (roundup)
- T-SQL Tuesday #015 – Automation (summary)
- T-SQL Tuesday #016 – Aggregation (summary)
- T-SQL Tuesday #017 – APPLY Knowledge (roundup)
- T-SQL Tuesday #018 – CTEs (wrapup)
- T-SQL Tuesday #019 – Disasters and Recovery (wrapup)
- T-SQL Tuesday #020 – T-SQL Best Practices (wrap-up)
- T-SQL Tuesday #021 – A Day Late and Totally Full of It
- T-SQL Tuesday #022 – Data Presentation (round-up)
- T-SQL Tuesday #023 – Joins (summary)
- T-SQL Tuesday #024- Prox N Funx (Summary)
- T-SQL Tuesday #025 – Invitation to share your tricks (summary)
- T-SQL Tuesday #002: A Puzzling Situation
- T-SQL Tuesday #003: Relationships
- T-SQL Tuesday #004: IO
- T-SQL Tuesday #005- Reporting
- T-SQL Tuesday #006: “What About BLOB?”
- T-SQL Tuesday #007: Summertime in the SQL
- T-SQL Tuesday #008: Gettin’ Schooled
- T-SQL Tuesday #009: Beach Time
- T-SQL Tuesday #010 – Indexes
- T-SQL Tuesday #011: Misconceptions
- T-SQL Tuesday #012 – Why are DBA skills necessary?
- T-SQL Tuesday #013 – What the Business Says is Not What the Business Wants (Summary)
- T-SQL Tuesday #014 – Resolutions (summary)
I’ll keep updating, mainly so I can keep track.
If’ I’m missing something, let me know.