Microsoft SQL Server

Relationales Datenbankmanagementsystem für die Datenanalyse

Gesamtbewertung

4,6 /5
(1.885)
Preis-Leistungs-Verhältnis
4,3/5
Funktionen
4,6/5
Bedienkomfort
4,3/5
Kundenbetreuung
4,3/5

97%
haben diese Anwendung empfohlen
Sortieren nach

1885 Bewertungen

Luca
Gesamtbewertung
  • Branche: Computer-Hardware
  • Unternehmensgröße: 501–1.000 Mitarbeiter
  • Wöchentlich für Mehr als 1 Jahr genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Weiterempfehlungsquote 10.0 /10

Mssql

Bewertet am 29.8.2023

Vorteile

Die simpel gespaltene Oberfläche, die gute Zugriffsrechte Verteilung

Nachteile

Die Installation, da diese im vergleich zu anderen Anbietern lange dauert

Kudakwashe
Gesamtbewertung
  • Branche: Informationstechnologie & -dienste
  • Unternehmensgröße: 11–50 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 9.0 /10

Data Management made so easy with MS SQL Server

Bewertet am 20.3.2020

Vorteile

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.

Nachteile

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.

In Betracht gezogene Alternativen

Oracle Database

Gründe für den Wechsel zu Microsoft SQL Server

In the case of Oracle DB vs MS SQL Server, MS SQL Server is easy to manage, easy to configure and has a huge community in case when you are stuck with any problem you are guaranteed to get a solution online.
Guillermo
Gesamtbewertung
  • Branche: Marketing & Werbung
  • Unternehmensgröße: 2–10 Mitarbeiter
  • Wöchentlich für Mehr als 1 Jahr genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 7.0 /10

A good choice as a database manager, but it can be improved.

Bewertet am 9.11.2022

It is good software, as I mentioned before. It syncs well with other Microsoft tools. In almost 2...

It is good software, as I mentioned before. It syncs well with other Microsoft tools. In almost 2 years of use, I feel comfortable when working with this software. I hope that the improvements I mention in the negative points will be included. Otherwise excellent.

Vorteile

I like that it allows me to use my Windows login credentials as user authentication to connect to the server. Plus it integrates easily with other Microsoft programs such as Visual Studio 2022, Business Intelligence tools, etc. I am a Software Engineering student, and I have been testing many database managers. Of all the ones I have used Microsoft SQL Server is the easiest to install and very intuitive regarding the use of its tools. In addition to being a student, I give small tutorials on how to use the software, such as tips for new users, and database backup.

Nachteile

I don't have much to criticize in this space. For me, the Software is very complete. But if I would like you to implement a dark theme throughout the interface, it would be very helpful to rest your eyes and avoid fatigue after hours of work.

Sergio R
Gesamtbewertung
  • Branche: Internet
  • Unternehmensgröße: Selbstständig
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 7.0 /10

Good RDBMS

Bewertet am 25.6.2022

Vorteile

Very easy to implement and integrate with other systems.

Nachteile

MS SQL Server consumes almost all compute resourses

Abdirizak Mohamed
Gesamtbewertung
  • Branche: Design
  • Unternehmensgröße: 11–50 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 10.0 /10

Streamlining My Data Management Tasks with Microsoft SQL Server

Bewertet am 30.6.2023

My overall experience with Microsoft SQL Server has been very positive. As a student, the platform...

My overall experience with Microsoft SQL Server has been very positive. As a student, the platform has helped me to manage and analyze data more efficiently and effectively, which has been invaluable in my studies. While there are some potential downsides to consider, such as cost and a potential learning curve, I believe that the benefits of the platform far outweigh any potential drawbacks. I would highly recommend Microsoft SQL Server to any student or organization looking for a powerful and versatile tool for managing data.

Vorteile

