Microsoft SQL Server

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.

Vorteile

Die simpel gespaltene Oberfläche, die gute Zugriffsrechte Verteilung

Nachteile

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

Vorteile

I have lived and breathed MS SQL Server for all my life in the IT Industry. I am still breathing SQL.

Nachteile

Seriously? Microsoft SQL Server is one of the best ever. ORACLE is still up there.

Vorteile

SQL is the core for a lot of businesses, being widely support by third parties it is a very useful system to run.

Nachteile

It's not easy to fault find at times with limited tools due to the complexity of some databases.

Vorteile

Microsoft SQL Server is a powerful database. Although its complexity can be daunting, its capabilities are undoubtedly impressive.

Nachteile

What I liked least was the interface and workspace. Because when you move parts of this interface, it's not very intuitive to put them in the default position. I found this to be problematic and even with the process of adding data, the working space was very small.

Vorteile

Its user-friendly management tools, strong security features, and powerful analytics capabilities make it a reliable choice for handling complex data workloads.

Nachteile

One downside of Microsoft SQL Server is its high licensing costs, which can be prohibitive for smaller businesses. Additionally, resource-intensive performance tuning and occasional compatibility issues with non-Microsoft ecosystems can create challenges for some users.

Vorteile

The capability to store large amounts of data without any data corruption.

Nachteile

Resources consuming, it requires significant CPU, RAM and Storage.

Vorteile

Easily able to generate reports for auditing data if there is a script readily available. You can also provide multiple users with access to the license and run the same reports at the same time.

Nachteile

There is no-real time processing to capture data at certain times and limits the number of line items when there are huge amounts of data. The software is also not easy to use for first time users and they have to take training courses to be able to write scripts and understand how to perform certain functions. The other disadvantage is that it does not provide a path to identify which server you need to be on for the script to run.

Vorteile

I trust all my company's information with them.

Nachteile

The cost was a bit more on the expensive side.

Vorteile

It offers powerful performance and scalability, making it a solid choice for managing large databases

Nachteile

The licensing costs can be high, especially for smaller businesses

Vorteile

Easiness to run queries needed for audit testing.

Nachteile

Can't really think of anything I don't like about SQL server

Vorteile

Being able to retrieve and store data is important

Nachteile

Not too many cons, it's useful in our business

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.

Vorteile

It helps me in storing processing data in and out. Makes my work easier and fast and its very reliable.

Nachteile

If one is using the outdated type it gives worst experience ever.

Vorteile

It works well with all Microsoft platforms

Nachteile

Backing up to shared drive using Legato was time consuming

Vorteile

Great features, cross-platform, well equiped, a good search/filter system, data secured, and the permissions system seemed pretty secure.

Nachteile

The pricing is somewhat high, and it would run slow sometimes for no reasons, something that reports and analytics wouldn't show.

Vorteile

It was a simple and effective tool to ETL data from ERP sources and analyse data outside the system.

Nachteile

Slightly aged looked, appears to be a bit old and could do with a refresh.

Vorteile

The software is easy to use, and the view makes it easy to see all the tables.

Nachteile

I do not like that it does not have a commit and rollback feature.

Vorteile

They incorporate other softwares which make your job easier such as SQL complete and SQL source control.

Nachteile

Sometimes there's access issues or connections issues.

Vorteile

After getting used to this tool at my master's degree, I was able work on projects with a greater scale where advanced data analytics is reqiured

Nachteile

I find this tool, I do not know the exact reason but, still old school in terms the interface, I suppose it could have been more easy to navigate around.

Vorteile

Microsoft SQL provides integrated environment for data analysis

Nachteile

Mainly cost, and other is complex interface

Vorteile

SQL Server is easier to use and setup. it is very good for database management

Nachteile

Managing sql server can be challenging for beginners

Vorteile

The product is easy to use and the best rdbms for data migration

Nachteile

Nothing and I had not observed anything

Vorteile

Microsoft SQL Server is a powerful database, though its complexity can be a challenge, its capabilities are undeniably impressive.

Nachteile

Managing Microsoft SQL Server can be complex and resource-intensive, demanding a steep learning curve and potentially straining hardware resources, which might be challenging for some users.

Vorteile

Retrieving and accessing data is efficient through Microsoft SQL Server. It is very secure and it has really competent features and applications

Nachteile

Support with Microsoft SQL Server can be better, time to resolution takes longer than expected

Vorteile

The customer support and the data migration were done without any difficulty. Data migration team done our job well

Nachteile

Noting to say "Least" about Microsoft SQL

Vorteile

We have a large database of information that we have stored. Primarily of tracking numbers. Our customers will frequently request information from us and SQL is a great tool to help us put together transit information to send to them.

Nachteile

