“…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.”
Big thanks to Adam for starting this monthly blog party and keeping the energy going!
Let’s predict the future of SQL Server! I will share with you my best guesswork about how it will be to work with SQL Server 2026.
It is difficult to guess where the technology of today will be 5 years in the future let alone 8 years. That is a long time in the tech industry! Nevertheless, I consulted my crystal ball of divination and here is what I foresee.
The Future of SQL Server – Alive and Well
- Structured Query Language (SQL) will still be the dominant method for working with RDBMS. Every other year there is a rumor that SQL will be replaced or fall out of favor with another database query language.
- These query languages will not replace SQL: LINQ, MDX, NoSQL, SPARQL, XQuery/XPath etc. Nor will any other replace SQL.
- Additionally, Kevin Feasel’s Law will also still hold “any sufficiently advanced data retrieval process will eventually have a SQL interface.”
- DBAs will still exist – similar to the above, every few years we see a story about how we somehow won’t need DBAs anymore.
- Relational databases are so ingrained that we would sooner see the keyboard character layout revised than not store data in a database.
- As long as there are databases there will be someone to administer / develop / query them.
- The job isn’t going away but evolving – stay current!
- Relational databases are not going anywhere – NOSQL is complementary not a replacement.
- Expect business will continue to automate all the things.
- Security will still be bad because nobody cares and there is little consequence for poor data stewardship.
- An example explains it well.
- The traditional employer/employee relationship will morph into a more freelance arrangement.
- Contracting and consulting jobs will abound.
- The Gig Economy could manifest and disrupt the status quo.
- Semicolon use for statement termination still won’t be enforced.
- Deprecated features will still somehow be around (DBCC DBREINDEX. old sys catalog views, SQL Profiler, etc.)
Hard to Predict the Future of SQL Server
I don’t think we will be typing “COMPUTER: SHOW ME DATA” and it will magically produce relevant info
There’s a lot more than Natural Language Processing (NLP) preventing that.
However, one thing will be certain.
The Future of SQL Server Depends on People
…and they will change much slower than the technology.
- People will still test in production…or not test at all
- People will still resist source control
- Documentation will still be lacking
- People will still be making wild predictions on the internet ☺
Did you find this helpful? Please subscribe!