Microsoft SQL Server Erfahrungen

Microsoft SQL Server

Relationales Datenbankmanagementsystem für die Datenanalyse

Gesamtbewertung

4,6 /5
(1 910)
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

1910 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

Filipe
Gesamtbewertung
  • Branche: Informationstechnologie & -dienste
  • Unternehmensgröße: Selbstständig
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

SQL Server review

Bewertet am 10.3.2020

SQL server is great, because i can use the same language same application, and for small customers...

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

Vorteile

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

Nachteile

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

In Betracht gezogene Alternativen

Oracle Database

Warum Microsoft SQL Server gewählt wurde

SQL server is lot less expensive and have a free option for small aplications or for small customers

Zuvor genutzte Software

Oracle Database

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

SQL server is lot less expensive and have a free option for small aplications or for small customers
Imi
Gesamtbewertung
  • Branche: Politische Organisation
  • Unternehmensgröße: 201–500 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 9.0 /10

SQL is getting better as it grows older

Bewertet am 21.11.2019

SQL Server centralized my data and allows my staff to "believe" that they are working in Excel, It...

SQL Server centralized my data and allows my staff to "believe" that they are working in Excel, It is super fast for loading data from the server, and allow large data set that will normally take hours, or even crash the Excel spreadsheet to load without any issue.
When I am ready for a web app.. SQL server is easy as piece to develop a simple CRUD application and push live.
It seem to connect to every thing - from MS Word Mail merge, MS Excel, MS Access and of course for development environment such as Visual Studios.
One Database ( Centralized) and many presentation modes for the end users. I love it!

Vorteile

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.

Nachteile

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.

In Betracht gezogene Alternativen

Oracle Database

Warum Microsoft SQL Server gewählt wurde

Ease of use, Easy to learn, easy to teach easy to integrate with well know tools.

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

Cost and community of supporters, access to information on the open internet . Available of training.
Bruno
Gesamtbewertung
  • Branche: Programmentwicklung
  • Unternehmensgröße: Selbstständig
  • Täglich für 6-12 Monate genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

A Great Start To Database Management

Bewertet am 20.7.2021

Microsoft SQL Server software has many facets, more positive than negative. But it is undoubtedly...

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.

Vorteile

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.

Nachteile

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.

In Betracht gezogene Alternativen

MariaDB

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

Actually, it was my teacher who suggested using this program to evaluate us.
Tychique Le Saint
Gesamtbewertung
  • Branche: Design
  • Unternehmensgröße: Selbstständig
  • Wöchentlich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

My opinion of Microsoft SQL Server

Bewertet am 7.9.2023

Quite simply, my experience with SQl-server is perfect. I've been using it for nearly 2 years and...

Quite simply, my experience with SQl-server is perfect. I've been using it for nearly 2 years and it has helped me a lot in my business intelligence project. It's wonderful to use.

Vorteile

As a relational GBD system, it's the perfect tool for data analysts. It enables users to extract, transform and download the data they need in a matter of seconds.

Nachteile

it requires more data storage to install the DB engine than other SQL DBs.

Sam
Gesamtbewertung
  • Branche: Informationstechnologie & -dienste
  • Unternehmensgröße: Selbstständig
  • Wöchentlich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Bedienkomfort
  • Weiterempfehlungsquote 9.0 /10

Microsoft SQL Server is a powerful database server

Bewertet am 16.11.2023

Vorteile

Microsoft SQL Server offers a powerful platform for managing and organizing large amounts of data effectively.

Nachteile

SQL Server can be complex for beginners or users with limited knowledge of database management systems.

jamie
Gesamtbewertung
  • Branche: Immobilien
  • Unternehmensgröße: Selbstständig
  • Täglich für 1-5 Monate genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

College Students First time around.

Bewertet am 19.10.2023

Overall the experience was has been great.

Overall the experience was has been great.

Vorteile

To start, while taking Introduction to Database in my degree. I was able to use Microsoft SQL server in my course. Microsoft SQL server was a simple to understand for a first timer. Learning the syntax in this environment was very helpful/.

Nachteile

I use a MacPro and Macbook. Having access to Microsoft SQL Server without the need of an Virtual Machine. I understand compatibility of due to the use o a server environment, but it would be cool tho.

Verifizierter Rezensent
Gesamtbewertung
  • Branche: Lebensmittelproduktion
  • Unternehmensgröße: 5 001–10 000 Mitarbeiter
  • Wöchentlich für Mehr als 1 Jahr genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

