SQL Server

Por Microsoft

4.5 / 5 822 reseñas
SQL Server

Los productos más populares


¿Quién utiliza este software?

Cualquier empresa de todos los tamaños que busque software de gestión de bases de datos.

Valoración media

822 reseñas
  • En general 4.5 / 5
  • Facilidad de uso 4 / 5
  • Atención al cliente 4 / 5
  • Funciones 4.5 / 5
  • Relación calidad-precio 4 / 5

Detalles del producto

  • Precio de partida $931/una vez
  • Versión gratuita
  • Prueba gratis No
  • Implementación Instalado: Windows
  • Formación En persona
    Seminarios web
    Documentación
  • Asistencia En horario ininterrumpido (atiende un representante)
    En línea

Datos del proveedor

  • Microsoft
  • http://www.microsoft.com
  • Fundada en 1975

Sobre SQL Server

Sistema de administración de bases de datos relacionales desarrollado por Microsoft como un servidor de base de datos, diseñado para almacenar y recuperar diferentes solicitudes. Elige tu idioma y plataforma preferidos y crea aplicaciones modernas de manera creativa. Aprovecha el rendimiento y la disponibilidad innovadores mientras convierte los datos brutos en informes significativos que se pueden entregar a cualquier dispositivo o plataforma.

Spotlight_media_placeholder

Funciones de SQL Server

  • Análisis de rendimiento
  • Consultas
  • Conversión de base de datos
  • Copia de seguridad
  • Migración de datos
  • Optimización de almacenamiento
  • Procesamiento analítico en línea
  • Supervisión
  • Acceso móvil
  • Análisis de rendimiento
  • Consultas
  • Conversión de base de datos
  • Copia de seguridad y recuperación
  • Migración de datos
  • NOSQL
  • Relacional
  • Replicado de datos
  • Seguridad de datos
  • Virtualización

Las reseñas más útiles de SQL Server

SQL Server is the backbone of my life!

Traducir con Google Revisado el 4/2/2019
Griffin B.
Senior Strategic Planning Analyst
Hostelería, 1001-5000 empleados
Ha utilizado el software durante: Más de dos años
Fuente de la reseña 
5/5
En general
3 / 5
Facilidad de uso
5 / 5
Características y funcionalidad
Asistencia técnica
5 / 5
Relación calidad-precio
Probabilidad de recomendación:
Muy baja Muy alta

Comentarios: 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!

Puntos a favor: 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.

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

SQL Server 2016 - Features Review

Traducir con Google Revisado el 20/12/2018
Senior Consultant
Hospital y atención sanitaria, 10.001+ empleados
Ha utilizado el software durante: Más de dos años
Fuente de la reseña 
4/5
En general
5 / 5
Facilidad de uso
5 / 5
Características y funcionalidad
4 / 5
Asistencia técnica
3 / 5
Relación calidad-precio
Probabilidad de recomendación:
Muy baja Muy alta

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

Puntos a favor: 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.

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

Leer más reseñas