Microsoft SQL Server

Relationales Datenbankmanagementsystem für die Datenanalyse

Gesamtbewertung

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

1829 Bewertungen

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 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
Kawther
Gesamtbewertung
  • Branche: Schreiben & Editieren
  • Unternehmensgröße: 2–10 Mitarbeiter
  • Wöchentlich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

A Reliable RDBMS Alternative for OLTP Systems

Bewertet am 10.2.2023

Vorteile

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

Nachteile

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

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

Verifizierter Rezensent
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 10.0 /10

MS SQL Server Review

Bewertet am 15.1.2023

I love it, it is my first personal preference. And I love teaching others using Microsoft SQL server because it's easily understood.

Vorteile

It is easy to use for data transfer and data retrieval.It enables you to create stored procedures and views.There is security for data storage, backup, and restoring your databases.

Nachteile

When there's a large amount of data in the database it tends to slow down the speed of fetching data

Edris
Gesamtbewertung
  • Branche: Buchhaltung
  • Unternehmensgröße: Selbstständig
  • Täglich für Kostenlose Testversion genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

Microsoft SQL Server the best software for database.

Bewertet am 10.2.2023

At the moment, I use SQL Server to maintain the databases at Sonic Drive-Ins all over the United States, as well as to fix late ticket times, modify orders, cancel orders, and do anything else related to the database failing systems over and ensuring that they have the data they require when they need to go back. Additionally, tables must be modified while setting payroll. And when users become trapped in the system, we enter, maintain the users, and use the SQL Server to free them. What I appreciate about SQL Server is that it saves all the data and information in alphabetical order, making it clean and tidy and simple to locate.

Vorteile

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

Nachteile

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

Verifizierter Rezensent
Gesamtbewertung
  • Branche: Informationstechnologie & -dienste
  • 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 9.0 /10

Powerful and Scalable Database Solution from Microsoft

Bewertet am 11.2.2023

Vorteile

1. It is a robust DBMS and a go to solution for many applications2. Its Management studio and Command line interface is so powerful and easy to use3. All access are managed with built in roles and user defined roles effectively4. Secure, easy to configure and does not require deep experience in using the product5. Business Intelligence tools like SSMS and SSRS work seamlessly6. Its so mature and has great community support

Nachteile

Price Price Price!! It is so expensive and Support could have been better.

Ketan
Gesamtbewertung
  • Branche: Maschinerie
  • Unternehmensgröße: 201–500 Mitarbeiter
  • Wöchentlich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

Benefits Using Microsoft SQL Server

Bewertet am 11.2.2023

SQL server is overall very good product considering performance and price

Vorteile

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

Nachteile

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

Verifizierter Rezensent
Gesamtbewertung
  • Branche: Computer-Software
  • Unternehmensgröße: 11–50 Mitarbeiter
  • Wöchentlich für Mehr als 1 Jahr genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

An easy SQL Server with some issues.

Bewertet am 10.2.2023

Overall satisfactory , meets almost all the necessities , needs to improve some areas.

Vorteile

Easily understandable queries , data browser's UI is very simple.

Nachteile

Complex data migration process , complexity in installation

Verifizierter Rezensent
Gesamtbewertung
  • Branche: Bau
  • Unternehmensgröße: 501–1.000 Mitarbeiter
  • Täglich für Mehr als 1 Jahr genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

application for companies High

Bewertet am 12.2.2023

Vorteile

this software is very useful to use it with big company

Nachteile

every person or company can be use this with daily work to make share in the form of cloud

Manish
Gesamtbewertung
  • Branche: Informationstechnologie & -dienste
  • Unternehmensgröße: 1.001–5.000 Mitarbeiter
  • Wöchentlich für Mehr als 2 Jahre genutzt
  • Quelle der Bewertung

Gesamtbewertung

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

Awesome Product!

Bewertet am 11.2.2023

Vorteile

It supports a wide variety of transaction processing

Nachteile

There are no cons that I can think of currently

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