A software with limitless potential.

Bewertet am 13.11.2023

Vorteile

We have a global monitoring system for our organization and we can monitor performance of individual plants to the level of a single unit. This is an amazing fact

Nachteile

Sometimes the data filters are lost because of so much population on a single page. its a human error but could use some help

Verifizierter Rezensent
Gesamtbewertung
  • Branche: Computer-Software
  • Unternehmensgröße: 10 000+ Mitarbeiter
  • Täglich für 1-5 Monate genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

Reliable & Stable

Bewertet am 27.10.2023

Vorteile

MS SQL server provides a good customer service& open for improvements.It provides a good performance.It has strong user community.

Nachteile

Data sub partitions is not possible.It would be good if we can write to same database located on multiple servers at different data centers as part of Always on availability groups.

Mustafa
Gesamtbewertung
  • Branche: Tiefbau
  • Unternehmensgröße: 51–200 Mitarbeiter
  • Täglich für Kostenlose Testversion genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Bedienkomfort
  • Weiterempfehlungsquote 9.0 /10

Mssql

Bewertet am 16.10.2023

Vorteile

A successful and stable database management software that does its job well.

Nachteile

Resource consumption is high, the 10 GB limit in the express version should be increased.

Rahul
Gesamtbewertung
  • Branche: Schreiben & Editieren
  • Unternehmensgröße: Selbstständig
  • Wöchentlich für 6-12 Monate genutzt
  • Quelle der Bewertung

Gesamtbewertung

  • Bedienkomfort
  • Weiterempfehlungsquote 10.0 /10

it is a good product and recommended to my college it department for their database bakup

Bewertet am 13.10.2023

Vorteile

backup and recovery are the best and i can rely on them with my eyes shut

Nachteile

nothing to complaint , so far its works for me smoothly

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.
juan jose
Gesamtbewertung
  • Branche: Luft- & Raumfahrt
  • Unternehmensgröße: 501–1 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

Microsoft SQL Server for Business

Bewertet am 17.11.2022

I have 5 years working with Microsoft SQL Server, I have adapted well, I like the functionality it...

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.

Vorteile

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.

Nachteile

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.

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

Gesamtbewertung

  • Bedienkomfort
  • Kundenbetreuung
  • Weiterempfehlungsquote 10.0 /10

Microsoft RDBMS Solution

Bewertet am 29.8.2022

Whenever I need to rely on a robust DBMS for any of my platforms, provided that my clients have the...

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.

Vorteile

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

Nachteile

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

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.

Verifizierter Rezensent
Gesamtbewertung
  • Branche: Computer-Software
  • Unternehmensgröße: 201–500 Mitarbeiter
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

every day using MS SQL Server

Bewertet am 19.1.2022

have +10 years experience in SQl server , i have create a lot of apps depend on it as database...

have +10 years experience in SQl server , i have create a lot of apps depend on it as database storage engine

Vorteile

- every day i use it through management studio or from C# Code by using Entity framework and you can depend on it in any scale application ( small - medium - and large )
- easy integrate with applications
- good security
-have a good Replication feature

Nachteile

it expensive compared by other competitors

In Betracht gezogene Alternativen

Oracle Database

Warum Microsoft SQL Server gewählt wurde

MS SQl server more efficient in medium / large scale
Lasha
Gesamtbewertung
  • Branche: Krankenhausversorgung & Gesundheitswesen
  • Unternehmensgröße: 501–1 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

One of the best DB management systems.

Bewertet am 21.1.2020

I've been using SQL Server for a few years and I haven't had any problems with it except for...

I've been using SQL Server for a few years and I haven't had any problems with it except for partitioning. It's very optimized and stable and due to it being free - it's an amazing choice for small and medium enterprises.

Vorteile

MSSQL comes jam-packed with features. It's standard library is enough to cover the needs of a small enterprise. It is also very stable and can handle large amounts of database exceedingly well. However, my favorite tool is the built-in scripting language - T-SQL. It is very powerful and flexible and lets you do anything you might need.

Nachteile

SQL Server takes up a lot of computing resource. We have a small data warehouse and yet it takes up over 1 TB. Views are not as useful as in Oracle. For example, partitioning a fact table by multiple columns is impossible without a workaround.

In Betracht gezogene Alternativen

Oracle Database

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

SQL Server is free and offers all the features we needed. Oracle is overkill for a hospital.
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.

