Microsoft SQL Server Reviews

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

MS SQL Server is certainly a competently relational database engine, with reporting service and now R.
Easy to install for small onpremise application.
Easy to administer, easy to backup, easy because it is a Microsoft application.
It is so easy that most of the application today I work on seem to be pulling data from SQL into Excel and or Power BI.
You can start from free version and expand as time goes by.
The management studio take the pain our of scripting, and the online support community most likely have your questions answered with T-SQL scripts for copy and pasting.
If you deciding on an option for an Relational Database system - you should look at this as your most productive option. It allows you to focus on the problem by making the technology easy.

The new the version, the more memory intensive this management studio will become.
Microsoft need to create some more easy to use tool for change control and change tracking.
Backward compatibility - if you used a higher version during development, then it become a pain to use a lower version during production environment.

I can say that Microsoft SQL Server is a popular and widely used relational database management system known for its reliability, performance, and security features. It also offers a comprehensive set of enterprise-level tools and services, making it a suitable option for large-scale data management and business intelligence applications. Additionally, it has a large and active user community, providing extensive resources and support.

some common criticisms of Microsoft SQL Server:Cost: The cost of acquiring and maintaining SQL Server can be high, especially for enterprise-level users.Complexity: SQL Server can be complex to set up and manage, especially for smaller organizations with limited IT resources.Limited platform support: SQL Server runs primarily on Windows operating systems, limiting its compatibility with other platforms.Lack of open-source options: Unlike other database management systems, SQL Server does not have a widely available open-source alternative, which could limit its accessibility for some users.These are just some of the common criticisms of Microsoft SQL Server and may not apply to all users or use cases.

Very easy to implement and integrate with other systems.

MS SQL Server consumes almost all compute resourses

Microsoft SQL Server may be a reliable management tool that has a secure and structured setting for information storage and retrieval. It offers strong options for data manipulation, as well as advanced question optimization, group action process and performance monitoring. The interface is simple to use and also the cryptography language is intuitive, creating it appropriate for each toughened and novice developers.

Microsoft SQL Server may be intricate to configure and maintain, because it calls for an in-intensity understanding of database layout and administration. Additionally, sure functions are simplest to be had with the business enterprise edition, which may be steeply-priced for smaller businesses.

The approach is flexible and long-lasting, however primary and secondary database synchronization still needs to be enhanced. If the primary and secondary databases are out of sync for an extended period of time, the primary database for whatever reason stops responding or behaves erratically. A forced restart or the reconstruction of secondary nodes from backups may be the main solutions to the issue. MS SQL can be an expensive option given that there are many open-source alternatives available on the market that can provide equivalent functionality but certainly lack the benefits I outlined above.

Although the solution is adaptable and durable, synchronization between primary and secondary databases still needs to be improved. For whatever reason, the primary database stops responding or behaves abnormally if the primary and secondary databases become out of sync for a considerable amount of time. The problem may mostly require a forceful reboot or the reconstruction of secondary nodes from backups. Given that there are numerous open-source options on the market that can offer comparable functionality but unquestionably lack the advantages I listed above, MS SQL can be a costly offering.

Microsoft SQL Server is a comprehensive database solution that provides a wide range of features and functionalities. It is user-friendly and has robust security controls, making it easy to manage access for different users and roles. The built-in performance analysis tools are excellent and help administrators optimize performance with ease.

The ease of use could be improved, and the search and filter functionality could be more robust. Additionally, the data connectors are decent, but there is room for improvement.

platform for data management and consultation that is effective and useful.This is a fantastic method to use your data to improve metrics and outcomes. These days, data is the fuel that powers the world, so utilizing that is a terrific idea.Very good; working with SQL Server has thus far been a pleasure. We're quite pleased with its performance and environment, featuring interesting data visualization, along with T-SQL capabilities and Azure connection.

For instance, if you leave off a comma while listing the fields you're requesting, you can get an odd message rather than a syntax error.The thing I dislike the most about it is that occasionally the error messages aren't very clear, leaving you wondering what went wrong.

I find Microsoft SQL Server to be an impressive and user-friendly database management system, offering excellent performance, scalability, and dependability. It is the perfect choice for enterprise applications and has a range of features such as high availability, disaster recovery, and encryption. Additionally, it comes with many tools and services including data warehousing, data mining, and reporting, making it an affordable solution for businesses of all sizes.

One of the least liked aspects of Microsoft SQL Server is its relatively high cost of licensing and maintenance. Additionally, the complexity of its features can require a steep learning curve, which can be difficult for new users.

SQL Server is very easy to deploy. Very fast performance, Backup and restoration is also a simplified Maintain it is not a big task and SQL server is able to Store and retrieve multiple records very fast.

yet not found any such thing as it's a good product.