Hasan
Gesamtbewertung
  • Branche: Bankwesen
  • Unternehmensgröße: 501–1.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

SQL Server

Bewertet am 25.6.2021

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

Vorteile

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

Nachteile

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

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

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

Verifizierter Rezensent
Gesamtbewertung
  • Branche: Automotive
  • 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

Relational Database Management System

Bewertet am 17.10.2019

Overall had a great experience as the name suggests that "Microsoft SQL Server" the first word of the product defines it all and have a huge impact on its sale and purchase.

Vorteile

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

Nachteile

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

In Betracht gezogene Alternativen

Oracle Database

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

As we have a committed microsoft partner and we are in an Enterprise agreement with Microsoft so it is easier for us to explore the all new world of Microsoft.
Surender
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 10.0 /10

Best DBMS tool for scalable enterprises

Bewertet am 16.5.2019

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.

Griffin
Gesamtbewertung
  • Branche: Gastgewerbe
  • 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
  • Weiterempfehlungsquote 10.0 /10

SQL Server is the backbone of my life!

Bewertet am 4.2.2019

Overall, my experience with SQL Server is amazing! I am able to store all of our Las Vegas luxury casino data (gaming, hotel, food & beverage, entertainment, etc.) and query that for information that we then turn into automated or ad-hoc reports. These then go to the operators of the business as well as the executives who analyze the reports and make better decisions daily, weekly, and monthly. The goal is simple: just become better over time...better than you were last year, last month, last week. And SQL Server is the vehicle to empower your organization to find those valuable insights hiding in plain sight to do just that!

Vorteile

I absolutely LOVE SQL Server. It is my favorite software to use because the possibilities for query-writing are endless. I would say this is the most reliable and flexible of all the database software I have ever used. SQL Server allows you to write in T-SQL (T = transact, SQL = structured query language), which means that you can create variables, use temp tables, and write code in a procedural format that runs akin to a module in other programming languages. We use SQL Server 2008 at work, though I am really loving the new features in the latest version (as of today) SQL Server 2016.

Overall, SQL Server is a platform for creating table schema, storing information, and then writing scripts (queries) to manipulate that data--to find insights that are useful to making better business decisions. The interface is easy to understand, the error-checking is strong (and actually tells you what is wrong). It doesn't hold your hand like other simplified coding languages, but it becomes very reliable and easy to use once you obtain a solid foundation in relational database theory and SQL language.

Nachteile

Hmm...if I had to speak ill of SQL Server...I would probably say that it is a bit tricky to get up to speed quickly with. There's a lot to it, so to speak, so it's taken me the better part of five years working in the data analytics industry to finally say that I feel I am completely proficient in utilizing the software to its full potential. Topics such as query optimization remain my areas of biggest weakness. I can write a query to pull any kind of desired information; however, the art lies in being able to pull it quickly and with reasonable efficiency. If your query takes more than 15 minutes (or even hours!) to run, it's probably not written correctly and likely poses a major threat to the server you are connecting to (and tying up!) in the process. I would like more information in the software (GUIs, warnings, etc.) regarding poorly-written queries from an execution standpoint.

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

Verifizierter Rezensent
Gesamtbewertung
  • Branche: Krankenhausversorgung & Gesundheitswesen
  • 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

SQL Server 2016 - Features Review

Bewertet am 20.12.2018

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

Vorteile

In our project we have been migrated from Microsoft SQL Server 2008 to SQL server 2016 directly for all our databases & SSIS packages. There are many features that was available to use for the projects and some of those are:

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

Nachteile

Only I know very least number of disadvantages this MS SQL server 2016 is having:

1. Enterprise pricing may be costly as some of the organisation cant afford for the count of data they are having.
2 With the performance tuning, Microsoft SQL Server will be having some gobble resources.

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

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

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

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

Gesamtbewertung

  • Preis-Leistungs-Verhältnis
  • Bedienkomfort
  • Kundenbetreuung

I have been working with this software from last 8 years. I like this software and used its...

Bewertet am 25.5.2018

Vorteile

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

Nachteile

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