As a student, I have found Microsoft SQL Server to be an incredibly powerful and versatile tool for managing data. One of the things I appreciate most about the platform is its ease of use. The interface is user-friendly and intuitive, which has made it easy for me to quickly learn and navigate the various features.I also appreciate the platform's robust set of tools for managing data, including its ability to handle large amounts of data and its support for a wide range of data types. The platform's integration with other Microsoft products, such as Excel and Power BI, has also been a game-changer, making it easy for me to analyze and visualize data.

Nachteile

One of the potential downsides of Microsoft SQL Server is its cost. While the platform offers a lot of value for businesses and organizations that need to manage large amounts of data, the cost can be prohibitive for individuals or smaller businesses with limited budgets.Another potential drawback is the learning curve involved in getting started with the platform. While the interface is generally intuitive, there are a lot of features to learn, and it can take some time to become proficient in using the platform to its full potential.

Vinicius
Gesamtbewertung
  • Branche: Informationstechnologie & -dienste
  • Unternehmensgröße: 2–10 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 8.0 /10

Review for Microsoft SQL Server

Bewertet am 17.1.2023

SQL Server is my main RDBMS for Windows environments because it has a wide range of features and is...

SQL Server is my main RDBMS for Windows environments because it has a wide range of features and is completely compatible with the operating system since it runs on its native platform.

Vorteile

Easy to install, configure, update and use. Through tools such as SQL Server Management Studio (SSMS) the system has a very friendly graphical user interface. SQL Server has extensive documentation on the Internet.

Nachteile

Full installation takes up a lot of disk space. Depending on the version, the software license can be very expensive.

In Betracht gezogene Alternativen

Oracle Database

Gründe für den Wechsel zu Microsoft SQL Server

Compatibility with the operating system and its features.
Verifizierter Rezensent
Gesamtbewertung
  • Branche: Gewerbeimmobilien
  • Unternehmensgröße: 201–500 Mitarbeiter
  • Täglich für 6-12 Monate genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 7.0 /10

Relation Database Management

Bewertet am 1.5.2023

The availability of server editions and the Microsoft premium support where you will get access to...

The availability of server editions and the Microsoft premium support where you will get access to premium support with Microsoft skilled specialist.The SQL server also supports for use on Linux

Vorteile

The Microsoft SQL server editions available like enterprise, standard, web, developer for basic data management and business intelligence features and SQL server components availability was the most advantage of using SQL server

Nachteile

The enterprise edition was more expensive for per core licence it is around $14,200.

Verifizierter Rezensent
Gesamtbewertung
  • Branche: Industrieautomation
  • Unternehmensgröße: 501–1.000 Mitarbeiter
  • Wöchentlich für Mehr als 1 Jahr genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 8.0 /10

Enterprise DBMS

Bewertet am 9.2.2023

Vorteile

We had to migrate our free databases to SQL server because we reached many gigabytes in a few tables and needed a fast and reliable software to handle it and integrate with some BI products. Microsoft SQL Server had no issues and works really fine.

Nachteile

License costs are major issues , but any other paid database costs about the same. It is still a bit overkill for us but we are looking at using it in the cloud as a PaaS.

In Betracht gezogene Alternativen

Oracle Database

Warum Microsoft SQL Server gewählt wurde

Very big tables and need to consolidate databases to integrate with BI

Zuvor genutzte Software

MariaDB
Olivier
Gesamtbewertung
  • Branche: Informationstechnologie & -dienste
  • Unternehmensgröße: 51–200 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 9.0 /10

The default database for Windows development

Bewertet am 9.11.2022

This is the base storage for many of our applications, allowing to handle millions of rows without...

This is the base storage for many of our applications, allowing to handle millions of rows without a single failure.

Vorteile

This is the database that I grew up with, and it's never disappointed me over all these years.It keeps compatibility between versions and has a nice documentation about migrating.

Nachteile

There has been situations where we hit a roadblock and the documentation for it was a bit lacking.

In Betracht gezogene Alternativen

Oracle Database und SQLite

Gründe für den Wechsel zu Microsoft SQL Server