Security is one of the most important aspects of database software since sensitive information can be stored in databases. SQL Servers are some one of the most secure servers out there so data is safe from hackers.

The scaling aspect of this software is great so whether your business is very small or very large that uses huge amounts of data to be stored, SQL servers can scale and use appropriate resources to handle databases therefore no lagging issues and problems querying databases etc. which makes it extremely fast and efficient.

With the large community that uses SQL Server, you have answers to almost all questions that you may have if you encounter any difficulties setting up or using the software, so troubleshooting is made really easy.

Cost could be an issue as this software could be a bit expensive however with that being said, you definitely will get quality.

Also there might be certain compatibility issues with other non Microsoft software that your company may use so in some cases you might have to switch over to Microsoft softwares in your company depending on what they are.

One of my favorite things about Microsoft SQL Server is the scalability. Whether you are using the free version for a small program running on a local machine or running an entire factory it is the same basic concept of programming and administration. I really appreciated being able to work to have a database software that could grow and expand when I need it too. Additionally the reporting and automation packages that come with it are super powerful. I would absolutely recommend using Microsoft SQL Server as anyone’s data as software

The biggest con in my opinion is that some of the more advanced features for big data analysis and high availability are in the top tier pricing which can be hard for smaller companies to afford. Other than that I have never not been able to solve a problem with Microsoft SQL.

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.

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 has always tried over the years to improve its flagship product, achieving good stability and robustness. For administrators, the management interface is particularly useful and easy to use.
SQL Server has allowed us to manage several databases at the same time from our applications without problems giving the possibility to colleagues to have, for example, always updated sales data.

Unfortunately I must also report the defects and in this case in my opinion the interface for administrators has become too slow in terms of starting in the latest versions.
Sometimes product updates do not install correctly, even if this rarely happens it can create a general disservice almost always in time of need.

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

As a Microsoft SQL Server administrator , i like the community and the support that Microsoft community provides as it has a very powerful knowledge base if i stuck in some problem i just google it and the problem has been resolved in minutes.

Microsoft should increase the performance of few of its products as it is very slow as compared to Oracle and DB2 . And should consider on Monitoring of the databases as database administrator primary objective is to monitor the instances continuously.

Microsoft SQL server is one of the best database management system that provide top rated performance optimisation with SQL queries, below is the list of top highlights:

1. Richness of user interface that provides ease of use with cool features like dock able windows.

2. Intelligence window is prominent feature that saves a lot of development time up to large extent.

3. Code debugging and performance tuning with query flow maps is the best features that assures about code optimisation.

4. Microsoft SQL Server Agent is provided with this software and that runs the automatic jobs in very secure way and later we can track the statements executed.

5. We can filter out the records in SQL Server Agent interface based on our interest.

6. Code snippet manager makes it easy to write high standard code that is perfact for code convention.

7. Most prominent feature is that it can handle large quantities of data, runs automatic jobs with concurrent transactions.

8. At last it's a Microsoft product that provides a belief to users.

I have been using SQL server from version 2012 to 2014 and never troubled with SQL server's performance in any way.

However I feel that error details must long descriptive when statement have some syntax error. Sometime its pathetic when we wants to know the exact error line but is hints the whole block of code instead of exact line number.

Otherwise Its a great product and happy with it.

As a Systems Administrator, MS SQL Server is one of the easiest DBMS you can use from a management perspective. SQL Server Management Studio is a very robust client, and it allows you to configure everything from either the GUI or SQL scripts. No digging into config files, calling apps from command line, etc. User management in SQL server is easy and straight-forward while being EXTREMELY granular. Plus, it easily connects to Active Directory if you so desire.

The software is very reliable. MySQL can have issues during backups, but not SQL Server. Once you get it set up and configured properly (again, not hard to do), you can leave it running for months without encountering problems.

While SQL Server is by no means cheap, compared to the other enterprise-level DBMS like Oracle, it's quite reasonable. MySQL is free, but it's quite limited when you do a feature-by-feature comparison with SQL Server.

If you're on the fence, install an Express instance (up to 10GB databases with some limitations). You won't be disappointed.

Like a lot of other Microsoft software, the installer is pretty bloated with prerequisites, components, etc. But that's a fairly small nitpick.

I will also say that RAM management in SQL Server isn't perfect. SQL will, as long as it is regularly used, consume all of the RAM you have allocated it. By default, that setting is 2 petabytes of RAM, so it will slow your system to an absolute crawl, consuming everything it can to the detriment of the OS itself. This means you need to manually allocated a reasonable amount of RAM to SQL knowing full-well that it will likely consume this RAM at all times. That's fine for dedicated database servers, but it's not ideal for people running SQL on laptops.

Aside from that, I have very few complaints about SQL Server.

