Microsoft SQL Reviews

We are using SQL Server from 2014 and highly impressed with its simplicity and how its growing its capability with every version. server is a great database server with lots of features that are must for small or large scale companies. part is its user interface and simple to use.It is enabling developers to build their logic with intelligent window as well.

We are not using any training for now as most of the features are free. Thank you Microsoft. I loved this platform. I dislike the only one thing is that licencing is too costly for small companies.

We are very satisfied with software and we recommend it for completely safe and secure DBMS architecture.

We have over 2500 web pages and all have dynamic data and all are running on top of SQL Server . We also run some automatic jobs that SQL server agent is handling with ease.

MS SQL has been around long enough and has enough distribution that there is a tremendous amount of information out there for any situation that you might encounter. If you can ask the correctly you can find the answer. It's relatively tolerant to crashes and can be scaled to any size or cluster configuration needed. Lots of add ons available as well as tools for optimization and troubleshooting.

Microsoft's pricing has become borderline esoteric in it's level of complexity. SQL is now priced by CORE (not Proc), which can make it very expensive and confusing to license. It also needs proper tuning in order to work well - a small tweak can have huge performance issues.

Consider full price of ownership - you may need a consultant or full time administrator. Don't skimp on the hardware portion - you may need powerful machines to run the implementation - depending on your user load and type of implementation.

We run our ERP system on it and because it's SQL we have been able to customize the system to the level we need. Not a painless process, but it works. Because of the simplicity in connecting outside data I'm able to write connections to our Salesforce CRM to keep the two systems in sync. It's relatively easy to virtualize and run through cloud platforms as well.

We are utilizing SQL Server 2014 and past version since most recent 10 years. it is developing with every version. Easy to use interface. it allows you to make DCL, TCL, DDL and DML queries in a graphical interface. Easy to set-up. Provide Administrator, Reporting, SQL server profiler to trace queries and so many other features. Easy to learn for new trainees. its provide programming feature like stored procedure, Triggers, Indexes, Statistics, Functions, DCL DML DDL queries etc.

it consume a lot of RAM for the installation and utilization of the product. it is costly as compared to other open source software available in the market. we can install this product on window operating system. A small organisation cannot afford this product.

we have so many web pages in our different products which use Microsoft SQL server for backed to store data and process data to display on front end through stored procedure and functions

One of the things we like most about sql server is being able to work in client-server mode, which allows the information and data to be hosted on the server and for clients or network terminals to only access the information. Also, thanks to the fact that it is a tool that has been on the market for many years, it offers a powerful graphical administration environment, giving us a tool to perform ddl and dml commands graphically. It is very stable and secure and has a good community around it.

What to my point of view I see more unfavorable of this database tool is its high use of RAM memory in the use of the software, also for this reason it becomes slow at the time of installation if you do not have adequate resources. Also its price taking into account its competitors makes it a more expensive solution.

What I would recommend to other users is that if you want to implement a robust and reliable database and have a good team and the budget is not a problem, do not hesitate to use sql server

The project in which we implemented this database manager was the migration of some data from Oracle database and its interface to create ddl and dml commands in a graphical way and the ease of use allowed us to reduce considerably the time of execution of the migration.

SQL Server is best database server to working with microsoft technologies like MVC, Dotnet, WCF and etc.

It Is provide the verious functionalities like create database and tables to create stored procedure, functions and views etc. It is also provide SSRS and SSIS features.

Microsoft SQL Server is made to support millions of records across an enterprise. Because of its robust technology, it also comes with a high price.

Users also need to learn different language to setup microsoft sql environment.

SQL Server requires the .NET framework installed on a machine, which is a separate component used by developers.

I recommend SQL server to all the programmers who are working on microsoft technologies like DotNet, WCF, MVC and Webservices and wherever they need to interact with database. It provide various functionality to working with data. It provide the better security of data also.

I almost use sql server in all my project and it is very easy to use for the programmers. it help us to manage large amount of data in a normalized manner. it help us to create reports easily using SSRS tool.

What I like most about sql server is its ease of use thanks to its powerful graphical administration environment which allows you to make DDL and DML commands in a graphical way. Besides its great scalability, stability and security, it is a very mature product and has a very good community.

It also allows to work in client server mode, which allows to host the information and data in the server and the clients or terminals of the network only access the information.

What makes sql server unfavorable is the high use of ram memory for both the installation and the use of the software and the value for money compared to competitors such as oracle.

As for the implementation another unfavorable thing is that it only has support with windows operating system.

What I would recommend to other users is that if you want a robust and reliable database and have enough budget do not hesitate to use sql server.

The project consists of migrating a visual fox pro database and since it is an e-commerce page we need a robust and reliable database, also as the team was small we need to work with the tools that allow us to move forward as quickly and simply as possible and for that reason sql server helped me a lot thanks to its simple interface to use.

