SQL Server Room for Improvement

it_user79482
Senior Developer at Crimsonwing
An area that definitely needs improvement is the Reporting Service side with the actual report server. Although to be fair, Microsoft has developed a new branch of tools for reporting; presumably that is why they have not improved the Reporting Service side. Nevertheless, if this was not the case then, yes, it would be an area for improvement. Another area would be the SQL Server process monitoring, which is quite basic and could sustain more information. View full review »
Aju Mathai
Database Architect at Huron Consulting
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. View full review »
Lei Liu
DBA,data architectuire at a tech services company
Horizontal partitioning. In that case, cold , warm and hot data can be distributed into different database not only table partition located on different FGs . View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: February 2020.
399,540 professionals have used our research since 2012.
Royden Akerley
Enterprise Programmes Architect at a logistics company with 10,001+ employees
* 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. View full review »
Rahul Kumar Singh
Software Developer at a tech vendor with 501-1,000 employees
* Third-party services from Redgate should be built-in to it, like SQL Search. * Debugging from the debugger tool functionality should be enhanced. View full review »
Daniel Du Toit
Systems Analyst Developer with 1-10 employees
It would be nice to search for specific value across multiple tables. This would save a lot of time. View full review »
it_user540858
IT Technician / Support Supervisor at GHASSAN ABOUD GROUP
From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week. View full review »
reviewer1030020
Programmer Analyst at Cognizant Technology Solutions
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. View full review »
Paul Fijma
Engineer / MS SQL DBA with 201-500 employees
Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions. View full review »
GhamdanAl-Anesi
Member of the Board & Co-Founder, Executive Manager at Networld Systems
I would like to have more replication scenarios. View full review »
Menoj-Roekalea
Cloud DBA at UNIT4
I would like a mature real-monitoring built in into SSMS, even a trace file analyzer. View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: February 2020.
399,540 professionals have used our research since 2012.