Microsoft SQL Server

Microsoft Sql query syntaxes are easy to learn, its structure is well designed like tables,stored procedures,and functions.Joins concepts is one of the most useful in microsoft sql.Triggers are needful concept in sql server, Its very well use full for real time applications.Views reduce the execution time.

Rollback future is not available in sql server when compare to other db's.ssms not allowed to executes the big size script files in query window.

Increase size for enterprises edition.

Easy to restore and take a backups from db.

Microsoft SQL Server is a great relational database management system. It runs well and does not take up a lot of storage. It is very user-friendly and can easily handle multiple databases. It is easy to write queries, view schemas, and analyze data.

The errors are not very helpful. They don't usually tell you what is wrong or how to fix your query.

This is a great tool to use even if you only have basic SQL skills.

My organization has databases across multiple departments and Microsoft SQL Server allows us to efficiently manage all of them. It is easy to switch between databases and manage permissions for them.

Sql server is very good DBMS. It is very much user friendly. The SQL services like SSIS and SSRS etc enhance SQL server functionality.

The license of SQL server is a little bit costly.

Good DBMS. Must use.

Microsoft SQL server is used by our organization for the back end of various applications. SSRS is used for reporting services.

I like that I can easily write queries in a straight forward environment. I can have multiple databases connected at once. It allows me to multitask in my busy schedule.

There is nothing I really can say as far as a negative. This product fulfills my needs.

If you are looking for a platform that will provide ease of use, and room for multitasking, this is a great tool.

Pulling data to assist in generating new business for clients.

1. It is very easy to store and manipulate data.

2. It provides various types of data for analysis.

3. Supports SSIS and SSRS.

1. Setup takes more time.

2. Sometimes slows down.

Used Ms Sql mainly for data analysis and have done data manipulation, Extraction, Transform and Load.

It helps in doing data analysis because of its capacity to store larger sets of data

It is easy to create the databases and the tables. Best thing I like is that it has a proper database export and import function provided to make the developer's life easier.

Installation is a bit troublesome and the cost is also a bit high.

Use views to get the correct sql querry.

This is the database server I use to integrate with all the projects I do. This confirms data security with a high standard.

SQL is the best choice for data analytics as it provides a lot more sustainability when it comes to dealing with greater and enormous chunks of data

Difficult Interface, The programmers who use SQL doesn’t have a full control over the database because of the hidden business rules.

Best database, if we want to go for relational database

With the help of SQL language, the users can make different views of database structure and databases for the different users.

The tools around and the ability to write store procedures for automation.

The price and the need of good server to run (big databases)

Use SQL Server express version first. It is free and has almost all capabilities as the paid version.

It is a very good and reliable database system, therefore you can trust company's data.

In Microsoft SQL the concept of in memory table and stored procedure.

Vertical indexing for columns doesn't work with the like operator with % symbol both the side.

Using Microsoft sql's in memory feature I'm able to increase the speed of my application.