It is a quite complex and complete database manager, it is robust and can store a large amount of data and records, it is compatible with windows application projects with visual basic and php web projects, it has a high level of security for databases. data and access to information, also has help assistants for the elaboration of queries between related tables and is able to perform stored procedures that is very important for large projects as this allows the generation of reports.

It is very complex and difficult to install since you have to configure a variety of servers and tools so that it can work properly, besides that the consumption of hardware in the equipment that is installed is high margin, so it can not be installed in a basic features such as access and mysql, and the configuration for use must be done by a trained staff in the area which also limits its use to basic users, and if the software is not connected, work on it in a intuitive it can turn out to be very long and complicated

It is highly recommended to work on a large scale it is very safe and reliable but it is recommended to be well advised for the installation and configuration of this software since it is not easy to do

It is very good software and I use it frequently in the development of the most important administrative systems since it has a high data storage capacity and a high level of security, I have used it for the development of the company's inventory system since It has programming elements that are coupled to the system's needs such as the elaboration of stored procedures for the generation of reports and reports and also queries of tables at a high level of response to be displayed on the forms.

Esta aplicacion realmente cumple con las espectativas de la empresa, actualmente la usamos como repositorio de los sistemas administrativos que actualmente usamos, amigable y sobre todo robusta, con solo crear un scrip puedo incluir, modificar y hasta eliminar información errada cargada por los analistas (no solo de sistemas si no de otras areas) Les recomiendo antes de hacer cualquier tipo de modificación crear un respaldo de la Base de datos por seguridad, realizar las revisiones las tablas las cuales afecta esa modificación y sobre todo tener claro que deseas realizar. Por otro lado, Tiene gran soporte de transacciones y su entorno grafico te permite tener una mejor vision de lo que realizas.

La principal desventaja de Microsoft SQL SERVER es la enorme cantidad de memoria RAM que utiliza para la instalación y utilización del software. Por lo demas no tengo nada negativo que acotar.

Esta plataforma de gestión de datos e informes fiable, segura y con funciones de sincronización remota y administración orientada a la ejecución de aplicaciones en oficinas y pequeños departamentos.Toda empresa o PYME les recomiendo usar este producto.

Realmente la relación calidad precio, esta por debajo de las otras marcas de manejadores de base de datos. Adicionalmente si trabajamos en una red local nos permite agregar otros servidores de SQL Server

1)Ms SQL Server supports multiple users in one setup, which made it as multiuser system.

2)Multiple users can create their own functions and procedures.

3)Provides good interface.

4)SQL Server can be setup quickly and run without much intervention from Database Administrator.

5)Development is very easy especially for trainees because of the good user interface and better options.

6)It stores and manages relational data extremely well.

1) performance can be increased.

2) inclusion of multiple results table in the same window is much useful.

3) you have to refresh many times in order to show up the intellisense.

4)Slows down due to the many features included in it and It takes large memory as well.

5)it goes hang in low system RAM configurations.

6)Need Ai support to help the DB run more efficiently and it improves the performance as well.

For .net developers, to learn the Database integration and connectivity Ms SQL Server is highly recommended one. For trainees it is the first choice.

I used Ms sql in my training.

Las sentencias SQL son sencillas para filtrar datos de su organizacion. Permite establecer tareas que corran de forma automatica. Me parece intersante el SQL profiler para generar graficas y monitorear la informacion. Considero una buena herramienta para administrar sus datos y toda la informacion requerida por la organizacion.

Se requiere varias configuraciones para intercambiar datos entre SQL y Oracle.

Poca integracion con herramientas diferentes a microsoft.

Optimizar el manejador para mayor fluidez de los datos.

Integracion de datos, reportes de infraestructura, compartir datos de gran cantidad de transacciones, simplificar procesos que involucran a la organizacion. En la organizacion se aplico con otros tipos de base de datos oracle se aplicaron configuraciones con gateway y dblink para intercambiar datos entre base de datos distintas. La generacion de reportes actuariales, cruzar data almacenada. Procesos administrados y revision de toda la data almacenada por nuestros clientes. Es una excelente solucion para su organizacion.

Team Microsoft;

I cannot thank you enough for the flawless technical support that you’ve given me over the last couple of weeks.The titles that you created (Matthew) for the Power BI presentation were a big hit; and the Power BI dashboard extravaganza unfolded on cue with perfect precision. My colleagues were as impressed with me as I am with you. You also did a marvelous job researching the Vice President and CFO questions (Mark) and I know that I didn’t always give you much to go on and recommending exactly software for their preferences. Without your help, I don’t think I could have met the short but urgent deadline. Regarding all for the SQL Server on Microsoft Azure Public Cloud Platform Provider.

I feel much better knowing that I have such a valuable and capable resource a phone call away.

Respectfully yours;

Thanks,