Germo
Gesamtbewertung
  • Branche: Computer-Software
  • Unternehmensgröße: Selbstständig
  • Täglich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

my every day tool which I use, since it exists

Bewertet am 21.2.2022

I use SQL Server since it was obtained by Microsoft. I am specialized on it and I work only in...

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.

Vorteile

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.

Nachteile

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.

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

Gesamtbewertung

  • Bedienkomfort
  • Weiterempfehlungsquote 10.0 /10

SQL Server - One of the most powerful databases

Bewertet am 9.11.2019

I have been working with SQL Server for 3 years at work and at home for my home projects. I enjoy...

I have been working with SQL Server for 3 years at work and at home for my home projects. I enjoy working with it. It is easy to install, easy to maintain for normal purposes and there are a lot of cool features even in the free versions - for example Express and Developer. I think that it is a very powerful engine - the latest charts also show this by putting SQL Server in one of the first places for the best Databases. I pretty enjoy working with it and pretty recommend it. For years, the companies where I have been working relied on SQL Server and my observation is that it proves its expectations very good.

Vorteile

1. It has different types of subscriptions - you can either test it with free versions, either use it to develop different projects or when you get in love with it - you can buy it with its powerful features.
2. It is a very good working engine.
3. SQL Server has stability, and the performance mechanisms are very cool.
4. You can maintain multiple instances and databases on one server.
5. There are a lot of built-in functions that developers can use, instead of writing their own.
6. Since the latest years, I think there are more and more new things to explore in newer versions - that is a point which shows that Microsoft invests a lot in their product.
7. It is reliable.

Nachteile

Since these years I didn't notice something which I do not like. On the contrary, I pretty like the product and all its features that I have been using through these years, and hope that in the future releases of SQL Server there won't be disappointing things, but only cool ones.

Giovanni
Gesamtbewertung
  • Branche: Bankwesen
  • 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 8.0 /10

A fairly robust database engine with excellent functionalities

Bewertet am 8.10.2021

As a database engine it is a very powerful and good tool, currently very portable between Windows...

As a database engine it is a very powerful and good tool, currently very portable between Windows and Linux systems, which allows you to choose between several operating systems for its implementation, although its cost can be somewhat high, it does not require an annual licensing to maintain its use.

Vorteile

A very robust and quite reliable database engine provides a wide variety of tools and options that allow you to perform settings as daily tasks in an efficient way.
Today it is compatible with almost any operating system allowing you to configure it in the environment that best suits your needs.

Nachteile

Although it is a very portable and robust database engine, its refusal comes with its licensing, which can be very expensive, also its resource consumption can be high in very complex tasks, this leading to the need to invest in very high-end resources in order to meet the demand.

Anuj
Gesamtbewertung
  • Branche: Internet
  • 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

Two words - "Best RDBMS"!

Bewertet am 5.9.2018

Highly recommended - The Best RDBMS Package I have worked so far.
Best IDE - let the wizard do...

Highly recommended - The Best RDBMS Package I have worked so far.
Best IDE - let the wizard do basic things with you few clicks so you can focus on actual DB tasks and writing query.
Developers in your team are going to love this Database!

Vorteile

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

Nachteile

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

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

Gesamtbewertung

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

Microsoft SQL Server is the all-around best out there.

Bewertet am 14.10.2021

The best thing about is is that I can write all the business logic in Store Procedures and only...

The best thing about is is that I can write all the business logic in Store Procedures and only have to write code to display and manipulate data sets.

Vorteile

I started using Microsoft SQL Server in 1999 loaded on a dual 1GH Pentium processor workstation motherboard with the Microsoft NT 4 OS Server. I soon upgraded to Windows 2000 Advanced Server. I wanted see to just what it would do on basically a low end server. I used the same box for the database and the web server running 10 data driven websites. The server was located in my bedroom and connected to the internet via broadband cable. Not the best type of connection for a server.

I would test my websites offsite at work and at friends houses. The pages would load instantly. Imagine the performance on a monster server? The real kicker is with the Microsoft SQL Server Management Studio. Other databases like MySQL and Oracle are also great until you get to the UI part. At the time both of the latter UI's where rather primitive as with MySql or clunky and difficult to use like with Oracle.

Over time, all the databases I mentioned improved but Microsoft SQL Server is still a step ahead.

When it comes to moving a database from one machine to another Microsoft made it easy

Nachteile

I am totally happy with everything about it.