SQL Server is just so incredibly powerful, most users probably do not know how much it can do, or how much it can handle. In our type of organization, we deal with people and animals. We rely on donors and members for funding, we track everything about our animals from health issues, to medications, to physical exercise. Every one of our systems relies on, as the backbone, SQL Server. This software is powerful, versatile, and reliable. With pretty much every department of ours needing some type of database, standardizing to SQL Server was just the best move. It can handle it all. It can track it all. And it can report on it all for us. To date, we use it for: our Accounting software, our donor tracking, our membership tracking, our animal tracking (includes tracking from what zoo or aquarium animals came, their medical history, their exercise history, their diet, their location in our facility, their trainers, their behavioral issues/environmental factors), our vet's digital imaging systems, our guest services scheduling, our security systems (surveillance, door locks), our water quality and hvac sysytems logging and controls, our point of sale system (for admissions and food court and ecommerce), and our facility management software (maintenance and IT requests). This system does indeed handle everything we need it to.

You need a lot of training to make the most of it. Or it could cost you a lot if you have to pay a developer to help you get the most out of your systems. Luckily a couple of us are really into databases, and we both have a lot of experience with SQL, we can do most things in-house. But still the amount of training we go through to keep current, or to keep learning is probably the biggest "problem" with this software. Most software packages, you can buy, setup, receive a few hours or a few days of training, and you'll be good to go. With SQL, if you intend to use it, to get the most of out it, you will need more extensive training, or to hire people to put in the work. It's not cheap. But it can help you accomplish so much if you put in the time.

Can be integrated with a lot of MS and 3rd party tools.The query window is well formed.The speed of the DB is excellent, but bases heavily on your custom codes.Reports, ad-hoc table, integrations with other reporting tools, intranet websites are great.

Less training options available comparing it to other MS tools.Intergration, access management can be difficult.Sometimes not easy to track changes in your codes, mostly in big databases.Installation could be easier.It not recommended, but for IT personnel with solid knowledge.

SQL Server allows users to setup up a database with different features, from basic database to a complex environment that can include partitions, replication, business intelligence, reporting, etc. Is really simple to deploy on different scenarios like on-premise or cloud. Regarding SQL Language - Transact SQL - it is simpler and easier than other languages. For beginners this could be something positive because of the velocity of the learning curve. The integration with the business process is really easy when working with other Microsoft technologies. Additionally there is an interesting feature called FileTables which allows see the storage as a table. SQL Azure database is something great, an scalable database service that can me managed with Management Studio tool and created in less than a minute.

Something that could be an improvement to MS SQL is related to the performance monitor. In general all databases require to have a relative high level of expertise to create a good database design. With a simpler performance tool, junior users could create better queries, indexes, model, etc...

• Microsoft SQL Server is the best RDBMS package I have ever worked on! (Other DBs I have used are - Oracle, Teradata, MySQL, and Redshift)
• Just like other Microsoft products; SQL Server is by far the most User-friendly Database Server - best IDE
• Lots of wizard features from import, export, backup, query builder etc that anyone can easily learn and do just with few clicks!
• Intellisense (like visual studio) to complete code while typing and showing common mistakes before you even execute
• Built-in execution plan viewer which is nice enough to start with.
• Free Plugins and third-party tools available to make your life even easier like: Poorman SQL Formatter, SentryOne Plan Explorer etc
• Integrates very well with other MS products. Full MS BI stack includes SSIS ETL, SSRS BI Tool, SSAS etc.

• No considerable cons. Maybe Microsoft should consider offering built-in features/tools for which developers use third-party tools and plugins. Like builtin execution plan viewer is not as great as SentryOne Plan Explorer.
• With so many built-in features one little must have to include is One click code indentation. Until Microsoft can add this feature, we can live with Poorman SQL formatter.

Relationship database is structured database management that create with data integrity and reliability in mind.

Slow performance with big data load requirements.
Also physically need to build primary keys for each tables instance.

This software offers a lot of features that are very handy to work with. And frankly it took very less time to understand this software and get used to it. I have used this software for creating stored procedures, functions, views, database schema.
Easy to connect with external database as well. I have heavily used the SQL profiler which again is a very useful feature. SQL profiler let you see the request that SQL receive from a source and it help you debug your code. Generating backup, restoring backup, importing and exporting data tiers all features are so easy to understand. Even I never googled to know how to do it, I just saw the option and start following the instructions and it's done. Its easy to use and all its features are very useful. Even when you didn't saved your file and accidentally your laptop got off,it help recover your files. Easy interface to create database tables even if you do not remember the script syntax.

There is nothing that I don't like kind of this with this useful software.
Its just if the edit rows option could have been made easy by auto showing the SQL pane to write query while editing the rows. I found it one step extra. It should be like when we select rows. Also running the query on edit rows if could be done via f5 only, then it would be easier for the user.