Wir helfen Unternehmen in Deutschland
seit 15 Jahren bei der Softwareauswahl

Microsoft SQL Server Erfahrungen

Über Microsoft SQL Server

Datenbank- und Analyseangebot für die schnelle Bereitstellung der nächsten Generation von skalierbaren E-Commerce- und Line-of-Business-Lösungen.

Erfahre mehr über Microsoft SQL Server

Vorteile:

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.

Nachteile:

Licensing is confusing, whenever you have license by call or by CPU core, it's a bit hard to understand how they apply the prices.

Bewertungen zu Microsoft SQL Server

Durchschnittliche Bewertung

Benutzerfreundlichkeit
4,3
Kundenservice
4,3
Funktionen
4,6
Preis-Leistungs-Verhältnis
4,3

Weiterempfehlungsquote

8,7/10

Microsoft SQL Server hat eine Gesamtbewertung von 4,6 von 5 Sternen basierend auf 1.935 Nutzerbewertungen auf Capterra.

Hast du Microsoft SQL Server bereits verwendet?

Teile deine Erfahrungen mit anderen Softwareinteressenten.

Nutzerbewertungen filtern (1.935)

Rene
IT System Engineer in Deutschland
Chemikalien, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Solides Produkt

5,0 vor 2 Monaten Neu

Vorteile:

Dadurch, dass der Server weit verbreitet ist und die Kompatibilität nahezu überall gegeben findet man diesen wohl in jeden Unternehmen. Sehr solide, stabil und einfache Updates.

Nachteile:

Echte Hochverfügbarkeit leider nur mit der teuren Enterprise Lizenz.

Luca
Systemintigrator in Deutschland
Computer-Hardware, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Mssql

5,0 vor 6 Monaten

Vorteile:

Die simpel gespaltene Oberfläche, die gute Zugriffsrechte Verteilung

Nachteile:

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

Enrico
Enrico
Language Technologies Expert in Italien
Verifizierter Nutzer auf LinkedIn
Übersetzung und Lokalisierung, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Empowering Enterprise Data Management with MS SQL Server

5,0 vor 2 Monaten Neu

Kommentare: MS SQL Server is the cornerstone of our operations, most of our products are based off it. It just works, that's all.

Vorteile:

Integration with the MS ecosystem, scalability and reliability of the product.

Nachteile:

Licensing costs too high for non express configurations.

Fiach
Director in Italien
Computer-Software, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

The best Database to use with Windows-Native applications

5,0 vor 2 Monaten

Kommentare: I've used SQL server since version 7, which is more than 20 years ago, and still use it every day (Although, not version 7!)

Vorteile:

If you are using C# / .NET on a Windows server, then Microsoft SQL server is the natural choice. The free edition is fine to get started, and once you out grow it, you can afford the license fee (hopefully!)

Nachteile:

It's very expensive, given that there are free alternatives like MySQL. CSV importing is a pain, when it doesn't need to be.

Wilmer Josué
Computer Science Engineering in Honduras
Bibliotheken, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

SQL Server as a primary tool for developers

3,0 vor 3 Jahren

Kommentare: I have been using SQL server since the first periods of college in my programming classes, as a storage of information I have been taught its practical use both personally and for program development in companies. I find it a very useful and versatile tool, it is used with ease as long as the developer has studied enough information about sql server because a novice and a pro can delete by mistake a whole database, you have to be careful because there are no request messages to deny the deletion. To use the tool I recommend to practice a lot and to comment the coding.

Vorteile:

What I liked about the tool is the practical use it has, it can be used by novices in an easy way, as long as someone teaches them the basics, it is very useful on a daily basis due to the management of databases and their respective migration to other platforms. The management of the information becomes useful, it is versatile to changes before, during and after the development of the project.

Nachteile:

What I liked least is the interface and the work area because when moving a part of that interface it is not very intuitive to place it to the default place, I have had problems with that and also that for processes of adding data I find the work space very small.

Humberto
Systems Engineer in Kolumbien
Import und Export, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Successful data management and administration

