SQL Server Room for Improvement

Senior Developer at a tech vendor with 201-500 employees
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 »
Недашковский Евгений
Senior SQL DBA at a financial services firm with 51-200 employees
I like it the way it is, though I would appreciate a dark theme for SQL Server Management Studio and ability to add databases with TDE enabled into availability groups. I am aware of Connect and Trello pages, and there are a lot of good ideas from other people, most of them are useful only in some very rare scenarios. There are interesting suggestions present, and Microsoft should pay more attention. 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 »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: September 2019.
370,827 professionals have used our research since 2012.
Sr. Database and Application Administrator with 10,001+ employees
Right now, the tool you use to query the system updates every month. It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it. View full review »
Systems Analyst/DBA at a comms service provider with 501-1,000 employees
Setting up some of the more complex systems could be simpler. Things like service broker can be tricky to set up for the inexperienced. View full review »
Managing Director at a tech services company with 11-50 employees
The web interface and the command line interface could be better so we could manage and build some things around an API. If we could build our own solution, our own interface, and then manage the solution through that open API, that would be better. View full review »
Lead Software Engineer at a tech services company with 11-50 employees
As a software developer, it can be hard to do something in Oracle that is SQL Server specific, and vice-versa, sometimes. Improvements must not be stopped and must not end. When business needs arrive, then the improvements follow. For example, 15-20 years ago, MySQL did not have built-in Stored Procedure support; there was no business need for MySQL to have stored procedures built-in. 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 »
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 »
Chief of Engineering at a comms service provider with 11-50 employees
* Only one CPU core can be used * Can’t move a database between servers easily * Can’t use triggers The free version is cumbersome to use and maintain. But $5000 for a licence is more expense than the benefit I would get from a licensed version. View full review »
IT Technician / Support Supervisor at a transportation company with 501-1,000 employees
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 »
Programmer Analyst at a tech services company with 10,001+ employees
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 »
Pierre Marçon
User at a tech services company with 10,001+ employees
The reporting services of the solution (SSRS and now Power BI) are the less valuable items of the SQL Server suite. 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 »
Member of the Board & Co-Founder, Executive Manager at Networld Systems
I would like to have more replication scenarios. View full review »
Cloud DBA
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: September 2019.
370,827 professionals have used our research since 2012.
Sign Up with Email