SQL server is great, because i can use the same language same application, and for small customers it uses free option, and only for best performnace or bigger data need to pay for it Can use it locally on on cloud

SQL Server is a great system to develop databases with great functionalities like jobs, procedures, functions ans so one

For me the only think not so good is performance for bigger batabases, but for me between 10GiB and 15GiB works fine

SQL Server allows a large number of accesses without affecting performance. Once switched, there are no performance issues. Many users and developers have stated that the process is faster and more convenient thanks to the application. Access is used for the database and this has led to slow performance when the number of data increases. Large amounts of data sometimes require slow operations.

SQL Server is the enterprise system database, and its toolset is provided as standard. Many departments in the company use it as a database when creating a small system. Its graphical user interface is easy to use even for beginners, and its data can be queried seamlessly from other Microsoft products such as Access.

The application has very few bugs and offers stable operation. The core elements of the product's usability remain the same despite repeated changes. Both the cost and feature set of Oracle is superior to NetSuite.

Microsoft SQL Server software has many facets, more positive than negative. But it is undoubtedly one of the favorites of web developers and internet marketers. Since it is ideal for database management and has warranty. On the other hand you can have many tools to optimize its operation, which you can equate to multiple useful guides provided by the same company.

Is quite secure, it guarantees the security of the databases, it is very easy to configure unlike other database management programs, the installation and configuration is easier. And it also has data recovery support.

Cost, there is a free version that can be used, however for more advanced data-driven applications and functions, you will need to make a considerable investment in higher versions of the software. Also, additional investments in Microsoft software may be necessary if your company uses some or no Microsoft infrastructure.

It supports RDBMS, so it is easy to write SQL queries in SQL Server. User Interface is very good and its easy to implement. It can handle large amount of data. You can mask the data if it contains sensitive or PII information. By Implementing Disaster recovery, at any point in time we can recover the data.

Unlike Databricks SQL, SQL server does not provide data visualization functionality. Data Extraction is show if the table contains large amount of data.

Whenever I need to rely on a robust DBMS for any of my platforms, provided that my clients have the financial muscle to support it, I always recommend going with SQL Server. So, in that sense, I can say that my overall experience is remarkable all over the years I have been deploying solutions backed up by this Database System.

Among the most interesting features of Microsoft SQL Server we can disclose the following: Robust & Secure System Easy to Deploy Performance+ Integration with Public Cloud such as Microsoft Azure

As many of Microsoft Premium products, SQL Server license is really expensive.

What I like best about SQL Server is that it is designed for high performance and scalability, so it can handle large volumes of data and support intensive workloads. In addition, it can adapt to growing business environments and provide rapid responses to queries, which is especially important in real-time critical applications.

SQL Server license costs can be high, especially for more advanced editions such as SQL Server Enterprise Edition. Additionally, additional licenses may be required for specific features and services, which could further increase the total cost.

At the moment we have no negative features to add to the product

How safe this database engine can be, its integration with other technological tools, say, programming languages, infrastructure, datawarehouse and more

A bit the price, since the enterprise license is a bit expensive

I would recommend it to all low-scale and small organizations that are already using MS Office products or subscriptions. Its interface is similar to learn and use like other Microsoft software. Enterprise and large corporates can look into Oracle services if they require specific Oracle-made enterprise functions and features to handle very complex data.

First and foremost, it has all the features and functionality from the basics to advanced users for relational database management. Can be integrated well with other Microsft software especially Visual Studio code for a smooth development experience. Along with data storage management, professional performance analysis can be performed through GUI server management studio tools like Database Tuning Advisor. Data Analysts will find data extraction and filtration as well as visual & interactive report generation quite beneficial in their routine tasks. Backup and restore from one SQL server to another is fairly simple. Pricing is very reasonable according to the DBMS system and tools that are provided.

One of the main issues is that licensing price packages are difficult to choose due to confing choices for common users. One other limitation is that a backup made in a newer version of MS SQL server is not compatible with an older version of SQL Server. For large volumes of data records and for complex data it becomes slower to process queries. Taking backup of a very large number of records also takes time. Sometimes difficult to debug syntax errors.

Programming languages ​​are unique in everything, but SQL is unique in all aspects. I like it very much

Easy to adapt to prolonged use and all people interested in getting into the world of programming and development can learn

Some overlapping commands or instructions require some concentration and do not require a long time, but they are the most complex thing during learning

Overall experience is just amazing. I have been using it for almost 2 years and it helped my organization a lot during release upgrade and it made database migrations so smooth.

