Sobre Microsoft SQL Server
Oferta de bases de datos y análisis que ayuda a entregar rápidamente soluciones de línea de negocio y comercio electrónico escalables y de última generación.
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.
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.
Filtrar opiniones (1.827)
Uso
Ordenar por
Filtrar opiniones (1.827)
Iago
Alternativas consideradas:
Gestiona tus bases de datos de la manera más sencilla
Comentarios: Es una de la mejores herramientas que puedes encontrar en el mercado, además tiene la ventaja de poder integrarse con los productos de Microsoft, aunque al trabajar con SQL lo puedes utilizar con múltitud de aplicaciones sin tener que se de Microsoft.
Puntos a favor:
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.
Puntos en contra:
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.
Jesus Cortes
Alternativas consideradas:
Sql server
Comentarios: Buena, tenemos michos clientes con estas bases de datos.
Puntos a favor:
La cantidad de datos que podemos tener en una bd, depende de la versión, con la gratuita ppdemos tener hasta 10gb
Puntos en contra:
La gestión de copias de seguridad, las copias se tienen que programar por comandos
Claudio Ivan
Un gran manejador de bases de datos
Comentarios: En generar es una gran herramienta para bases de datos, hace todo lo que uno busca con buena velocidad, es relativamente ligero para un servidor y barato (incluso la versión express es completamente gratuita), por lo que es una gran opción para empezar en una pequeña empresa, pero es lo suficientemente robusta como para ir escalando conforme más potencia se necesite.
Puntos a favor:
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.
Puntos en contra:
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).
Juan Carlos
Una base de datos que va mejorando
Comentarios: Es una buena herramienta, cumple con las características de las bases de datos, de fácil administración y potente. Es indudable tomarla en cuenta para nuestros proyectos.
Puntos a favor:
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.
Puntos en contra:
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.
Usuario verificado
Reseña de calidad desde el punto de vista de un desarrollador de base de datos.
Comentarios: Es buena por lo general ya que tiene una empresa con un gran soporte detrás de ella y una buena gestión de usuarios.
Puntos a favor:
La forma de utilizar es poco compleja y tiene fácil conectividad con entornos de desarrollo.
Puntos en contra:
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.
Magno Gabriel
Gestión de bases de datos
Comentarios: Es más fácil de relacionar las tablas con Microsoft Sql Server. Ya que posee múltiples funcionalidades.
Puntos a favor:
Es una herramienta poderosa para la gestión de bares de datos. Es prácticamente un standar para este tipo de gestión.
Puntos en contra:
Es un programa robusto y por ende algo pesado en algunas arquitecturas de hardware.
Efrain
Sql para mediana empresa
Comentarios: es mas rápido el Software de la empresa
Puntos a favor:
si su version es Express, es gratis y no representa gasto para el usuario final
Puntos en contra:
la version de pago es a partir de 10 gb de tamaño de base de datos
Julian Gaston
Lo mejor para Base de Datos
Puntos a favor:
La uso para realizar consultas y crear vistas a tablas específicas.
Puntos en contra:
Me gustaría contar con una forma gráfica de realizar consultas.
Kevin
Elegante
Comentarios: En general muy bien todo bien por el momento tengo
Puntos a favor:
Muy funcional apara la hora del trabajo en la empresa
Puntos en contra:
Los precios deberían dejarlo más baratos para mayor clientela
Brayan
Mi Experiencia
Comentarios: no a resuelto mucho a en la empresa ya que SQL SERVER es el motor de base de datos de la empresa y por hay manejamos lo que la reporteria de la empresa con lo que le llamamos REPORTING SERVER.
Puntos a favor:
la facilidad del manejo de los datos y sus agilidad para brindar una respuesta a la consulta.
Puntos en contra:
las Estructura del sistema de base de datos
Usuario verificado
Herramienta muy útil
Puntos a favor:
Lo que mas me gusta del software, es poder obtener de manera óptima los datos que utilizaré mediante querys.
Puntos en contra:
Lo que menos me gusta podría decir que es la lentitud al momento de realizar querys muy largas.
Marlon Andres
SQL Server
Puntos a favor:
Su facilidad de creación y consulta de base de datos, y el retorno de los información creada
Puntos en contra:
Me gustaría que los atributos contarán con más espacio ya que las tablas no superan 8024 burra de uso
Moisés
Servidor SQL de Microsoft
Comentarios: Microsoft SQL Server me ha solucionado tener toda la información de los distintos negocios a los cuales le trabajo bajo dicha solución, centralizada.
Puntos a favor:
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.
Puntos en contra:
El producto satisface todas mis necesidades tanto de consultas, almacenamiento y registro del conjunto de datos de mi organización.
christian
Buena pero hay mejores
Comentarios: Pues no me gustó mucho pero tampoco es mal software está aceptable por el precio
Puntos a favor:
La capacidad de almacenamiento de datos y copia de seguridad
Puntos en contra:
Que se traba en varios prosesos o si son más de dos
Ishan
RDBMS tool for Microsoft based stack
Comentarios: Overall a perfect combo of database management with help of its tools.
Puntos a favor:
1. Supports SQL with only subtle change in syntax2. It has its UI application MSS Management studio, which is helpful editor and platform for implementation.
Puntos en contra:
1. It consumes lot of RAM.2. Latest version are some times not stable.
Saurabh
Alternativas consideradas:
SQL Server: A Game-Changer for Data Management and Analytics
Comentarios: One of the key strengths of SQL Server is its data management capabilities, including data import/export, backup and recovery, data cleansing, data connectors, and data storage management. The software's reporting and analytics features, including customizable dashboards and interactive reports, provide organizations with valuable insights into their data. Additionally, the software's security and data quality control features help ensure that organizations can maintain accurate and consistent data.However, like any software, SQL Server also has some limitations. The software can be complex and challenging for inexperienced users to navigate, and the customization options available may be limited compared to other database management systems. Additionally, the cost of the software can be a barrier for some organizations, especially small businesses or startups. Some users have also reported performance issues, particularly when working with large amounts of data, and limited integration with other tools and technologies.Overall, Microsoft SQL Server is a comprehensive relational database management system that provides robust features for managing, analyzing, and reporting on data. While it may have some limitations, it is a well-regarded and widely-used tool that is well-suited for organizations with large amounts of data.
Puntos a favor:
One of the key benefits of Microsoft SQL Server is its robust data management capabilities. The software provides an array of tools for importing and exporting data, managing data storage, and ensuring data quality, which makes it easier for organizations to manage and maintain their data. Additionally, the software provides robust reporting and analytics features, including interactive dashboards and customizable reports, which make it easier for organizations to gain insights into their data and make informed decisions.Another advantage of SQL Server is its scalability. It can handle large amounts of data and supports high-performance data processing, making it suitable for organizations of all sizes, from small businesses to large enterprises. The software also provides multiple options for connecting to other data sources, including other databases and cloud services, which enables organizations to integrate data from a variety of sources and create a single source of truth for their data analysis.Finally, SQL Server provides reliable and secure backup and recovery options, which give organizations peace of mind in knowing that their data is protected. The software also includes features for data cleansing, which help organizations to maintain accurate and consistent data, improving the quality of their analysis and reporting.Overall, the combination of robust data management tools, scalability, and reliable backup and recovery options makes Microsoft SQL Server an
Puntos en contra:
it also has some limitations and drawbacks. Here are a few cons that you may find with the software:- 1) Complexity and Steep Learning Curve: One of the main criticisms of SQL Server is its complexity. While the software is designed for enterprise-level data management, its interface and features can be difficult for inexperienced users to navigate and understand. The software's advanced features, such as data warehousing, data mining, and OLAP, can also be difficult to set up and use for non-technical users. Additionally, the software's query language, T-SQL, can be challenging for those who are new to database programming.2)Integration with Other Tools: users have reported that SQL Server may have difficulty integrating with other tools and technologies, such as big data platforms, cloud services, and data visualization tools. While the software provides multiple options for connecting to other data sources, some users have found that the integration process can be complex and time-consuming.3)Limited Mobile Support: SQL Server provides limited support for mobile devices, which can be a drawback for organizations that require mobile access to their data. Some users have reported that the software's mobile app is limited in functionality and may not provide the same level of access to data as the desktop version.4)Poor User Experience: Some users have reported that the user interface of SQL Server can be confusing and not as user-friendly as other database management
Josh
SQL management is overly complex, but perhaps rightly so…
Comentarios: Our customers are able to push their Sage 200 data to various third-parties and have greatly expanded on their opportunities to increase income. SQL essentially offers endless possibilities as it’s widely supported by many other tools and devices.
Puntos a favor:
Our customers who use SQL in conjunction with Sage 200 and Sage BI have achieved great results with regards to both end-user experience and data analytics. The way in which SQL handles their data, means they’re able to tie the databases in with various external web services and expand on their business usage case.
Puntos en contra:
The user interface is extremely complicated to use if you’re not a SQL Server expert, but perhaps that is unavoidable due to the shear volume of features and settings available. It would be nice if certain areas of the GUI were simplified, especially when dealing with Active Directory access control lists and permissions.
Sardorbek
Microsoft SQL Server - Reliable Database Management Tool
Comentarios: After using Microsoft SQL Server for several years, I have found it to be a reliable and secure database management system. Its robust features and intuitive coding language make it suitable for a variety of tasks and its user-friendly interface is easy to navigate.
Puntos a favor:
Microsoft SQL Server is a reliable database management tool that provides a secure and structured environment for data storage and retrieval. It offers robust features for data manipulation, including advanced query optimization, transaction processing and performance monitoring. The user interface is easy to use and the coding language is intuitive, making it suitable for both experienced and novice developers.
Puntos en contra:
Microsoft SQL Server can be tricky to configure and maintain, as it requires an in-depth knowledge of database design and administration. Additionally, certain features are only available with the enterprise edition, which can be costly for smaller businesses.
Vinicius
Alternativas consideradas:
Review for Microsoft SQL Server
Comentarios: SQL Server is my main RDBMS for Windows environments because it has a wide range of features and is completely compatible with the operating system since it runs on its native platform.
Puntos a favor:
Easy to install, configure, update and use. Through tools such as SQL Server Management Studio (SSMS) the system has a very friendly graphical user interface. SQL Server has extensive documentation on the Internet.
Puntos en contra:
Full installation takes up a lot of disk space. Depending on the version, the software license can be very expensive.
Victor
Alternativas consideradas:
the best SQL tool you will ever use!
Comentarios: We currently have more than 10 databases in our company, all under SQL Server, with good maintenance and applying good resources, we have guaranteed stability and scalability. excellent product.
Puntos a favor:
For me it is the best tool for managing databases, the functionalities it has meet my needs, being able to add Microsoft Integration Services is the best I have been able to use.
Puntos en contra:
it may take a bit of resources to get its full potential
Usuario verificado
MS SQL Server Review
Comentarios: I love it, it is my first personal preference. And I love teaching others using Microsoft SQL server because it's easily understood.
Puntos a favor:
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.
Puntos en contra:
When there's a large amount of data in the database it tends to slow down the speed of fetching data
Usuario verificado
Alternativas consideradas:
Enterprise DBMS
Puntos a favor:
We had to migrate our free databases to SQL server because we reached many gigabytes in a few tables and needed a fast and reliable software to handle it and integrate with some BI products. Microsoft SQL Server had no issues and works really fine.
Puntos en contra:
License costs are major issues , but any other paid database costs about the same. It is still a bit overkill for us but we are looking at using it in the cloud as a PaaS.
Edward
Alternativas consideradas:
SQL Server Review
Comentarios: I have used every version since 6.5 and all releases have been solid and each subsequent release showed improvements.
Puntos a favor:
It has been the same core components since 6.5, but the new features are very good.
Puntos en contra:
Some of the alerts provided by Microsoft are not always intuitive or clear
Ryan
A good tool when you need it, but not my favorite place to access data
Puntos a favor:
I like that it is a good tool to access a SQL database, especially one that is housed within Microsoft.
Puntos en contra:
As with most Microsoft tools (e.g., visual studio), it has too many bells and whistles. There is so much available within this tool that I get lost and have a hard time getting a workspace set up. I also had quite a few authentication problems because I was logging in with different credentials than my laptop password and it kept looking in my credentials manager so that was frustrating.
Mir Fida
Alternativas consideradas:
Best database management tool for relational databases
Comentarios: 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.
Puntos a favor:
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.
Puntos en contra:
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.
