Just over eight years ago I decided to try an experiment: Set up a roaming blog event for the SQL Server world. I was hopeful that it would catch on; I even prefixed the number one with two zeroes in anticipation of someday, maybe, hopefully filling in all three spaces. But honestly, 100 months? That’s a long, long time, especially in our industry.
It’s been quite a ride – 100 posts over 101 months (we actually skipped one month the first year, due to not wanting to overlap with the PASS Summit). Some months, especially recent ones, have been immensely popular, generating 50 or more posts. A couple of months have been a bit more touch and go. But overall I’d call the event quite successful.
Along the way we got an official logo, Steve Jones created a fantastic archive web site, and the event has not only help created a tremendous number of blog posts, it’s also been cited as inspiration by many new bloggers to whom I’ve spoken. In short, I’m really proud of what I put in motion, and what we—this means you if you’re a blogger—have been able to do together. Thank you for 100 great months!
Let’s look backward…
This is, of course, the invitation for month #100, so let’s get down to business. As I prepped for writing this invitation, I went through the archive and attempted to categorize all 99 prior topics. What immediately became apparent is that our community is extremely concerned, above all else, with professional development. 24 of the 99 topics we’ve seen so far fall into that bucket. For what was initially conceived as a mainly technical series, that’s not quite what I expected. But given the general maturity of the community and data professionals in general, it’s also not too surprising. Things often tend to change slowly in our database world, but we’re always looking for the next big move for our careers.
The last few years has felt like quite a shift with regard to this last point. We’ve seen rapid adoption of such new ideas as public cloud, machine learning, and so on. T-SQL Tuesday topics have also followed these trends; around 30% of the topics over the past two years have been focused on these newer paradigms. When I started T-SQL Tuesday in 2009, no one was talking much about any of these things. We were still really excited about SSDs, just getting into the stride with multicore, and wondering about what cool stuff we might get in SQL Server 2008 R2. (Did we ever answer that final question?)
Let’s look forward…
Anyone who has been in IT for more than 10 minutes knows how the industry works. IT loves its trends, but things tend to be very cyclical. Our current crop of “cloud” technologies are nothing new at the heart of things. The cloud, a wise person once said, is merely someone else’s server. And we’ve seen prior iterations of these same hardware sharing ideas going all the way back to the 1960s. Machine Learning, likewise, has been around in other guises for several years. Columnstore ideas are decades old even if they’re new-ish in the Microsoft space, and even in-memory has a rather deeper history than many realize. None of these “new” technologies about which we’re so excited are actually new, even if they’re newer (and hopefully better) implementations.
It is possible, of course, that a more rapid cycle could break the trend. It is possible that newer technologies will be truly new. Or perhaps the future will simply bring more of the same, a continuation of the everlasting IT sine wave.
Your mission for month #100 is to put on your speculative shades and forecast the bright future ahead. Tell us what the world will be like when T-SQL Tuesday #200 comes to pass. If you’d like to describe your vision and back it up with points, trends, data, or whatever, that’s fine. If you’d like to have a bit more fun and maybe go slightly more science fiction than science, come up with a potential topic for the month and create a technical post that describes an exciting new feature or technology to your audience of June 2026. (Did I do the math properly there?)
The Rules
T-SQL Tuesday would be nothing without some rules, and a while back I codified them. The important notes with regard to Month 100:
- Your post must go live next Tuesday, March 13, between 00:00:00 and 23:59:59 in your own time zone. Or whatever time zone you happen to be in. Or you can borrow a friend’s time zone. Just make sure it’s Tuesday somewhere, okay?
- Your post must include the T-SQL Tuesday logo as seen above. And said logo must link back to this invitation post.
- Make absolutely sure to let me know in the comments section below after you post, so that I can include you in the roundup.
- If you’re on Twitter, tweet about your post using #TSQL2sday. (Now that we have 280 characters, I’m not sure that 3 character savings was quite worth it…)
- If you’re interested in hosting a future month, contact me.
That’s it! Any questions? Let me know. Otherwise, go forth, think, write, and enjoy yourself. See you in another eight years.
Adam here is my post for this months T-SQL Tuesday #100 party – https://sqlmastersconsulting.com.au/SQL-Server-Blog/t-sql-tuesday-100-skills-shortage/
Thanks for hosting
Select DateAdd(month, 100, getdate());
———————–
2026-07-12 21:28:31.960
(1 row affected)
😁😁😁😁😁😁😁😁
Not so fast, smart guy.
SELECT DATEDIFF(MONTH, ‘2009-12-08’, ‘2018-03-13’)
———–
99
(1 row affected)
Select DATEDIFF(MONTH, ‘2009-12-08’, ‘2026-06-13’), DATEDIFF(MONTH, ‘2009-12-08’, ‘2026-07-13’);
———– ———–
198 199
(1 row affected)
and of course, that makes the months zero based so you need to add 1. June would be #199 and July #200. 🙂
Okay, agreed. I thought we’d skipped a month along the way — November 2010 — so my numbers were off by one. But in reality I was mistaken. No months have been skipped! Thanks Robert.
To be honest, I found this to be a lot of fun. 🙂
Great topic. Here is my post “The (Microsoft?) data platform anno 2026”
http://www.pontop.dk/single-post/2018/03/13/The-Microsoft-data-platform-anno-2026-T-SQL-Tuesday-100
Best,
Kennie
I thought I’d have a bit of fun this month 🙂 https://sqlundercover.com/2018/03/13/tsql-tuesday-100-a-look-to-the-future/
Thanks for hosting (and creating!) T-SQL Tuesday. This was a fun topic to think about https://bertwagner.com/2018/03/13/full-automatic-tuning-sql-server-2026s-most-killer-feature/
Here’s my slightly irreverent look to the future:
https://matthewmcgiffen.com/2018/03/13/crystal-balls/
Here’s mine. Loved loved loved the topic.
https://ozar.me/2018/03/databases-five-years-from-today-2018-edition-tsql2sday/
[…] 100th T-SQL Tuesday says, “Predict 100 months […]
Thanks for hosting this Adam, here’s mine!
https://nocolumnname.blog/2018/03/13/t-sql-tuesday-100-looking-forward-100-months/
Thank you for creating something that has inspired so many blog posts!
https://www.bobpusateri.com/archive/2018/03/collecting-other-peoples-christmas-cards/
[…] milestone. This month, our host is the creator of this monthly blog party, Adam Machanic (b|t). Adam, thank you for introducing something that has inspired the community for so […]
[…] topic for this months T-SQL Tuesday #100 (hosted by Adam Machanic Blog/Twitter) […]
Thanks Adam for
hostingI mean founding and sustaining this!https://www.mlakartechtalk.com/t-sql-tuesday-100-future-sql-server-2026/
Adding my entry here in case the pingback doesn’t work: https://debthedba.wordpress.com/2018/03/13/t-sql-tuesday-100-looking-ahead/
Thanks for hosting, Adam!
My contribution: http://sqlkover.com/t-sql-tuesday-100/
I went a bit off the beaten path… but had a great time writing it! 🙂 Thanks for the topic! http://sql313.com/index.php/menu-main-blog/75-tsql-tuesday-100
In case trackback fails: https://voiceofthedba.com/2018/03/13/looking-forward-for-t-sql-tuesday-100/
[…] valid number to look back, he decided that looking ahead is more fun. He asks all bloggers to whip out the crystal ball and predict what our world will look like in another 100 months, when (hopefully) T-SQL Tuesday #200 will be […]
[…] you want to join in, write your own post for for the blog party. To see how to participate, see the announcement post for the details and […]
T-SQL Tuesday #100: What’s New With Scalability Groups in SQL Server 2026 http://sqlsoldier.net/wp/sqlserver/tsqltuesday100whatsnewwithscalabilitygroupsinsqlserver2026
Here’s mine. Honestly it went in a different direction to how I conceived it, but I’m pretty happy. https://bornsql.ca/blog/t-sql-tuesday-100-looking-forward/
[…] only participated in 2 #tsql2sday events before this, so I am amazed that this is the 100th edition of Adam Machanic’s (t|b) uber-nerdy blog […]
HI Adam
I’m not as brave as I thought I was, but here is my post.
https://jimbabwe.co.za/2018/03/13/247/
Thank you for hosting.
Here’s my comment as requested! Great topic Adam 🙂 Thanks for hosting (and coming up with the whole thing in the first place)
https://sqlstudies.com/2018/03/13/a-look-back-from-the-future-tsql-tuesday-100/
My post is here: https://littlekendra.com/2018/03/13/sql-server-2026-bagi-edition-tsql2sday-100/
Happy 100!
[…] month’s T-SQL Tuesday challenge, hosted by me, was to envision the world 100 months in the […]
T-SQL Tuesday #100 – Announcing NCDNAI – June 1, 2026 #tsql2sday
https://wp.me/p1n3H4-3U
And thanks again for hosting!
Count me in!
A couple of posts that missed trackbacks/comments:
http://dallasdbas.com/tsql-tuesday-100-looking-to-the-future/
https://sqlundercover.com/2018/03/13/tsql-tuesday-100-a-look-to-the-future/
[…] thank Adam Machanic (b|t) for hosting TSQL Tuesday #100. Topic for this month is Looking Forward 100 Months. I also want to acknowledge Adam’s […]
[…] his invitation post, our host and T-SQL Tuesday owner Adam Machanic (@adammachanic) makes some interesting points about […]
[…] this T-SQL Tuesday we are asked to look into our crystal SQL Server ball and predict what will be happening at the […]
Thanks for starting this blog series and for this great topic! I like science fiction, so I gave it a try: http://www.dba-art.com/t-sql-tuesday-100/
This was fun to write: https://sqlnikon.com/2018/03/13/sql-life-2026/
[…] celebrate the 100th TSQL Tuesday, this month’s topic is what things will be like 100 months from […]
I wrote….something?
http://www.sqlgene.com/2018/03/14/tsql-tuesday-100-industry-changes-and-meidingers-law/
Here is my post on the future, which naturally has everything to do with the need to learn Advanced Analytics. https://www.desertislesql.com/wordpress1/?p=2047
[…] has led me to make some changes in my own life as I believe change is coming to the industry. Adam Mechanic’s prompting for looking ahead to 2016 has provided the impetus to publish these theories. What I see in the marketplace is the tools […]
Hi Adam, great to meet you last week and here is my post:
https://sqlmastersconsulting.com.au/SQL-Server-Blog/t-sql-tuesday-100-automation-and-cleaner-code-data-is-the-key-to-future-success/
It’s still Tuesday somewhere.
https://scribnasium.com/2018/03/machine-learning-in-sql-server/
Thanks for hosting.
Indeed it was! Good job getting in just under the wire.
[…] so I missed the boat by a few days week. That’s pretty much my M.O. This month’s T-SQL Tuesday #100 is hosted by the author of sp_WhoIsActive and the creator of T-SQL Tuesday himself, the […]
[…] asked T-SQL Tuesday #100 participants to take a speculative view on the world 100 months from now. 32 people weighed in—in […]
[…] Invitation and roundup from T-SQL Tuesday founder, Adam Machanic. […]
This is nice post. Thanks for sharing this information.
https://www.uaetechnician.com/hard-drive-data-recovery.html
удалите,пожалуйста! .
books in ancient times was papyrus
The most common form
and 12 thousand Georgian manuscripts
and was erased, and on cleaned
reproduced by hand, in contrast
купить Merries – Genki в спб, Японские OMUTSU
“Julia’s Garland” (fr. Guirlande de Julie)
Century to a kind of destruction:
new texts were rewritten
check my reference why usdt price going down
Уборка квартиры – Ремонт микроволновки, Уборка квартиры, дома после ремонта
Europe, and in Ancient Russia
Comments are closed.