This is the one our client are used to, and it's tightly integrated with Active Directory
Edward
Gesamtbewertung
  • Branche: Bankwesen
  • Unternehmensgröße: 10.000+ Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 10.0 /10

SQL Server Review

Bewertet am 14.1.2023

I have used every version since 6.5 and all releases have been solid and each subsequent release...

I have used every version since 6.5 and all releases have been solid and each subsequent release showed improvements.

Vorteile

It has been the same core components since 6.5, but the new features are very good.

Nachteile

Some of the alerts provided by Microsoft are not always intuitive or clear

In Betracht gezogene Alternativen

Oracle Database

Gründe für den Wechsel zu Microsoft SQL Server

Integration with existing Microsoft infrastructure
Beatriz
Gesamtbewertung
  • Branche: Automotive
  • Unternehmensgröße: 1.001–5.000 Mitarbeiter
  • Täglich für 1-5 Monate genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Weiterempfehlungsquote 8.0 /10

SQL Server Review

Bewertet am 7.9.2023

Vorteile

the performance of the SQL server is outstanding, aswell the security that it offers due to the features, including data encryption, access control, etc.

Nachteile

SQL server is expensive edpecially for enterprise editions. It is complex to learn so the learning curve will be steep for begginers.

Andy
Gesamtbewertung
  • Branche: Telekommunikation
  • Unternehmensgröße: 10.000+ Mitarbeiter
  • Täglich für Mehr als 1 Jahr genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 9.0 /10

Microsoft products are usually stable and reliable.

Bewertet am 3.9.2022

SQL Server allows a large number of accesses without affecting performance. Once switched, there...

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.

Vorteile

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.

Nachteile

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.

Brenten
Gesamtbewertung
  • Branche: Fluggesellschaften/Luftfahrt
  • Unternehmensgröße: 10.000+ Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Weiterempfehlungsquote 10.0 /10

Powerful and Scalable Database Software

Bewertet am 28.10.2020

Storing large quantities of production data to solve quality and efficiency problems has been a big...

Storing large quantities of production data to solve quality and efficiency problems has been a big use for SQL. All of the reporting and power to analyze data has solved countless puzzles for me in my job capacity. I also have done a lot of database administration for our ERP software and the tiles to tune and optimize have always been very helpful.

Vorteile

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

Nachteile

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.

Masoud
Gesamtbewertung
  • Branche: Einzelhandel
  • Unternehmensgröße: 2–10 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 10.0 /10

A database system that you can trust your data with!

Bewertet am 10.3.2022

I believe we rely on Microsoft SQL Server and its great features and performance a lot. It's our...

I believe we rely on Microsoft SQL Server and its great features and performance a lot. It's our first choice in terms of an RDBMS database and I believe it remains as such for a long time.

Vorteile

I've been using Microsoft SQL Server since version 2000 and I must say that every year the team behind it adds tons of improvements and great new features that keep this software a fantastic competitor in the market.
The database engine is very clever in optimising your queries, giving insights on improvements and dealing with your complex queries.
Microsoft's TSQL is very easy to understand and very easy to grasp even though in recent years the team have introduced more complex query templates but still it stands out impressively amongst the others.
I also love that they have released the full version as a Developer version where you can try all the software's great features without any cost at all!

Nachteile

The huge cost difference between the Standard and the Enterprise version is a put off as certain features like table partitioning should be part of the Standard version.

Jonathan Alexander
Gesamtbewertung
  • Branche: Krankenhausversorgung & Gesundheitswesen
  • Unternehmensgröße: 1.001–5.000 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 9.0 /10

A robust database engine with high information security standards.

Bewertet am 25.5.2022

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

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

Vorteile

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

Nachteile

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

In Betracht gezogene Alternativen

Oracle Database

Warum Microsoft SQL Server gewählt wurde

We needed a more robust database engine due to the growth of the company and the processes that are currently being handled, plus the integrations with different platforms.

Gründe für den Wechsel zu Microsoft SQL Server