Microsoft SQL is quite simple to install and configurations are also easy. As it is a relational database management system, it is a perfect tool for data analysts. As it enable users to filter and extract required data in a few seconds. The product comes with a lot of features like Query analyzer, Integration services, Job scheduler and Reporting services as well. Restoration and backup of multiple databases is a great advantage and I found this feature very useful because it helps a lot in restoring databases in case of any disaster. Also, one can easily schedule tasks in job tools section which is also a very helpful feature of this tool.

Well, it occupies more data storage in order to install database engine as compared to other SQL databases. Also, support is pretty much expensive and requires a lot of maintenance. It consumes too much resources to load and start.

For any developer, before first they can this own what their apps are going to be developed in their should think of what server should host their database. I do believe that MS SQL Server is the best on the marketing when comes to data management and administration. The best feature that i really love the most on MS SQL Server is the ability to disable remote execution of your queries and really helps protect data integrity in case your server authentication has been compromised. You can also be rest assured that your data is consistent and accurate at all times. Yes hackers some times can try sql injection but i believe MS SQL Server its the most secure servers around.

The license key for MS SQL might cost you an arm and a leg but at the end of the day its really worth it when you think of a platform where you are able to develop enterprise apps that secure and helps with Business Intelligence.

What I liked the most is that Microsoft SQL server offers a "free specialized edition" which I used to test what they actually offered and how good it was.

Great features, cross-platform, well equiped, a good search/filter system, data secured, and the permissions system seemed pretty secure.

The pricing is somewhat high, and it would run slow sometimes for no reasons, something that reports and analytics wouldn't show.

Once SQL Server in Azure was selected, it proved to be a great experience. Security, performance and usability was ironed out for us already. We could focus on building our application rather than learning something new about cloud security or how to use a new type of database or database language variation. We have been pleased with the ability to research performance and include other features such as SSIS to accomplish our business requirements easily. Knowing that manual tasks are being completed automatically is a sigh of relief. We also will know immediately if there are any issues. We have had a great experience with SQL Server.

It is an industry standard that continues to improve to make the lives of developers easier. We are able to produce software solutions more efficiently because Microsoft continues to improve SQL Server. We rely heavily on this as critical to our business. Developers tell me how flexible SQL Server is also. SQL is more compatible with software packages than other competing databases.

Parts can be not intuitive unless you've been using it for awhile. It is a technical piece of software that requires time and training. If you need the Enterprise edition for specific features, it is expensive.

We have enjoyed using SQL Server for various OLTP and data warehousing workloads. It is a workhorse. Its performance is fantastic. Tooling surrounding it is great. We have not encountered a single issue with it. We also have a great local meetup where we discuss the constant improvements SQL Server brings each year.

We love SQL Server's versatility. Every single application we purchase for insurance has support for SQL Server. We have not come across any situation where SQL Server didn't meet our needs.

License models are a bit confusing. Some years Microsoft make it easy to understand. Other years Microsoft makes it even more confusing. Can we run SQL Server in our data centers? Can we run it on the cloud? Do we need to change licensing to run in the cloud? Those questions sound easy to answer but the answers we get from Microsoft or resellers confuse us more. It just seems like the confusion is intentional.

I have 5 years working with Microsoft SQL Server, I have adapted well, I like the functionality it has, the practical way in which you can perform queries, scheduled tasks for my daily and weekly backups are excellent, accompanied by the crystal report, works great, I tried to try other database managers like ORACLE, but I think it is better Microsoft SQL server, to this day, I prefer to work with it.

Personally, I like that the application is easy to use, obviously if you already have time using it and you are familiar with the concepts and terms used, the tools to create backups or schedule tasks to run on specific dates and times is quite good, the price is affordable not too expensive unlike oracle.

to install it is a bit time consuming, since you have to configure it on the fly, it does not bring any preconfigured default settings, this takes a little time to the user, to migrate to other operating systems other than windows, you have to make other extra configurations.

Microsoft SQL Server is a great data management, analyzing and reporting tool which helps in day to day running of a business. The very powerful features it posses makes data analysis easy. The community support makes it easy to do many tasks and above all, the security this tool provides makes it safer than other database management tools

The ability to store, manage , retrieve and backup large amounts of data without so much hassle. The availability of support on the internet is just amazing. It works well for small sized to big sized companies and the security of these databases is top notch. Since it has recently been integrated with Azure, it will be easier for cloud deployment and cloud support. Can also be used be as a reporting and analyzing tool.

The cost is a bit high and it requires skill to be able to work with sql. The larger the information on the database usually makes it to slow down in terms of querying it

I am using SQL Server for 4 years in a Low, Medium and Big environment, but in low environment i have a bad experience using SQL SERVER, Mysql is better in a small busines for cost, and simplicity, but in Big environment SQL SERVER can compete with ORACLE DB.

Is powerfull Easy Complete Customer Support Features interoperatibity

Have some errors You need to reset de SQL 1 time at week Consumes a lot of ram it needs a Windows Server

It has been awsome as i am now a good Database developer because of this awsome tool.

I am not DBA but i am using it from more than 3 years from university days and still using SQL in my professional life. I like everything about from query writing, to testing using SQL profiler. Most about it is that you can do most thing by using queries and GUI as well. Its easy to connect and configure with any kind of application with single line of code. Most thing about it is its prediction while typing and highlighting errors with underline squiggly.

As a developer i cant find anything that i dont like in it. Its always more than my expectations.

Overall, I have had an excellent experience with SQL Server. It is cost-effective, provides a great deal of functionality, and is a great piece of software for database management.

In my current role as an Application Manager, it is vital to have a means of benchmarking and assessing application performance. The tools within SQL Server, particularly Activity Monitor, make it very easy to determine when performance bottlenecks arise.

I believe the default alerting functionality could be improved. For example, I believe it would make more sense to alert the user to any failed SQL Agent jobs when launching SSMS. Currently, either alerts need to be set up individually or the user would need to view the job history.

Even when some people argue that is not the most fastest database for me is the most useful and with more tools than most, almost all databases has store procedure, functions, etc. but one thing that SQL Server has that most don't is the ability to create your own type of data, I mostly prefer to use Table type so I can insert a lot data in one single transition without using a loop condition to validate The source manager allos to see the type the query and from what machine is been executed

you need to use the installer every time you need to create a new instance, if the server is down and you restar the services, you need to open the sql magnament to restart the jobs as well

Our overall experience with SQL Server has been formidable. This is the reason that it has been at the center of our business since we outgrew an Access central database over 20 years ago.

Installation and upgrading of the software is excellent. The additions of Query Store and other Analytics have drastically changed our ability to monitor the performance of all metrics of our Databases.

Turn around time from issuing the Purchase Order until the license is released into our Microsoft account was rather slow, when we needed the software, we had to find an alternative solution until our license was released to us.

I have worked with SQL Server for 20 years now. It is used on the backend of many powerful products and also used for small web sites as well. It's very easy to connect to and to link to non-Microsoft database systems. TSQL is very powerful as it has all standard SQL functions as well as its own.

The express edition, which is free, is more than powerful enough to serve as a back-end for most small/medium sized web sites which is great for small businesses to start and grow.

Installation of all the features can be a pain. Making sure you have the engine, agent, management studio can be confusing and often come in separate download packages.

Overall experience with SQL server 2016 is very nice and excited in my perceptions due to Better support for memory optimzed tables, Built in JSON support, Stretch DB concepts, Query Store and dynamic temp db according to size and presence of CPU in the databases.

In our project we have been migrated from Microsoft SQL Server 2008 to SQL server 2016 directly for all our databases & SSIS packages. There are many features that was available to use for the projects and some of those are: 1. Data was always encrypted, so less vulnerable to SQL injections and useful to take a backup when database is in motion. Prior version (Before SQL server 2016) support only when databases is in Rest. 2. Data/Software Migration is very useful from prior version without any issues or taking any time. It took only set of testing activities and 2 hours of trun around time to get it upgraded. 3. Very simillar like XML TSQL clause created in SQL 2005, in SQL 2016 JSON clause T-SQL has been created for JSON output from querying database objects. 4. In prior versions we have to wait for long running query to capture, however in SQL server 2016 ability to view the execution plan as the query is active on the system. 5. Strecth Database is a new concept that has been created and stored in Azure. However in the background it is shown as single databases for user views.

Only I know very least number of disadvantages this MS SQL server 2016 is having: 1. Enterprise pricing may be costly as some of the organisation cant afford for the count of data they are having. 2 With the performance tuning, Microsoft SQL Server will be having some gobble resources.

I use SQL Server since it was obtained by Microsoft. I am specialized on it and I work only in projects where it is used as core technologie. I am a very experienced architect and developer, based on SQL Server And Microsoft BI.

It is easy to install. There is also a free Express Edition / Localdb, which has most features of the paid Version. The developer Edition has all Features of the Enterprise Edition. It is very easy to install even several instances on any system. I can solve nearly all tasks, I feel very confident. The documentation is great and it is easy to find answers to questions. It is just my every day tool.

If there are some heavy queries then the whole instance gets down, often even other instances on the same system. I don't understand why it is not possible to limit the effect. Many features which I would like to use are only available in the enterprise edition. But this edition cost much more than standard and I am forced to use only features of the standard edition. Often I am forced to use quite old version, for example 2016, but the current version is 2019. Again the reason is the price. Customers would need to spent more money for the latest version, therfore they force me to develop based on old versions.