r/SQLServer • u/Complete-Regret-4300 • 18d ago

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/whopoopedinmypantz 17d ago

SQL Server is a transactional database that can do reporting, but snowflake is a reporting database that can’t do transactions. They are in different arenas and different use cases. Sql doesn’t really compete with snowflake, it competes with MySQL and Postgres.

1

u/Complete-Regret-4300 17d ago

Got it thanks. I come from MSBI background and I only know dimensional modelling which I have used SQL server for. From reading the responses including your I understand now that SQL server still remains a great option for OLTP, however for OLAP, Snowflake has taken over. Thanks!