Microsoft SQL Server

Provides good interface and intelligence help to write queries easily.

Provides many built-in functions to perform various operations on data.

Helps to store and manipulate data.

4 Users can create their own functions and procedures.

Provides various types of data for analysis.

Due to many features included in SQL Server it takes large memory and some times it slows down.

You need to refresh many times for intellisense to show up.

Installation takes more time.

SQL Sever supports multiple users in one setup which make it a multiuser system.

SQL profiler tracks the background queries and helps with the debugging and management of SQL queries

By analysing estimated and actual test plans, it helps to make queries more optimized

Issues exist when restoring a database for low screen resolution system. This should be debugged and corrected.

Doesn't auto backup an unsaved query window. So when SQL server is restarted it [loses] previously unsaved work.

Hanging issues while booting SQL Server.

Easy to setup with the included Wizard that helps to get you up and running with the essential components covered. You won't waste a lot of time reading through documentation to just get started.

There is a large community of support for Microsoft SQL Server that can help to troubleshoot issues and explain how to tackle a problem.

The other components and modules to the system make is easy to setup backups and connections to other services.

I would like to see them overhaul the Microsoft SQL Report Server included. Its very outdated and lacks modern features.

I would like more artificial intelligence support to help make the databases run more efficiently.

I would like have better support for ORM management within the included Studio Manager.

Group and count data

Join multiple data sets together across entire organization rather than a single site view

Monitor exception cases at scale

Intellisense won’t turn back on

Enhance object explorer to help find tables previously unknown

Easier note taking

It can store large amounts of data. Moreover, it doesn't just store the data, but performs important operations with it. Things like backup, restore, etc., are all handled pretty well by SQL Server.