We needed a more robust database engine due to the growth of the company and the processes that are currently being handled, plus the integrations with different platforms.
Mir Fida
Gesamtbewertung
  • Branche: Informationstechnologie & -dienste
  • Unternehmensgröße: 2–10 Mitarbeiter
  • Weitere für Mehr als 1 Jahr genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 9.0 /10

Best database management tool for relational databases

Bewertet am 11.8.2021

I would recommend it to all low-scale and small organizations that are already using MS Office...

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.

Vorteile

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.

Nachteile

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.

In Betracht gezogene Alternativen

Oracle Data Management Platform

Gründe für den Wechsel zu Microsoft SQL Server

We decided to use an MS SQL server as it suits our needs in pricing, features, and performance. Also, it is easier to use for development teams that are already using Microsoft products like MS Office. Students should also use it to learn the basics of SQL through a GUI environment. Oracle database service is more expensive due to the fact it handles complex & large-scale enterprise data. We did not require those enterprise features.
Quentin
Gesamtbewertung
  • Branche: Computer-Software
  • Unternehmensgröße: 2–10 Mitarbeiter
  • Wöchentlich für Mehr als 1 Jahr genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 9.0 /10

This sequel is better

Bewertet am 7.10.2019

Once SQL Server in Azure was selected, it proved to be a great experience. Security, performance...

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.

Vorteile

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.

Nachteile

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.

In Betracht gezogene Alternativen

MongoDB

Gründe für den Wechsel zu Microsoft SQL Server

We needed a back-end database for our new product. We had an AngularJS front end and needed a fast, efficient relational database. We wanted an industry standard that would be supported for many years going forward. We also needed reliability of a database that would meet our needs while continuing to improve in the future. SQL also has great support, user forums, groups, and 3rd party consultants. Many resources are available to us as we build our new solution and have questions. SQL Server in the cloud was a perfect fit for our organization which already used MS Azure.
Paolo
Gesamtbewertung
  • Branche: Elektrische/elektronische Fertigung
  • Unternehmensgröße: 51–200 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Bedienkomfort
  • Weiterempfehlungsquote 10.0 /10

The quintessential database server

Bewertet am 25.5.2022

From the administrative point of view, database management is certainly more efficient than in the...

From the administrative point of view, database management is certainly more efficient than in the past, I must say that in some cases we have been able to solve particular data extractions that without the use of the T-SQL language we would not have been able.

Vorteile

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.

Nachteile

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.

Gonzalo
Gesamtbewertung
  • Branche: Industrieautomation
  • Unternehmensgröße: 11–50 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 8.0 /10

Good for medium and big companies

Bewertet am 21.8.2019

I am using SQL Server for 4 years in a Low, Medium and Big environment, but in low environment i...

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.

Vorteile

Is powerfull
Easy
Complete
Customer Support
Features
interoperatibity

Nachteile

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

Umar
Gesamtbewertung
  • Branche: Computer-Software
  • Unternehmensgröße: 11–50 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 10.0 /10

My Database Engine

Bewertet am 18.6.2019

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

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

Vorteile

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.

Nachteile

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

Jerry
Gesamtbewertung
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 10.0 /10

Ridiculously powerful and full of features we do not make use of. We love it, and cannot do...

Bewertet am 2.7.2018

This software practically runs our facility. Without it, we couldn't keep track of our animals or...

This software practically runs our facility. Without it, we couldn't keep track of our animals or our people (staff, members, donors). To us, this software is well worth the costs involved.

Vorteile

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.

Nachteile

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.

Rony
Gesamtbewertung
  • Branche: Informationstechnologie & -dienste
  • Unternehmensgröße: 11–50 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 9.0 /10

Powerhouse of Data Management

Bewertet am 23.6.2023

My overall experience with Microsoft SQL Server has been highly positive. The platform's robustness...