The only thing I can think of is there is a sharp learning curve. But it is a very useful tool.

Vorteile

One of the things I like the most about SQL is the fact that most of my industry works with it, so its easy and convenient to use and gather workflows that suit us and implement them in new projects. Other than that, I haven had any issue with SQL so far. Its robust, is fast, and simply works for every task we use it.

Nachteile

Maybe this is something general for databases, but we usually struggle with Hardware when working with big SQL databases, since SQL will use everything it has available in the server.

Vorteile

I like the security setup, and the ability to export databases and configurations.

Nachteile

The Microsoft licensing structure for SQL is a bit odd. Some options are available for dual-core but not for single-core. Why is that?

Vorteile

Great Free Administration Tools
Super Reliable

Nachteile

Very Expensive, especially compared to open source alternatives
Likes to install Cumulative Updates and take down databases at random times

Vorteile

SQL Server is a product with a long-standing history and no end in sight. In today’s tumultuous world of constantly shifting product lineups, SQL Server stands out as a reliable foundation. With options ranging from on-premises installations to a wide array of cloud offerings, there’s a solution to suit everyone’s needs.

Nachteile

Licensing costs ramp up quickly, so plan accordingly.

In Betracht gezogene Alternativen

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

Vorteile

User friendly interface, extensive documentation , large community support , automatic backups, overall robust performance

Nachteile

Nothing as such. Till this time SQL is great to use and deploy.

Vorteile

Microsoft SQL Server est très complet. Il s'intègre avec tous les outils Microsoft relativement facilement. Il possède toutes les fonctionnalités qu'on attends d'un système de gestion de base de données de cette envergure. Il est disponible en version on premise et dans le cloud (notamment sur Azure). De nombreux outils permettent de le manipuler (Management Studio, Visual Studio, Visual Studio Code, les outils RedGate...). Il est plus facile à appréhender, installer et gérer que son concurrent Oracle Database.

Nachteile

Microsoft SQL Server est plus complexe à mettre en place et le gérer efficacement est un véritable métier. Pour un projet assez léger, il faudra se tourner vers d'autres outils mais quand il s'agit d'un projet important qui va monter en puissance, il s'en sort très bien.

In Betracht gezogene Alternativen

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

Vorteile

* best source to extract required data
* easy to learn and will get more fun by time you progress in your career

Nachteile

* Slow for huge data set loading
* intellisense doesn’t work

Vorteile

Ofrece diferentes ediciones para adaptarse a diversas necesidades desde la gratuita hasta las versiones pagas.

Nachteile

Una de las desventajas es el consumo de recursos, hay un poco de complejidad en la implementación y para escalar horizontalmente se pueden necesitar soluciones avanzadas.

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.

Vorteile

It is economical , has most of the functionality db need to have .

Nachteile

If you are working with older versions of the sever it can be daunting

Vorteile

Possibility of using it quite everywhere

Nachteile

installation that sometimes crash and has to be dome again

Vorteile

All databases stored in sql server can be easily accessed in other systems such as powerbi and excel with your existing account credentials and just by providing database and table names

Nachteile

The learning curve for complex query is quite high without basic knowledge of SQL language it is quite hard to write queries

Vorteile

The pros of Microsoft server, it helps support enterprise management and it also helps store your data securely, without worrying about your data security.

Nachteile

The cons of Microsoft server, is whenever your Internet are interrupted, you will definitely lose access to your software data.

Vorteile

we like the flexibility of the product, i like the querys module, it is simple to understand the management, the user and role

Nachteile

it is not easy to setup, we've done it with some expert

Vorteile

IT serves the purpose of storing all our data no matter how large they are. It is good for database management.

Nachteile

I have not spotted anything I don't like about this.

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.

In Betracht gezogene Alternativen

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

Vorteile

Easy to use, not complicated, easy to use for coding. Easy to download

Nachteile

Hard to find the debug, not friendly for the new user.

Vorteile

Great resource to utilize information securely

Nachteile

Sometimes their are glitches and we are booted from the server

Vorteile

Very easy to connect to databases and write queries

Nachteile

There wasn’t anything about the program that I didn’t like.

Vorteile

It is straight forward and is a relational database.

Nachteile

It could have more modern syntax updates.

Vorteile

Their Data access control and security for users.
Powerfull tools to manage, store all corporate data.

Nachteile

the cost may be an issue for small copanies

Vorteile

My favourite feature of SQL is how it seamlessly integrates with all windows environments to make developing for it super easy!

Nachteile

the cost is very high if you have allot of users rolled out and using the software.

Vorteile

Querying the db is easy and storage is also well maintained. Db support is also great. Overall integration to Microsoft sql server is also easy and works best

Nachteile

I can not think of any con for such a great database system