Total cost benefit analysis including hidden costs on an annual basis plus options for contractual agreement, e.g. annual agreement / multi-year agreement, technical support included etc. Regarding all for the SQL Server on Microsoft Azure Public Cloud Platform Provider.

Globe access for five Data Regional Setup for Azure Machine Learning Studio

Dallas, Sweden, India, China and Brazil setup of Microsoft Azure SQL Server databases.

Using software Power BI for Analytics Platform for digital dashboards and SQL Server Reporting Services and SharePoint website access.

Creation, administration and management of the database is really easy, even for beginners. It is fast and stable and it works good with other Microsoft products. I feel right at home when I'm using SQL Server Management Studio. It has a practical UI and of course a really helpful intellisense feature. The problems which my team and I solve require fast response and fast solutions and Microsoft SQL is of great help with that.

The price of the enterprise package might be too high for smaller companies, but I think that Microsoft's target with this product are large organizations/corporations (like mine).

This is a product aimed at big companies/corporations with a lot of users and big databases. If you are a small company/team, there are some other more practical solutions. It is rather easy to use and highly practical. I need to stress again how fast Microsoft SQL is - that might a be big factor for some teams like mine.

My team handles a major part in administration and management of the database for one of the big US supermarket chains. Without getting into too many details, we run a lot of scripts and queries through thousands of items and transactions in order to find the cause of problems and bugs which happen during customer interactions with the Self checkouts. The speed and ease of use which Microsoft SQL is offering help us a lot and allows us to quickly pinpoint the issues.

To manage all of our data of various customer products, we use sql server. This is a microsoft product, so we are much satisfied with product service.

It is very reliable and easy to use tool.

We can store, process and execute very large amount of data.

Very easy to learn its programming language.

Very great features such as SQL server agent, profiler, reporting etc..

One can use for all his needs of database.

Every good tool has its own limitations.

First of all its cost. It is very high.

We need good amount of RAM to properly use this. Sometimes query stucks in between. But our organization provides a great RAM, so we don't have any issue with its speed.

I am using this tool from past 8 years. I use to manage data feom various products of my company. It is very easy to learn and manage.

I highly recommend this rdbms tool to everyone.

The query analyzer is a great tuning tool. The ability to embed really anything in a stored proc or an agent job is nice for integrating other systems or using it to manage workflows. Great tools for diagnosing production issues like deadlocks

The Intellisense doesn't keep up with your changes in the editor. There should be some kind of really good visual tool for building queries. Permissions management is a real chore. It would be nice to have some way to express business logic as a set of rules rather than just write it as t-sql in sored procs, something more analyst-friendly.

Look at the size you need to scale to, Microsoft SQL gets very expensive at scale.

We use it as the hub to move data across enterprise systems )financials, CRM, ERP, etc.). The SSO database is used to encrypt environment-specific meta data (passwords, logons, addresses, etc.).

Over the years, Microsoft finally figured out that MS SQL should run in more places - not just in Windows Server, but regular Windows and now Linux. So now you can just run whatever your platform is, and put MS SQL on it. It even has support for Macs if you can get through that process too.

The management platform is probably one of the most user friendly out there. Click, set this up, add a table, call it a day.

Some things are still esoteric, and you'll have to start looking up basic things. Like "Why can't I log into the machine and need a Windows account" or "How do I do auto-increment"? It's not difficult to figure out, but it's things that should have a "Hi, if you're using this for the first time, these are some things to look for."

Make sure that you have the instructions laid out. While it's easier than ever to install Microsoft SQL, that doesn't mean if you're running Linux or Mac that everything will just go right. Make sure you have the right versions, patches, and the like before you proceed.

I tend to use it because my clients do. In this case, a client had a custom CRM, and they ran it on SQL. Since there's enough plugins from PHP and C# into MS SQL, it wasn't that hard to make a connection so I could get the data I needed and plug it into the program.

With my experience in the use of Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft dodne Its main query language is Transact-SQL, It can also include a powerful graphical administration environment, which allows the use of DDL and DML commands graphically. It contains stability and security scalability, it also allows to work in client-server mode, where information and data are hosted on the server and terminals or clients of the network only access information. It also allows to work in client-server mode, where the information and data are hosted on the server and the terminals or clients of the network only access the information.

What I do not like is that its main disadvantages would be that it contains a large amount of RAM for the installation and use of the software. Also it only has support with Windows operating system but by experience in chat or forums of microsoft are incorporating linux for this manager in his last updates of the product.

In my case, I must implement this database manager for having applications that use it, I must say that it is a handler that facilitates transactions support, fulfills its functions and the truth is very stable and at the time of backups it is also robust.

We have third-party applications that should use only this SQL Server database manager, it would be the main benefit since without that manager the applications that we have in the organization do not run.

