Please share with the community what you think needs improvement with SQL Server.
What are its weaknesses? What would you like to see changed in a future version?
In terms of improvement, it could use more integration with other products.
I would like to have more replication scenarios.
I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins. I know that they are building SQL Server for the Unix environment, which is in the beta version, and not out yet. This has been a long time wish for a lot of people. Once that is out, we'll be able to tell how diversified they have become in regards to other platforms. It hasn't 100 percent on scalability and third-party plugins.
Every good tool has its own limitations. * First of all its cost. It is very high. * We need a good amount of RAM to properly use this. * Sometimes, query sticks in between. But our organization provides great RAM, so we don't have any issue with its speed.
Horizontal partitioning. In that case, cold , warm and hot data can be distributed into different database not only table partition located on different FGs .
I would like a mature real-monitoring built in into SSMS, even a trace file analyzer.
* It does not scale up to a truly global environment. We operate in 220+ countries and territories with data services centralized in three data centers. The ability for MS SQL to operate in this environment is a challenge for anything spanning regions or having a global footprint. * It is best suited to supporting a single functional instance by business domain or a single country. * MS needs to work better at the WAN implementations transoceanic. * It also needs to have a less closed or less MS centric tool dependency as integration with other databases and non-MS development environments is always problematic.
It would be nice to search for specific value across multiple tables. This would save a lot of time.
* Third-party services from Redgate should be built-in to it, like SQL Search. * Debugging from the debugger tool functionality should be enhanced.
Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions.