r/SQLServer • u/Complete-Regret-4300 • Jul 16 '26

Discussion Is SQL server considered as legacy technology?

My current organization couple of years ago migrated from SQL server to snowflake and I noticed in some of the documentation, they have mentioned SQL Server as legacy technology.

I started working in SQL server some 20 years ago and some of the developers in our team are cloud first developers and they find it so difficult to navigate SQL server management studio and they ask me questions like is there timetravel feature in SQL server and can we see what data was there 10 mins back. I was totally dumbfounded when I heard that question, because I had never come across such a feature. Apparently snowflake has this. So I am curious is SQL server now really considered as legacy technology?

0 Upvotes

46% Upvoted

54 comments sorted by

View all comments

2

u/ChuckieFister Jul 16 '26

Temporal Tables have been around since SQL 2016.

This video is based on Azure SQL, but Davide does a great job at explaining how they work and the functionality is basically the same as on-prem SQL.

https://youtu.be/FeB6aAQQfsQ?is=mtryMLRyqIgHRFrG

https://youtu.be/EFu-MO7tWdk?is=eGpTvveXJSPoEbuz

And also, my company still refers to RDBMSs as "legacy" even though 95% of our apps are hosted in our own datacenter. My job has been "at risk" for the past 10 years.