Very efficient RDBMS and attractive GUI based database. It allows you to modify almost every interface from the UI. I like the poweful profiler provided by Microsoft sql server that is really amazing tool for debugging the real time production issues. Profiler works as a last resort some time for fixing potentia production issues.

Does not clear up space directly after deleting the records from table and you will need to perform operations to free up the actual space on the server. Consumer much memory on the database server so designated server is must for MS Sql server.

Sql server is really a efficient RDBMS system to handle middle to large amount of data efficiently. I always recommend it.

Data management for our web application and reporting system. This is fast and excellent database and also has all required functionality.

His main tool SQL Server Management Studio it’s a great solution for DBA or Technology group, his GUI minimize tasks like backup, restore, change passwords or change security settings. For me as part of a security department it's important to audit a change user privileges with a single click. Another benefit allows us integration with other solutions (like antivirus, CRM, etc) with local solutions and cloud solutions.

For less known users try free version, then you can decided what to buy. Be part of Microsoft solutions it’s a plus, allowing us to do task with server configuration and upgrade without issues.

His price could be a pain for IT departments, if you compared against other product or free editions. Sometimes customer support take too much time to solve an issue, it’s annoying that issue only can be solved by patching. You need an experienced Microsoft Partner to deploy large environments, those partners increase licensing and services price allot. As users we need better services with lower prices.

For me the most important it’s do test on a free environment, evaluate if all your products are compatible with this solution and then contact an experienced partner.

More than a problem it's a solution for daily task and a secure environment to deploy all our services (antivirus, security, crm, etc).

Microsoft SQL has been a mainstay in data base query management for many years. It comes as no surprise that most companies with multiple systems will use Microsoft SQL to ease in searching, joining, table management and expect fast response times.

Microsoft SQL Enterprise pricing has grown steadily over the years along with the processing power needed to run all of the different applications it supports.

If you do not have a qualified Microsoft SQL Expert on your team, its well worth the additional expense to utilize a 3rd party or even Microsoft Professional services to assist in the setup of the database plus all of the connectors, monitors, tasks, etc.

We use SQL in finance, HR and Production. We would not be able to function as a company without Microsoft SQL as all of the connectors, login credentials and user interfaces would easily be supported by an alternative means.

The full capabilities of all MSQL and being able to set up in a short time. We use this across multiple servers and services. It is a good and stable product and can easily be backed up and restored when needed. I know there are other database solution available and cheaper but for us it is seamless with all of our front end solutions.

Like most people the cost of having a full version up and running, because of the need and support for this product we have to pay for our use of the product. This is really the only think at this time that I do not like about this product.

Just be prepared for the sticker shock of using it for large database. It definitely is the cost of doing business. It is a good and stable product and can easily be backed up and restored when needed.

We have 40 SQL servers up and running. We have been using a single instance of SQL to run multiple Smaller databases without impact. We have been able to backup and move databases in MSQL flawlessly with out having to have more support than needed.

With thousands of claims we receive every day, SQL handles the claims load, validation and applying business rules like a pro.

Also, with the help of SSRS we deliver a lot of reports to our clients on a daily basis.

Not much of dislikes but one thing that my client is worried about is Enterprise edition licensing cost.

If your application wants to use the latest parallelism concept then the Microsoft SQL Server max degree of parallelism configuration option controls the number of processors that are used for the execution of a

query in a parallel plan. We have implemented this on a 10 core machine which boosted to 20 core.

With InMemory online transaction processing and AlwaysOn Availability my client is very happy with the performance issues.

Also, the PowerBI tool gives a great option of showing the real time reporting.

WIth SQL fail over server we are pretty sure that the database is never down.

SQL helps querying the data for millions of records

SQL IDE makes every developer job easy

SQL server is one of the most efficient RDBMS to handle and store data. It provides a nice Graphical user interface for all components like query editor, profiler, sql resource optimizer etc. Service Updates and installation is easy. and Plug in third party utility is generally very convenient. Configuring sql server is very easy with a minimum support of technical resources. Creating reports from the query result is easy in day to day tasks.

When you run large insert/upadtes, SQL server enterprise edition is quiet heavy sometime on the production server.

One of the excellent database to efficiently manage the data and provides excellent support when used with web application.

Better handling over the data management an data replication. SQL server has been above out expectations all the time.

easy to use.

contained inbuilt tools like sql profiler for performance monitoring and debugging.

security updates are easy to apply.

we can check query execution plan, helps in improving production system performance.

easily able to import and export data to excel word or any text document.

we can easily take network backups of database.

Differential backups are very easy and helpful.

we can store very large archive dta, data even older than 10 years old or more.

As interface with each sql server version 2008 , 2012 , 2014 all new ones is similar.User can easily work with new version without difficulty.

Deadlocks queries are best traceable using this software

required licensing from Microsoft.

Required good hardware for long-running queries otherwise results into sql server is busy and software lag.

take a lot of CPU resources.