It is equipped with different tools like SQL Profiler (for visualizing what's going on), SQL Tuning Advisor (for better suggestion of indexes, etc.) and also third party tools like SQL Search and SQL Code Guard. This really makes life easier for us.

SQL Server integrates to almost all the programming languages that work as front end for SQL Server, such as asp.net, C++, etc.

Services provided by SQL Server do solve some high business level problems using SSIS and SSRS.

Support and service from a company like Microsoft is another big advantage.

The above mentioned points are all strengths of SQL Server, as this one RDBMS does a lot of jobs, and with relative ease and efficiency compared to any other software in this sector.

In terms of resource utilization, there is room for improvement for SQL Server, so that it can cost less CPU usage.

There are lot of third party services like SQL Search and SQL Code Guard. Why is there a need for these if SQL itself can implement these necessary functionalities inbuilt?

Faster in performance.

The concept of CTE(Common table expressions) is really great.

Temp tables works well and easy to use.

We need to always use BEGIN TRAN to start a transaction which adds an additional step each time.

it has a lot of security feature, no one can access if they have no credentials.

easy to use and maintain the database

very flexible and easy to install and for new users it very easy to learn and implement.

it has little bit performance issue

output window panel is single if we run multiple select commands it shows all results in one after that so that is more clumsy

it goes hang in low System RAM configurations.

Support is a major factor. Day-to-day functionality is reliable, but for those times when there are issues support is available.

Security is key, and Microsoft SQL Server has clearly put this concern in its design.

Perhaps not a strength of SQL Server itself, but the pool of professionals with SQL Server experience ensures the ability for growth.

User setup should be allowed to be copied from other users

It's fairly quick to manipulate large sets of data

Quick and easy to learn

Cost efficient

Implement features to process unstructured data easier

Increase performance speed

Add multiple results table in the same window

Tables in database automatically pop up in writing SQL, makes it easier to navigate

Has pivot functionality, so I can query pivot tables instead of making them in Excel

Great connection to Excel in terms of exporting queries

Windows set up time takes longer than other DB software

Does not allow numbers in "group by" clause, users need to write the column names explicitly

Integration of the R programming language and its eco-system.

Transact-SQL is quite expressive and allows implementing complex application logic.

MS Excel can be used as front-end.

OLAP queries on non-aggregated POS data can be very slow. Hence, it is required to persist aggregated views on the data.

Debugging R-Code is not convenient.

Versioning of SQL procedures.

Runs on LINUX

Job and Task schedule and Email Notification

Distribution Transaction

Support

RDMS Database backend for Web Site Application

RDMS Database backend for Reporting Services

RMS Database backend for ERP, CRM etc Software Tool Project

Automated jobs on schedule

Easy integration with the Com Components (Assemblies Integration)

History of the jobs executed, gives the failure and the success email alerts after executing

Database file partition for the large databases

Log Shipping is a very easy to implement and very useful feature

Better GUI for inbuilt functionalities. For example, I would like to have the Database email services have a good interactive GUI instead of the current one.

It would be nice to have a Start Ups Guide for SQL Server which explains all the basic and necessary services needed for a start up company to use SQL Server.

In a single package, you get a data base/OLAP/reporting.

Ease in using the best documentation and books are available for anyone to start working on it and use tons of features.

Columnstore indexes need to be improved further even after many limitations were removed in SQL 2016.

Pricing of the SQL Server license should be made more simple to be understand easily.

Strengths of Microsoft SQL Server creating an ease even for a newcomer who just knows basics of the database. Creates an easy adoption for any other database programmer who is working on another platform (Oracle, MySQL etc.) to get migrated over to Microsoft SQL server version with minimal efforts.

Primarily when the application data to be hosted is very less there is less complexity involved in the creation of databases, securing access to a database table, schema and role wise. Much of the functionality of DML, DDL operations can be achieved through user interface called SQL management studio - best tool for any programmer to senior DBA.

SQL Server integration services, analysis services, and reporting services which are included in BI pack will definitely help enterprise customers save a lot of revenue spent on the additional BI stack Reporting products like Cognos, Crystal Reports, Informatica etc.

SQL Server has certain limitations in terms of functionality of SQL management studio. But there are a lot of third party programming tools which are available in the market which is powerful enough to overcome these limitations.

Database comparison tool - Lack of a tool where you can compare entities of database like tables, views, indexes between 2 databases of the same application (like comparing production to stage sites).

Version control management system (to maintain different versions of code checked in / checked out). Had to be driven using 3rd party tools.

SQL replication - coverage for all 3rd party databases has been withdrawn in recent editions which are a limitation especially while migrating from previous SQL server editions. This is a gray area of SQL Server often challenged to due to limitations of integration to 3rd party software's like Oracle, MySQL etc.

Performance management tools - even though there are built-in reports like "Activity Monitor", they are existing to monitor the performance of SQL Server. It's better to have an individual console to connect to SQL server instead of depending on Windows or other 3rd party tools like APEX SQL console, IDERA tool to monitor SQL server performance.

Excellent Speed

Backup/Restore fast

Automated processes work well

Data encryption

Security

Fuzzy SQL logic

SSMS provides useful tools such as the database tuning advisor - providing recommendations for missing indexes.

SSMS provides useful tools such as the SQL Profiler - Providing in-depth trace files of queries currently executing in your database.

SSMS provides useful tools such as the Activity Monitor allowing you to find expensive queries, resource waits, processes, and I/O.

Would prefer more built in queries for DB optimization rather than having to find scripts on the internet.

Backing up databases both full and differential as well as transaction logs so data recovery is simple.

Database cleanup and maintenance tools that can be scheduled to keep the database running at optimal performance.

The performance monitor allows you to track query performance so you can maintain the best user experience and tune the server for optimal usage.

A better way to remotely connect to the database to maintain and review current transactions is needed.

SSRS report designer needs better tools to build the reports you need. Too many workarounds due to limitations in SSRS.

Logs need to be less cryptic and more meaningful at times so that diagnosing problems can be done quicker.

Great catalog of online support

Intuitive interface

Very useful functions and methods not available on other platforms

SQL Server Integration Services, in my experience, is very buggy and crashes often. Needs improvement

I wish it was easier to retrieve current instance settings and configurations without going through much of the installation process again

Compatibility with Power BI suite is not intuitive and is less than robust

SQL Server handles a relational database very well. The fundamental logic for Extract, Transform and Load (ETL) hasn't changed much for a long time, so there is no learning curve if you upgrade from older versions to new ones.

One of the strong advantages of using SQL Server is its better compatibility with Microsoft product suites. Choosing Microsoft SQL server is the first choice if your organization relies on other Microsoft products.

It is very stable, fast, affordable, and extremely popular. There is an easy learning curve to acquire SQL Server skills. Microsoft SQL Server Management Studio is very graphical and requires very little programming to achieve basic tasks.

SQL Server is only operable on the Windows platform. It should support the Unix platform too.

There are a few object types missing in SQL Server, e.g. no packages (collection of procedures and functions), no "before" event triggers.

SQL Server doesn't support partitioning.

Data accessing via Excel or Access is very easy.

Reporting services are a really good example to present and analyze the data to management.

We do have an analytics team which does a lot of data modeling and also uses lots of integration services.

Definitely room for improvement in SQL server reporting services.

Missing the functionality to purge/archive/delete the reports from the server. We have to do it one at a time.

Easy to use.

Works great with .Net platform

Can handle complex queries for big data comanies

Performance

Pool size

Compatibility

It's a great database backend system. It will allow you to store a wide variety of databases and datatypes.

It's easy to create and execute, stored procedures to automate tasks.

It allows for us to set up a vast array of permission sets, so people who need to access it only can access the features they need.

The latest implementation of SSIS does not work as well as the previous versions when it comes to importing datasets from Access or Excel files. Rather than using the datatypes in those source files, it tried to figure out the datatypes by looking at the first few columns. This has been frustrating for us.

It would be good if SQL Server came equipped code checking. We currently use SQL Enlight to ensure that our code meets certain standards.

Relational database: I think it's the best one in the market, at the moment

Integration with tools like Visual Studio

Business Intelligence

Reporting

OLAP Cubes (Analysis services)

HA & DR (with always-on feature)

Support for json, but "really"

Support for document databases

A better reporting tool

SQL Server is a whole package that usually connects well with other Microsoft products.

SQL Server has a large community of users for tips and advice on SQL programming.

SQL Server works fairly seamlessly with Power BI, Power Query.

One glaring example is importing spreadsheets through SSIS, SQL Server only seems to sample the first few rows and generates errors if larger text cells are further down the rows.

SQL Server tends to be a bit more touchy with database object names than MySQL.

The good - SQL Server has a lot of ways to get at the data, the bad - finding particular settings is often buried in dialogs.