5,0 vor 3 Monaten

Kommentare: A great tool for database administration and management, the ability to perform easy tasks in terms of backups, restores and replications makes it one of the great options for productive environments where you work.

Vorteile:

Its ease and versatility in administration tasks, its great integration with bi and bigdata environments, as well as its stability in production environments.

Nachteile:

The biggest disadvantage I see is that it is not as mature in its implementation in unix environments.

Andy
Andy
Technology Planning for Transport Networks in Mexiko
Verifizierter Nutzer auf LinkedIn
Telekommunikation, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Microsoft products are usually stable and reliable.

4,0 letztes Jahr

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Gewerbeimmobilien, 201–500 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Relation Database Management

4,0 vor 10 Monaten

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

Shubham
SQL Database Consultant in Indien
Informationstechnologie & -dienste, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Best Relational Database with great data capabilities

5,0 vor 3 Wochen Neu

Vorteile:

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

Nachteile:

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

Lew
Director of Information Technology in USA
Landwirtschaft, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Microsoft SQL Server - the heart of our organization

5,0 letzten Monat Neu

Vorteile:

In a Windows Server world, MS SQL Server integrates easily on top of Windows Servers and is very easy to use if you have any SQL experience. The power it gives in a data-centric world is what I like most!

Nachteile:

It is somewhat cumbersome to get data from a SQL query grid easily into an Excel format.

Earl
systems engineer in USA
Einzelhandel, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

businesses go to solution for databases

5,0 letzten Monat Neu

Vorteile:

ease of use and integrationalong with support option makes it a premier product

Nachteile:

licensing costs, be sure to purchase the correct version and edition

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Computer-Software, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Create a structure and store for analysis

5,0 vor 2 Monaten

Vorteile:

Best tool to handle Enormous data for your data modules and analysis

Nachteile:

Hard for scrolling in tables when we have huge lists and if the scroll option can be replaced with some search setting it would be easy.

Brenten
Facilities Engineer in USA
Fluggesellschaften/Luftfahrt, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Powerful and Scalable Database Software

5,0 vor 3 Jahren

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

Paolo
Software Engineer in Italien
Elektrische/elektronische Fertigung, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

The quintessential database server

5,0 vor 2 Jahren

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

Prabhu
Prabhu
associate projects in Indien
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

All time market leader

5,0 vor 4 Jahren

Kommentare: When comes to business critical it can consume the raw data, process it and provide to the user understandable format. More than decades, this software providing tremendous help to business to evolve and reach their goals by fetching data from any formate and load it into structured form and with help of powerful Tsql query languge we able to fetch the right data from database. We can also connect with any visualization tool to provide the better UI(Power BI) to users to take right decision.

Vorteile:

1. Optimized storage and querying business critical data. 2. Powerful Tsql Query language. 3. Query execution plan to predict and optimize the data. 4. Query profiler to find out anomaly and query latency.

Nachteile:

1. We need to take care of all patching works. 2. We need to take care of all infrastructure scalability(RAM,HDD and IO etc) 3. Server maintenance and outrage time is high.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Computer-Software, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

every day using MS SQL Server

5,0 vor 2 Jahren

Kommentare: 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

Robert
Robert
Owner in USA
Informationstechnologie & -dienste, Selbstständig
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

In Betracht gezogene Alternativen:

SQL Server Great for SQL Database Creation

4,0 vor 5 Jahren

Kommentare: Overall, my experience with SQL Server has been pleasant. If I had employees, I would strongly recommend them to use is as their main source to create SQL databases. It makes sense to use a platform that is specialized and can be a one stop shop. That is what SQL Server is.

Vorteile:

I love the ability to create SQL databases separate from Visual Studio. Although you can create databases in VS, I like how SQL Server Management Studio is designed specifically for database creation. Plus, it has advanced features for database admins which Visual Studio does not. After creating a database, the admin can migrate the SQL Server database in Visual Studio.

Nachteile:

It is difficult to learn if someone at a beginning level is using it. They will need to utilize the many tutorials provided within EDX.org, youtube or Udemy (to name a few) to learn it. It makes sense if you know how to create SQL databases and the SQL language prior to using it. If not, I suggest to learn SQL first prior to jumping into SQL Server to do database management.

Anthony
Senior Applications Manager in USA
Tiefbau, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

SQL Server | The Gold Standard

5,0 vor 2 Jahren

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

Vorteile:

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

Nachteile:

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Computer-Software, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Very complete Database manager

5,0 vor 4 Jahren

Vorteile:

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

Nachteile:

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Easy to configure, difficult to master

5,0 vor 5 Jahren

Kommentare: Easily the most intuitive RDBMS software out of the box.

Vorteile:

The most noteworthy features of Microsoft SQL Server are the many tools and wizards that allow even novice users to get started by creating tables and views without extensive knowledge of relational databases. The query wizard can even assist with creating queries with its intuitive IDE. These features lower the intimidating barrier to entry that accompanies other relational database software such as Oracle or MySQL. There is even a free version call Express that allows anyone to dabble in the software before committing to the product. Aside from the user assisted features, the other appealing aspect of SQL Server is the integration with other Microsoft products that are probably already running in an organization. SQL Server interfaces with Active Directory allowing for easy user management so appropriate levels of database access can be allotted via group membership. This is useful because even something simple like user access management in another RDBMS may present a learning curve for anyone that is not a DBA. With SQL Server a general IT resource could manage user access with an existing knowledge of Active Directory providing more time to focus on core database design.

Nachteile:

SQL Server carries a high cost subscription based licensing cost. The user assistance features provide a great introduction to relational databases, but there is still a significant and continuous learning curve. Databases continue to evolve with industry need. Anyone that interacts significantly with SQL Server during day to day database or application design may need to consider yearly training to keep up with all the changes.

Surender
Technical Lead in Indien
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Best DBMS tool for scalable enterprises

5,0 vor 5 Jahren

Kommentare: My overall experience is 100% satisfactory because of its robust feature. I recommend this to all either its a large or small scale compan y because SQL server can handle large quantities of data and process it smoothly. Just loving it.

Vorteile:

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.

Nachteile:

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Computer-Software, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Very reliable, relatively easy-to-use, and reasonably-priced compared to Oracle

5,0 vor 6 Jahren

Kommentare: Our entire product line (IIS-based web applications) relies on SQL Server. Without it, our business wouldn't function at all.

Vorteile:

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.

Nachteile:

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.

Shawn
Financial Systems Data Analyst in USA
Rechtsberatung, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

SQL Server a Building Block of Tech Stack

5,0 vor 2 Jahren

Kommentare: Good overall experience. We're addressing the need to store, transform, and retrieve data. Information has become the backbone of many technological and business operations, and almost everything I work on goes through a SQL database to accomplish the job. It's one tier of applications that is used almost everywhere. SQL Server allows us to query data for reporting to end users, and also provides options to move and transform the data to different environments.

Vorteile:

At our firm, we have a completely Microsoft tech stack; from servers, databases, middleware, peripheral applications, etc. When using all Microsoft products, it is extremely easy to connect and integrate between applications, servers, and databases. I am less sure about integrating with other providers (such as oracle), but I know its possible with a little more effort. Maintenance, backups, restores, disaster recovery plans all seem routine now. The product is very familiar and there is ample documentation and general SQL training. Get a good DBA and your servers will stay healthy as well; certain system settings are important, and monitoring those and adjusting for your business is prudent. SSMS is an easy IDE to use and perform any function. You can use SQL to automate many tasks, and I really like the SQL jobs. SSIS lets me automate so much, even to and from external vendors, using SFTP or some other mechanism. It extends SQL Server to use any script or basic Windows command.

Nachteile:

When you run into an issue, it can be hard to resolve. An example would be when Microsoft data connectors aren't working. Understanding and getting the right supporting software installed is important; like OLE DB and ODBC connectors. Another difficulty can be performance. As data sets get larger, this is more important. While there are enough tools to investigate and troubleshoot, sometimes it's just a big effort to try to query tune, index, or adjust server settings to get the results in performance that you want. Queries seem to only get more complex, and data sets larger. I am pretty sure other databases will perform better with Big Data.