for secure and reliable database environment this is one of the best software currently present in industry.

All our production system using sql server for database management.

we are using this for daily deployment and upgrades of releases.

The ease of integration with any application. The ease of data access and usability. The ease of adding of removing users. Securing different access levels for each user. Ease of training for new employees.

Nothing I can think of right now. Overall really good experience.

Overall an excellent tool for data gathering and visualization. Excellent support and large user community.

Microsoft SQL Server is an excellent tool for any sort of applications. I have used it extensively for multiple web applications where relationships between the tables is needed. Overall capability of the server is very extensive and deep. The Analysis services feature is so great, it allows us to analyze more than Terabytes of data within seconds. The in-built user management system is great too, very few lines of personal code needs to be written to use that. In early days we used to leverage DTS processes too, which helped us analyze large chunks of data. The ease of use and access is peerless. Most the time we have to transfer data between multiple servers and the concept of Linked servers have helped us to achieve that.

The ability to have the product provide the t-sql for actions when you may want to run a process multiple times and would just rather automate it with a maintenance plan. The ability to integrate with other products is a great plus and being able to provide users with reports that they can understand.

Performance monitoring is sometimes vague, and slow. Some details can be confusing when first working with the product. It would also be nice if the SQL Management studio install did not feel like it was buried or hidden away and had a simpler installer for when not working on the actual SQL box.

MS SQL is a great tool and there are a lot of resources on the web that can be used when first getting into it. Since the community behind the application is so larger 9 times out of 10 users of MS SQL can find answer rather quickly or work together to find a solution.

SQL is used in the background of applications that I use at work. Just having the ability to use the enterprise version helps with speed and being able to provide a faster response to certain queries.

sql server is my database par excellence, what I like the most is its ide to do everything in design view, the creation of customized views, stored procedures I think it is its strength today we can also have sqlserver is linux distributions, and The confidence that a tool created by Microsoft offers us.

rather high price, the ide can consume enough resources.

if your environment is window and you want a full secure fast native database sqlserver is the product you are looking for.

The first thing we look for in the company is the security for anyone is a secret stability and how much sqlserver has grown as much as remotely as well as locally and in the cloud, it is a scalable professional data base and the most complete in the market. We need to feel that we were going the right way and sqlserver us god that security.

-His compatibility with enterprise software that needs DB integration, this environment allows us to integrate (locally or cloud) all our solutions on the main server with cluster functionality.

-As a Microsoft product, it’s easier to upgrade on Windows Server versions, even security patch is compatible with OS environment.

-SQL Server Management Studio it’s a great solution to DBA or IT departments, his GUI allow less known users to do tasks like backup, restore, change passwords or change security settings.

-If you want to run some test, there is a free version with some limitations like database size (10GB for SQL Server 2016, SQL Server 2014 & SQL Server 2012).

-As a massive product, it’s easy to implement security solutions compatible with any version of SQL and any version of Windows Server.

-As other Microsoft products, SQL Server price it’s huge compared against other similar products. They have two options for licensing (Core or CAL).

-In my company the customer support it’s not the best of all the Microsoft products, sometimes they solve the problem only with a patch and do not help with a temporary solution.

-If you have more than 10 instances on the same server running at the same with a high rate of transactions per second it’s important to work with a Microsoft Partner. There is a high RAM consumption that needs to be customized and adapted.

It’s important to configure all the details available, if you need contact a DBA or train you IT personal with Microsoft certifications.

As IT department we use SQL as the main database software for all our products (CRM, Financials, HR, security, etc).

The best features of SQL Server is the amount of flexibility one can implement. With such high flexibility, once can assure business that SQL Databases will "Always" remain available without any/very minimal downtime. With the implementation of Always On High Availability groups, log shipping and replication, one can rest assured that data loss will be very minimal even in case of heavy disasters. Being a Microsoft Development House, SQL Server also suits our needs very well providing easy and maintainable data management.

Administering SQL Server can be quite difficult at first, especially If you would like to build a top notch platform and not just deploy a single server. Fortunately, there is a lot of documentation available on the web for guidance and advise.

Ensure that at least one dedicated person in your team has a good knowledge of SQL Server administration as it can be quite difficult to maintain a healthy and secure server for an inexperienced user.

Basically it provides a data management platform where all our applications (both built in house or purchased from a third part supplier) store and mange their data. We can ensure that such data is kept available to the business at all times.

I really like the improved reliability, better performance , reduced network traffic and increased scalability. The database can be easily stream lined and installation is hassle free.The security features are better and can efficiently manager my log and data files.Aslo , it integration with Visual studio is another huge advantage to acess Databse while coding in C#.

I dislike the increased deployment cost and more complex support environment, with no IT support staff(in house) than is simpler access. It also cost more to implement than does access and deployment of a sql server system will take longer and cost more than an equivalent Acess system.

