Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM Pros and Cons

Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users appreciate the data protection measures in Microsoft SQL Server 2012, ensuring security during malfunctions or damages. (1 mentions)

Users find the deployment ease of Microsoft SQL Server 2012 Standard beneficial for seamless ASP.NET integration and performance. (1 mentions)

Users appreciate the ease of use of Microsoft SQL Server 2012, benefiting from its simple interface and excellent performance. (1 mentions)

Users appreciate the easy integrations of SQL Server 2012 with ASP.NET, ensuring seamless connectivity and performance. (1 mentions)

Users value the seamless integration with ASP.NET, enhancing efficiency when managing complex data with SQL Server. (1 mentions)

Users find the complex coding of Microsoft SQL Server 2012 Standard challenging, especially for smaller applications needing resources. (1 mentions)

Users find the product expensive for small applications due to costly hosting and 24x7 availability requirements. (1 mentions)

Users feel the pricing of Microsoft SQL Server is fair, but limited availability of processing power is a drawback. (1 mentions)

Users find Microsoft SQL Server 2012 Standard has limited features, making it unsuitable for smaller applications and costly to host. (1 mentions)

Users find the limited flexibility of Microsoft SQL Server 2012 Standard restricts its processing power compared to competitors. (1 mentions)

5 Pros or Advantages of Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM

1. Data Security

Users appreciate the data protection measures in Microsoft SQL Server 2012, ensuring security during malfunctions or damages.

See 1 mentions

See Related User Reviews

Abhinay A.

Small-Business (50 or fewer emp.)

4.5/5

"One of the Best SQL Servers"

What do you like about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

Microsoft SQL server provides a simple to use interface with very good query speed and overall performance. Multiple processes are set in place to pro

2. Deployment Ease

Users find the deployment ease of Microsoft SQL Server 2012 Standard beneficial for seamless ASP.NET integration and performance.

See 1 mentions

See Related User Reviews

Verified User

Mid-Market (51-1000 emp.)

4.5/5

"Well tested SQL Powerhouse"

What do you like about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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

3. Ease of Use

Users appreciate the ease of use of Microsoft SQL Server 2012, benefiting from its simple interface and excellent performance.

See 1 mentions

See Related User Reviews

Abhinay A.

Small-Business (50 or fewer emp.)

4.5/5

"One of the Best SQL Servers"

What do you like about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

Microsoft SQL server provides a simple to use interface with very good query speed and overall performance. Multiple processes are set in place to pro

4. Easy Integrations

Users appreciate the easy integrations of SQL Server 2012 with ASP.NET, ensuring seamless connectivity and performance.

See 1 mentions

See Related User Reviews

Verified User

Mid-Market (51-1000 emp.)

4.5/5

"Well tested SQL Powerhouse"

What do you like about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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

5. Integrations

Users value the seamless integration with ASP.NET, enhancing efficiency when managing complex data with SQL Server.

Users find the limited flexibility of Microsoft SQL Server 2012 Standard restricts its processing power compared to competitors.

See 1 mentions

See Related User Reviews

Abhinay A.

Small-Business (50 or fewer emp.)

4.5/5

"One of the Best SQL Servers"

What do you dislike about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

Cost of the Microsoft SQL Server is on par wityh its competetors but unfair cause lack of extended processing power availabiliity.

G2 reviews are authentic and verified.

Here's how.

Abhinay A.

Front end

Small-Business (50 or fewer emp.)

12/24/2024

"One of the Best SQL Servers"

4.5/5

What do you like best about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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.

What do you dislike about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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

What problems is Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM solving and how is that benefiting you?

We have large scale data and to fetch relevant data and use it in operations Microsoft SQL server helps us as it is in compilance with majority of Query syntaxes and provides options to optimise our codes and reduce cost of our data operations. Review collected by and hosted on G2.com.

Verified User in Financial Services

Mid-Market (51-1000 emp.)

2/5/2025

"Well tested SQL Powerhouse"

4.5/5

What do you like best about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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.

What do you dislike about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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.

Jonathan H.

Data Manager

Mid-Market (51-1000 emp.)

6/17/2022

"Microsoft' standard SQL Server stellar for its time"

3.5/5

What do you like best about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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

What do you dislike about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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.

Nikitha S.

Cloud Engineer

Enterprise (> 1000 emp.)

4/4/2022

"Distributed Replay Controller is effective to perform replays against target database for SQL Server"

4.5/5

What do you like best about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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.

What do you dislike about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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.

What problems is Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM solving and how is that benefiting you?

It effectively captures all our production workload and can replay it against any target database according to our customer specifications. It requires installation of both Distributed Replay Controller & Replay client for capturing all events & effectively loading them into our DBA utilities. In case we set up Distributed Replay Controller and Distributed Replay client on two separate EC2 machines, we need to configure its firewall carefully so that it can easily communicate between the services. Review collected by and hosted on G2.com.

Dewi S.

DevOps Engineer

Small-Business (50 or fewer emp.)

3/8/2022

"-makes it easy for administrators -hyper-v solution -storage media -configuration"

4.5/5

What do you like best about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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

What do you dislike about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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.

What problems is Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM solving and how is that benefiting you?

Installing and optimizing windows server 2003 is much easier than windows NT. It looks more attractive than previous versions of Windows (similar to Windows XP). The rebooting process is very fast (see also: virtual memory function). Designed for the daily needs of large-scale companies Using DHCP that facilitates large-scale networking organizations. Review collected by and hosted on G2.com.

David W.

Head of Engineering - Data and Business Intelligence

Mid-Market (51-1000 emp.)

12/21/2021

"Great database environment, though newer options exist now"

4/5

What do you like best about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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.

What do you dislike about Microsoft SQL Server 2012 Standard on Windows Server 2012 RTM?

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.