My overall experience with Microsoft SQL Server has been highly positive. The platform's robustness and scalability have empowered us to efficiently manage and analyze our data. The advanced query optimization and indexing capabilities have ensured optimal performance for our applications. The seamless integration with other Microsoft tools and technologies has enhanced our productivity and workflow. While there were some areas for improvement, such as the learning curve and occasional performance issues, Microsoft SQL Server remains a reliable and powerful solution for data management. It has been instrumental in helping us unlock valuable insights and make data-driven decisions.

Vorteile

Microsoft SQL Server impressed me with its standout features that revolutionized our data management experience. The robustness and scalability of the platform allowed us to handle large volumes of data with ease. The advanced query optimization and indexing capabilities ensured optimal performance and fast retrieval of information. The comprehensive security measures instilled confidence in the protection of our data assets. The seamless integration with other Microsoft tools and technologies enhanced our overall productivity. Microsoft SQL Server has become an indispensable tool, empowering us to effectively store, manage, and analyze our data.

Nachteile

While Microsoft SQL Server offers powerful data management capabilities, there were a few aspects that left room for improvement. One drawback was the complexity of the platform, which required a steep learning curve and technical expertise. The licensing costs, especially for enterprise editions, might be a limiting factor for smaller organizations. Occasionally, the platform's performance could be affected when handling extremely large datasets. The documentation, while extensive, could benefit from more detailed examples and tutorials for complex scenarios. Despite these limitations, Microsoft SQL Server remains a robust and reliable choice for data management, but addressing these areas for improvement would further enhance its usability.

Gábor
Gesamtbewertung
  • Branche: Automotive
  • Unternehmensgröße: 51–200 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 10.0 /10

My past with MS SQL

Bewertet am 25.10.2022

I met firstly with MS SQL in the uni. The in one of my workplaces I became an admin of it, so as a...

I met firstly with MS SQL in the uni. The in one of my workplaces I became an admin of it, so as a "user".Its two sides-role widely different. Writing queries, retrieving data, manipulating the results (not the stored data) is a cool option. Easier, faster, more known then Oracle's PL/SQL I would say. The option it gives you are enormous, and how many things uses a DB nowadays are surprising. Knowing and being able to manage a DB, will be an asset in the future. Speed depends on your codes and on your machine. The memory is the enemy of the DBs, so as for MS SQL. Maybe other, non-relational DBs have better results, but on specific tasks. MS SQL is being better, has a lot of devs. behind its back and MS itself, you definitely worth considering it having as a primary database. 3rd party extensions can be used, that can take your productivity to the next level, like APEX.Having a free version up to 10 gigs per database, you would not believe how many company based its business on this "advantage".

Vorteile

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.

Nachteile

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.

Gabriel
Gesamtbewertung
  • Branche: Fluggesellschaften/Luftfahrt
  • Unternehmensgröße: 2–10 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 8.0 /10

A database for every level of user expertise

Bewertet am 16.1.2021

Regarding to the cost; licenses are cheaper than others. But when analyzing a database you should...

Regarding to the cost; licenses are cheaper than others. But when analyzing a database you should consider many others variables like administration cost, available resources, expertise of the team, company size, available servers, budget, etc...

Vorteile

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.

Nachteile

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...

Felix
Gesamtbewertung
  • Branche: Finanzdienstleistungen
  • Unternehmensgröße: 10.000+ Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 8.0 /10

Great database for small To medium business

Bewertet am 26.9.2019

I used sql server in the past until cloud based database system like Hadoop and Google cloud are...

I used sql server in the past until cloud based database system like Hadoop and Google cloud are available. this tools is complex and extensive. There are a lot of features and functionalities to create stable and high rated database system like cursor, functions, stored procedures, etc. However, when the data requirements grows exponentially, the system unable to handle the load which takes significant amount of time to query. This is where company looks for better solution to handle big data load using cloud based database. SQL server going to be recognized as the pioneer of database system that set the standard of SQL language for similar products. Perhaps overtime they also evolve with better solutions to handle big data load; something that I have no knowledge about.

Vorteile

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

Nachteile

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