Open source product would be better

I typically used to maintain the database for identity and access management soltutions for my corporation. To scheduled automated monthly jobs, reporting , querying and production support.

My whole company uses the Microsoft SQL Server, almost every department and team makes use of the SQL Server. Basically, it is used to manipulate and store data for business purposes. Developers use this to handle data of the products on which they are working. I am using SQL server since I joined the company in 2015.

Provides good interface and intelligence help to write queries easily.

Helps to store and manipulate data.

Installation takes more time.

Due to many features included in SQL Server, it takes large memory and some times it slows down.

You need to refresh many times.

I would recommend to this software for middle size companies, or larger corporations who don't have very high transaction velocity.

Using for the backend database support.

Sql Server supports multiple inputs type like XML and JSON and process them per requirements. It has powerful tools like SQL query optimiser and resource monitor. Sql server has set of pre-defined user functions which helps in writing complex queries. Supports reporting services(SSRS) and integration services(SSIS) for data migration packages. It also supports the Hadoop integration now to exchange data between sql server and Hadoop.

Consumes very huge amount of resources on production server. When handling very large data update, it becomes unresponsive and you have to kill it by rebooting the server.

Nice RDBMS with most efficient tools to handle your day to day requirements easy. Great product to consider.

Database management and sql coding. This is a great RDBMS system which is always much above the expectation.

I like how easy it is to perform all the functions on it. I can easily handle all the sql jobs and make changes to the database. learning sql language is very easy and there is a lot of online help available. I can easily search all the issues online. Backing up the data from sql server is very easy and it helps us in case of shut down as it has the ability to recover files not closed properly.

I am not very familiar with their debugging capabilities. it would be nice I can easily learn those skills. or if that capability becomes more handy to me.

gathering data. creating reports. data analysis. business intelligence connection/interface

MS SQL Server is a robust, well-established relational database manager. Support for it exists in so many forms. Microsoft of course provides the primary source as the producer and ultimate authority on the product. However, there is an abundance of forums, blogs and users groups with a wealth of information, whether you need to troubleshoot an error, solve a problem or what tips and shortcuts for everyday tasks.

It's a Catch-22. For all of the prestige of being so feature rich and robust, it is a complex product with many nuances that differ from the version in the year 2000 to today. Managing the change and keeping up require real effort and occasionally it's best just to pay an expert.

Let's talk about licensing. If major re-sellers have people whose title and sole purpose is Microsoft Licensing Specialist, then things have gotten out of hand.

If you don't have the expertise in house, look carefully bringing in a consultant to set it up right the first time. It will work with default settings but a few hours with an expert can save a lot of time

Our primary line of business programs run on Microsoft SQL Server. It is a foundational component of our IT infrastructure and is not implemented to solve problems so much as it carries the load. You could say it solves the problem of needing a fully stable platform upon which to run the business.

It has got great security features, Enhanced performance this because it has built-in transparent data compression feature along with encryption, server’s optimum maintenance can be ensured by following effective data management practices, complexity of installing the software is minimized because of automatic updates installation

Microsoft SQL is quite a complex software and thus not as easy and user friendly, the software is quite expensive too

Microsoft SQL is great solution to data storage and retrival

store and retrieve the data as and when requested by other software applications, The university website contains a lot of information that is stored in Microsoft SQL database so this software is crucial for the website to work effectively

If you are working from scratch, it's relatively easy to set up a new database server and connectivity between clients. Everything is pretty much straightforward, given that you have some database knowledge. The DBMS allows you to easily create several things entirely in design (tables, views, etc) - which is a big plus when you don't know the entire syntax.

Some of the setups of older versions (2008 - 2012) are rather clunky and not very well made - I have had several instances of my installer being corrupt and having to redownload. The database administrator is, at some times, slow to load.

Consider all available replìcation scenarios, as newer versions contain even better features (SQL Always On, comes to mind) where log shipping or others may not be necessary.

All the transactional data for our customer is handled in Microsoft SQL. The customer requires a high availability and quick response system; where SQL helps in.

-You don’t need any coding in SQL. This means by using standard SQL you can easily manage database systems, no need to write a substantial amount of code.

-It is Portable. By this term, I mean to data portability. SQL supports PCs, laptop, tablets, servers, mainframes. We can run SQL on a local system with intranet and internet. We can easily move the database using SQL from one device to another.

-Well Defined Standards. SQL database uses an established standard, that is being used by ANSI (American National Standard Institutes) and ISO (International Organization for Standardization).

Multiple Data Views.

Using SQL language users can make different views of the database structure for the different users.

-Interactive Language. We can use this language for communication with the database. With this, we can get answers to complex queries in a few seconds.

Partial Control. Due to the hidden business rules, programmers using SQL doesn’t have full control over the database.

Cost. There are some SQL versions which have high operating cost, so it creates difficulty for some programmers to access those versions.