alfredo
alfredo
ventas in Mexiko
Verifizierter Nutzer auf LinkedIn
, 51–200 Mitarbeiter
Verwendete die Software für: Nicht angeboten
Herkunft der Bewertung

If you are working from scratch,it is relatively easy to set up a new database server and connectivi

5,0 vor 6 Jahren

Vorteile:

If you are working from scratch, it is relatively easy to set up a new database server and connectivity between clients. Everything is quite simple, given that you have knowledge of the database. The DBMS allows you to easily create several things completely in design (tables, views, etc.), which is a great advantage when you do not know all the syntax. The integration of other monitoring software such as fog light is very easy without the consumption of time. Great ability to handle all complex query requirements. Suite of advanced functions of sql. Provide all the excellent functionalities, such as Reporting Services, Integration Services, Job Scheduler, Resource Manager, Query Analyzer and Profiler, etc. Each of these modules is perfectly constructed and manages the tasks effectively. Configurable in each level. The user permission is on all objects and other higher levels. Changes can be made for specific privileges at the user level. Window service based on Control to the server to start and stop the service. I think one of the best things about Microsoft SQL (currently using 2012) is the Developer Network and the useful resources that are available. Thanks to the network of developers, I have been able to learn much more about queries and create more useful and advanced queries over time. Things like Transact-SQL (T-SQL) are useful many times due to the large number of new queries that can be generated after learning T-SQL.Compatibility with most SQL Server administ

Nachteile:

Sometimes, performance when executing some long queries is not what you would expect. Although the power of the CPU is important for this part, but in the company we have state-of-the-art servers in the NAP of the Americas, so it seems a software problem instead of a hardware problem. Some of the configurations of previous versions (2008 - 2012) are quite clumsy and not very well done - I have had several instances of my corrupt installer and have to re-download. The administrator of the database, sometimes, takes time to load. Scalability is excellent, but not the best, like other new databases in the market. The memory consumption of the CPU is always more than normal in the production specifically by the sql server. Scope of the improvement in the profile generator for the most used options. Sometimes, if it is not handled properly with a predefined scheme, the relations and the maintenance of the data become a problem. This happens mainly only when it comes to new users or with people who do not work as part of a larger workforce that manages the system. Certain add-ons also provide useful features, but if SQL added them, it would save users the problem of finding and installing them. The database is the target of many attacks from your SA account, this should be disabled by default and just after installation, about 30 seconds, the attacks begin, with many requests per second, need to improve the firewall to prevent these attacks, or place the SQL Server inside a VPN

Gordon
Senior SAP Consultant in Kanada
Computer-Software, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Microsoft SQL Server will meet all your Database Server needs

5,0 vor 6 Monaten

Kommentare: Overall, Microsoft SQL server is a powerful database server option in the market.

Vorteile:

- Microsoft SQL server is indeed a robust Database Server option. In this review, I will talk about Microsoft SQL in terms of SAP and compare it to its alternative option in SAP - the HANA Server. - When it comes to SAP ERP, our clients have two options for their database server needs - Microsoft SQL Server or HANA server. Microsoft SQL server is great option that will get the job done. Most of us consultants, have the SQL server installed in our local machines since it is impossible to install the HANA server in our local machines because of the heavy resources needed. SAP HANA requires a minimum of 32 GB ram for example.- Microsoft SQL server is easy to install especially the if you are installing the Express Version which is very light and install quickly. - I did not require much training to be able to use the basic features of Microsoft SQL server and I get a free license for my local machine if you install the evaluation version on your machine.

Nachteile:

- Compared to SAP HANA Server, Microsoft SQL Server has less analytical capabilities but generally, Microsoft SQL is a powerful database server option in the market.- There is a bit of a learning curve involved. If you want to be able to do some complex tasks in Microsoft SQL server, you might need to employ the use of some learning material.