Microsoft SQL server provides a simple to use interface with very good query speed and overall performance. Multiple processes are set in place to protect data in case of any malfunctions or damages to centers. Review collected by and hosted on G2.com.

Cost of the Microsoft SQL Server is on par with its competitors but unfair cause lack of extended processing power availability. Review collected by and hosted on G2.com.

It should be go to database and environment for anyone working on ASP.NET due to seamless integration with the application and ease of connection with SSMS (SQL Server Management Studio). If is perfect for applications that heavily rely on Stored procedures in their applications. In our case particularly, we used Recursive CTEs a lot as we hade complex nested data but never faced any performance issue. Review collected by and hosted on G2.com.

The product is not ideal for small application due to it requiring expensive hosting environments. It is not available on demand and needs to be up and running 24x7. Review collected by and hosted on G2.com.

- uses Microsoft's own Transaction SQL script, giving integrity to data so something can be committed or rolled back.

- despite cost, its much cheaper than Oracle

- known dependable enterprise grade app Review collected by and hosted on G2.com.

SQL Server 2012 is end of life soon (2022-07-01)

No Drop If Exists (this came in 2016)

No support for XML or JSON (this also came later) Review collected by and hosted on G2.com.

Microsoft SQL Server offers transaction statements that can be grouped together within a stored procedure for convenience. It takes the input parameters & provides accurate output values when calling a method to perform specific operations. Its security features protect the database objects and carry code encapsulation for each line of code to execute our stored procedure in a secured manner. Review collected by and hosted on G2.com.

Since it's deployed through Amazon Machine Image (AMI), we needn't worry about security layer configurations, regulatory updates and version control management as AWS takes care of the underlying infrastructure. Since its Cloud-based EC2 instance, auto scalability can be provisioned based on our network traffic between our client and server. It is supported on multiple platforms and we don't have to install licenses as it comes along with EC2 for a nominal cost. Review collected by and hosted on G2.com.

-storage media -configuration

Windows server 2012 has a sharing and storage management snap-in feature that provides server role files to make and manage volume and sharing easier. Here there are two facilities, namely the provision storage wizard which is an integrated storage provisioning to perform tasks such as creating a new LUN, specifying LUN type, unmasking LUN, and creating volume formating. Wizard also supports a wide range of protocols such as Fibre Channel, iSCSI and SAS. Review collected by and hosted on G2.com.

Operating costs are quite high If the server is in trouble, the entire network will experience interference. Its security level is still low, although it is already better than its predecessor. There are quite a lot of unnecessary (useless) services. Difficult to implement Active Directory (AD) Review collected by and hosted on G2.com.

I've been a SQL Server fan since I began using it with version 6.5 in the mid 1990's. SQL Server 2012 was a solid, stable, and easily implemented version of SQL Server with all the tools - SSRM, SSIS, etc. It ran effortlessly on Windows Server 2012 also. There was a lightweight Web edition too with reduced licensing cost and complexity. Review collected by and hosted on G2.com.

One thing about SQL Server 2012 which, thankfully, Microsoft resolved in later versions was when you exported query results in SSMS to CSV or tab-delimited format it never included the column headings! Review collected by and hosted on G2.com.

1> User friendly

2>UI is very good

3> Performance is Nice Review collected by and hosted on G2.com.

1>As of now I don't have cons for MS SQL 2012 server Review collected by and hosted on G2.com.