Interface. SQL has a complex interface that creates difficulty for some user to access it.

Yes, I would like to.

-As the name SQL implies (SQL stands for Structured Query Language) databases are designed to retrieve exactly the data you need at a given time.

-You can achieve similar results by using filters and lookup formulas, but the power of SQL will win especially with large data sets.

-Excel works very well when you have simple data structures (rows and columns), but they start to fall down when you have complicated data structures that require an unspecified number of related records. -SQL allows/requires you to model your data in related tables and allows very complex data relationships.

This application is easy to use and connectivity with database is very nice in different environments. Its a reliable tool and allows us to manage the minor to large scale data as per project requirements. This tool supports multiple data types.

Easily able to create the databases, tables, stored procedures, view etc.

Security is good enough and using its encryption feature we are able to encrypt the sensitive data in table during insert and update actions. Works on ACID concepts so this gives us highest reliability of data integrity.

Database tuning and performance improvement easily doable as this provides hints.

Its SQL profiler helps to debug the database execution properly.

Its highly responsive and parallel execution runs smoothly. We can grant privilege for user roles.

Connectivity with linked servers is awesome.

Backup process is simple and entey level developer can works efficiently.

During the use did not find any major issue in this tool. A minor thing noticed as this takes a bit more time during installation.

Good tool to manage the data with efficient integrity.

Managed the databases of internal projects in efficient way. Enhanced the databases availabilty and security. Defining the user roles for access purpose who can do what.

SQL server is simply so staggeringly amazing, most clients likely don't have a clue the amount it can do, or the amount it can deal with. It is my most loved software to utilize on the grounds that the potential outcomes for query-writing are perpetual. It gives reinforcement to all your put away information into it, by this there is no stress of loosing your information.

Versitality is brilliant, however not the best, as other new databases in the market. The memory utilization of the CPU is in every case more than ordinary in the creation explicitly by the SQL server. Extent of improvement in the profile generator for the most utilized choices.

Highly recommended as very efficient database tool.

SQL is used in the background of applications that I use at work. Simply being able to utilize the venture from assists with speed and having the capacity to give a quicker reaction to specific queries. For secure and dependable database condition this is a standout amongst the best software right now present in industry.

Microsoft sql server means everything while implementing any project application.

it helps in various way that we use in day to day life for business purpose.

-all activities like creating , updating, inserting, deleting , drop in any application,we use sql server.

-database and server is the important concept.

-if we have already ui ,then for functionalities it helps us to do the above.

-so easy

-flexible in operating

-practice is easy

-for all database, we can take back up also for future purpose

-its safe and secure for using

-privacy is so nice

-implementation and error handling is easy.

I don't feel like any demerits are there but still what i face rarely is:

- while getting large no.of data from any database table where some more than 10k users we are storing that time it is becoming so slow.

-Sometimes we are deleting or dropping database by mistakenly without taking any back up.

That time some option internally should be there for restoration.

-In tool tip all activities working functionalities should be mentioned.

Yes , i would like to.

-Crud operation

-All application perfect maintenance

-data secure and safe

-Huge no.of data getting in a simple query.

-Error handling

-Back up we can take

There are various versions of the tool which can be purchased based on your acquirement. Also it is easy to use and provides vast majority of features. Triggers and task scheduling are one of the most favoured features of mine . Also, data recovery mechanism of the tool is great. Through the use of logs, caching it provides confidence good disaster recovery system

Tool is quite costly. Also it is best suited for windows based servers so posses a challenge where user may want to use UNIX based server.

Microsoft SQL is a great tool managing your relational data effectively. It provides vast features that will help you in reporting analysis other that CRUD operations. It connects easily with various type of applications. T SQL can be used as an extension for the same.

Analysis and reporting services of the tool has helped us a lot in creating and maintaining the reports and analysing the data quite effectively for the purpose of improvement in our business.

Microsoft SQL server can be used in a wide variety of applications and as the backend of an active application. Storing and retrieving huge varieties of data in SQL server is easy and highly scalable and the transact capabilities of the SQL server ensure that if a data is not updated at the other end due to any network failures or other such issues, this doesn't lead to loss of data on either side.

Microsoft SQL server is best utilized when installed on a windows NT family of operations systems(windows server 2016,windows server 2012) simply due to the number of simultaneous connections the base OS can handle. Installing Microsoft SQL server on a client operating system such as Win 7 or Win 10 enterprise, does reduce the performance of the SQL server. Managing small amounts of data may not be affected much by this, but large enterprises should prefer using the latest hardware and a Server OS for using SQL server but this would add up the cost of operations.

SQL server is primarily used as a backend of the various applications that are hosted in our environment and also hosts a majority of the company's client data. The client data is secured and hosted on SQL server databases that has multiple mirror backups that act as DR servers. This ensures that the client data is always available with zero downtime in cases of any man-made or natural disasters.

