Opiniones de Microsoft SQL Server

Microsoft SQL Server es una herramienta polivalente para la administración de bases tus datos que proporciona un entorno seguro y estructurado para el almacenamiento y la recuperación de datos. Ofrece características sólidas para la manipulación de datos, incluida la optimización avanzada de consultas y el procesamiento de transacciones. La interfaz es fácil de usar y el lenguaje de codificación es intuitivo, lo que lo hace adecuado tanto para desarrolladores experimentados como novatos.

Un poco el precio, ya que la licencia empresarial es un poco cara. En ocasiones cuando los conjuntos de datos se hacen más grandes disminuye el rendimiento y esto importante si pretendes trabajar con bases de datos grandes.

La cantidad de datos que podemos tener en una bd, depende de la versión, con la gratuita ppdemos tener hasta 10gb

La gestión de copias de seguridad, las copias se tienen que programar por comandos

La herramienta es fácil de instalar, y el mismo proveedor de Microsoft da de manera gratuita un ambiente de trabajo ordenado para utilizar fácilmente la sql server (el SSMS).
Además, se mantiene en constante mejora con actualizaciones regulares.

No hay nada que en realidad no me guste, el problema sería más bien al tratar de realizar migraciones de bases de datos viejas a nuevas que se encuentren en azure y que no tengan elasticidad, es ahí donde una estructura multi teant podría tener problemas (si no se emplea un esquema elástico).

Su instalación es muy sencilla,es compatible con casi todos los lenguajes y su poder de procesamiento va creciendo con el tiempo. Se ha convertido en rival de otros motores como Oracle.

Su sencillo uso también puede generar que no compita a la par con otros motores, además no se lo puede instalar de forma nativa en sistemas operativos que no sean windows.

La forma de utilizar es poco compleja y tiene fácil conectividad con entornos de desarrollo.

La instalación es compleja en ocasiones y suele dar ciertos errores además con el tiempo que tiene podría tener ciertas extensiones que faciliten el gestionar base de datos.

Es una herramienta poderosa para la gestión de bares de datos. Es prácticamente un standar para este tipo de gestión.

Es un programa robusto y por ende algo pesado en algunas arquitecturas de hardware.

si su version es Express, es gratis y no representa gasto para el usuario final

la version de pago es a partir de 10 gb de tamaño de base de datos

La uso para realizar consultas y crear vistas a tablas específicas.

Me gustaría contar con una forma gráfica de realizar consultas.

Muy funcional apara la hora del trabajo en la empresa

Los precios deberían dejarlo más baratos para mayor clientela

la facilidad del manejo de los datos y sus agilidad para brindar una respuesta a la consulta.

las Estructura del sistema de base de datos

Lo que mas me gusta del software, es poder obtener de manera óptima los datos que utilizaré mediante querys.

Lo que menos me gusta podría decir que es la lentitud al momento de realizar querys muy largas.

Su facilidad de creación y consulta de base de datos, y el retorno de los información creada

Me gustaría que los atributos contarán con más espacio ya que las tablas no superan 8024 burra de uso

El producto me ayuda a realizar consultas en las distintas base de datos de mi organización, en donde me puedo a la vez insertar, modificar y eliminar registros, así como filtrar por campos y condicionantes, registros específicos.

El producto satisface todas mis necesidades tanto de consultas, almacenamiento y registro del conjunto de datos de mi organización.

La capacidad de almacenamiento de datos y copia de seguridad

Que se traba en varios prosesos o si son más de dos

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

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

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.

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.

I can say that Microsoft SQL Server is a popular and widely used relational database management system known for its reliability, performance, and security features. It also offers a comprehensive set of enterprise-level tools and services, making it a suitable option for large-scale data management and business intelligence applications. Additionally, it has a large and active user community, providing extensive resources and support.

some common criticisms of Microsoft SQL Server:Cost: The cost of acquiring and maintaining SQL Server can be high, especially for enterprise-level users.Complexity: SQL Server can be complex to set up and manage, especially for smaller organizations with limited IT resources.Limited platform support: SQL Server runs primarily on Windows operating systems, limiting its compatibility with other platforms.Lack of open-source options: Unlike other database management systems, SQL Server does not have a widely available open-source alternative, which could limit its accessibility for some users.These are just some of the common criticisms of Microsoft SQL Server and may not apply to all users or use cases.

Very easy to implement and integrate with other systems.

MS SQL Server consumes almost all compute resourses

Microsoft SQL Server may be a reliable management tool that has a secure and structured setting for information storage and retrieval. It offers strong options for data manipulation, as well as advanced question optimization, group action process and performance monitoring. The interface is simple to use and also the cryptography language is intuitive, creating it appropriate for each toughened and novice developers.

Microsoft SQL Server may be intricate to configure and maintain, because it calls for an in-intensity understanding of database layout and administration. Additionally, sure functions are simplest to be had with the business enterprise edition, which may be steeply-priced for smaller businesses.

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.

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.

Microsoft SQL Server is a comprehensive database solution that provides a wide range of features and functionalities. It is user-friendly and has robust security controls, making it easy to manage access for different users and roles. The built-in performance analysis tools are excellent and help administrators optimize performance with ease.

The ease of use could be improved, and the search and filter functionality could be more robust. Additionally, the data connectors are decent, but there is room for improvement.

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.

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.

I find Microsoft SQL Server to be an impressive and user-friendly database management system, offering excellent performance, scalability, and dependability. It is the perfect choice for enterprise applications and has a range of features such as high availability, disaster recovery, and encryption. Additionally, it comes with many tools and services including data warehousing, data mining, and reporting, making it an affordable solution for businesses of all sizes.

One of the least liked aspects of Microsoft SQL Server is its relatively high cost of licensing and maintenance. Additionally, the complexity of its features can require a steep learning curve, which can be difficult for new users.

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.

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

Security is one of the most important aspects of database software since sensitive information can be stored in databases. SQL Servers are some one of the most secure servers out there so data is safe from hackers.

The scaling aspect of this software is great so whether your business is very small or very large that uses huge amounts of data to be stored, SQL servers can scale and use appropriate resources to handle databases therefore no lagging issues and problems querying databases etc. which makes it extremely fast and efficient.

With the large community that uses SQL Server, you have answers to almost all questions that you may have if you encounter any difficulties setting up or using the software, so troubleshooting is made really easy.

Cost could be an issue as this software could be a bit expensive however with that being said, you definitely will get quality.

Also there might be certain compatibility issues with other non Microsoft software that your company may use so in some cases you might have to switch over to Microsoft softwares in your company depending on what they are.