As far as data management goes Microsoft did a great job with this SQL client. Its fast, the language is clear and easy to learn, there are tons of tools to use, its already a great product.

There is a scheduler service that needs to run to perform backups, restores etc. that I have a lot of trouble with for some reason, its always not running. I wish I can perform these task without relying on that service.

Great for data hosting and using as the back end for web based and desktop applications

We use SQL to host our database, to hold our data for web and desktop applications to access.

With SQL server it's quite manageable to work with web based applications as the response time is very fast using SQL server . It is equipped with latest security changes related to transactional changes , database partitioning . Advance features like user defined procedures, functions and tables support as well. It integrates well with other Microsoft softwares as well like visual studio using entity framework. Another advance feature includes - Repetitive actions can be managed with SQL server agent (Jobs) .

When database size increase beyond 200GB it takes a bit time to respond as compared to small database size and second is Microsoft license fees that needs to be considered here.

SQL server is must have back end for web based technologies with its advance features and application integration it's one of the best relational database to be considered.

SQL server acts as a backbone for our all projects, web based solutions are supported by SQL. With SQL complex data is converted to meaningful data.

It is a very mind boggling and complete database administrator, it is vigorous and can store a lot of information and records, it is perfect with windows application ventures with visual fundamental, it has high security. information and access to data, additionally has help colleagues for the elaboration of questions between related tables. we can perform debugging by using profiler.

The primary weakness of Microsoft SQL SERVER is the colossal amount of RAM that it uses to install and utilize the product. For the rest I have nothing negative to confine.

It is data management platform with remote synchronization and management-oriented application execution in offices and small departments. Every company or SME, I recommend using this product.You can connect your teammates on company's network with SQL Instances.This is great product for database manageent. Additionally has help colleagues for the elaboration of questions between related tables. we can perform debugging by using profiler.

Extremely cost is beneath different brands of database handlers. Further more, if we work on a local network we can add other SQL Server

I like the security measures of this software.

Every single data or information under this software is guaranteed to be safe from any attack.

Again, the software has a friendly design and dashboard, which makes it possible for you to customize it based on your own needs.

Again, the developer keenly listens to the needs of the users, and come up with the right strategy to make it a wrap.

However, the installation cost and the subscription fee for this software is the problem.

Not forgetting, that not all individuals who have adequate cash at their disposal to obtain this application.

And therefore, my call to the vendor is to reconsider this pricing.

This is a recommendable software.

Very effective and Fruitful.

Consider having it.

We aimed to improve our data management and handling using this software.

Eventually, this is the most secure and stable solution in terms of data management, but it's costly.

Integration of other monitoring software like fog light is very easy without time consumption. Great capability to handle all complex queries requirements. Suite of advance sql functions. Provide all excellent functionalities like Reporting Services, Integration Services, Job Scheduler, Resource manager, Query analyser and Profiler etc. Each of these modules are build perfectly and handles the tasks effectively. Configurable at each level. User permission is at every objects and other higher levels. Changes can be done for specific privileges at user level. Window service based Control to the server for starting and stopping the service.

Scalability is great but not the best like other new Database there in the market. CPU memory consumption is always more than normal on production specifically by the sql server. Scope of improvement in profiler for most frequently used options.

Sql server has always fulfilled the new requirements and has great features to utilize. This will always exceed your expectation for sure.

We are using it as backed of application. This is perfect for all kind of client requirements and always meets the expectation.

Microsoft SQL Server has strong support with .Net and other Microsoft software help to reduce the time for setup application framework and coding effort. It is very reliable, it provides stable performance and behaviour, it provides a wide range of feature and function which may not exist in another database

SQL Server could setup quickly on both standalone or cluster and run with little management effort, it supports multi-user mode allow us to use one server for different projects

Lacking effective client tool to working with database, it requires experience skill for performance tuning, the Documentation is too complex

Strongly recommend for all projects which use .Net framework, Microsoft SQL could fulfil all requirement for performance, scalability and reliable

We use Microsoft SQL on both local and Azure as the primary database for our project which uses .Net framework, it helps to reduce developemnt effort and increases product quality.

One of the key feature of Microsoft SQL Server is its installation which is very straight Forward nothing fancy which makes the developer or the user aware of whats this going to install and check and uncheck its feature accordingly.

Other Microsoft SQL Server which I like the most is its prices which are very competitive and cost efficient. And I can tell you this it will bring down your overall cost of operation. So choose wisely.

After all this product come directly from MS performance and security are least concerned issues.

On the things which personally I don't like is its humongous size which it take during installation on disk.

Yes, as a user of Microsoft SQL I'd Definitely suggest SQL to my peers and colleagues who are looking for solution in that direction.

Due it efficiency and performance the time takes to execute complex operation is comparatively low. Cost effective.