The Most Comprehensive, Intelligent Database Platform For Modern Enterprise
SQL Server 2012 Standard - 4 Core License - Unlimited Clients - Faster, Safer, & More Intelligent Than Ever
01
Industry Leading
Build mission-critical, intelligent apps across all workloads for online
transaction processing (OLTP) with the help of familiar tools like Excel.
02
Advanced Security
Protect data at rest and in motion. SQL Server 2012 is the least vulnerable
database made by Microsoft with breakthrough scalability, and performance.
03
End-To-End Mobile BI
Server 2012 introduces a way to output native SSRS reports to ios and windows
mobile devices effortlessly.
04
Advanced Big Data Support
Managing both structured and unstructured data with Parallel Data Warehouse
(PDW) connector to transfer the data between Hadoop and SQL Server.
05
Made For Hybrid Cloud
Get a consistent platform and tooling for easier workload mobility between
your datacenter, private cloud, or Microsoft Azure.
Faster Queries
Users want to access the data as soon as you share it with them. The Microsoft SQL Server 2012 comes
with various such options to enable faster queries. Memory-optimized tables are compatible enough to
support faster online transaction processing (OLTP) workloads with better performance due to new
parallel operations.
In-Memory OLTP Enhancements
This accelerates transactional workloads with great coexistence and
too many locks by moving data from disk-based tables to memory-optimized tables and by
compiling native stored methods. It can also help in improving the data storage staging
process by using memory-optimized, non-durable tables as staging tables
In-Memory Analytics
Get more options to perform real-time analytics on speedily
changing storage data. The resource conflicts are quite reduced now which used to occur
between the two workloads when they ran simultaneously. When changes are made to a table,
the database engine automatically maintains the changes for the index to ensure it stays up
to date with the underlying table.
Analysis Services Enhancements
Analysis Services offers two different modes to aid in the rapid
analysis and reporting: multidimensional and tabular. Both of these modes are present in SQL
Server 2012 to improve the performance. DirectQuery brings in a simpler and better query in
SQL Server 2012 as compared to its previous versions.
Remove Bottlenecks, Expand Business
A slow-performing business or unavailable database can create hurdles in the daily functioning of the
organization. But with SQL Server 2012, you can deploy and manage databases with ease. Now, you can
work from anywhere and anytime with cloud integration.
Flexibility in Audits
SQL Server 2012 makes the auditing process easy for users. Now you can customize and
choose which events to write in the audit log by filtering them with ease.
Broader Data Access
SQL Server 2012 is an upgrade from its predecessor 2008 version. It delivers
licensing three main editions that allow you to run the software in a variety of
different cloud environments and simplifies acquisition.
SQL Server Standard Edition
The Standard Edition helps deliver basic reporting, database, and analytics capabilities.
SQL Server Standard Edition
The Standard Edition helps deliver basic reporting, database, and analytics
capabilities.
SQL Server Business Edition
With the Business Intelligence Edition, you can work with premium corporate
and self-service business intelligence (BI).
SQL Server Enterprise Edition
The Enterprise level edition is perfect for handling mission-critical
applications and large-scale data warehousing.
Other Features
01
Higher Availability- Always Online
It is more important than ever to maintain uptime and optimize maintenance
activities for your business-critical applications. This new feature makes the database
mirroring more efficient than ever and lets you manage business better.
02
Faster Analytics Features
Ensure better and faster analytics features with SQL Server 2012. The
improvements to tabular models provide more flexibility in designing models, and a
variety of new tools which help you develop solutions fastly and easily.
03
SQL Server Reporting Services
The SQL Server 2012 enables a more modern development environment with
better parameter layout options, and two new data visualizations to its report
developers.
04
Improved Azure SQL Database
Integrating new functionality into the SQL Database prior to the SQL
Server, the development team can leverage a full test and telemetry cycle at a scale,
allowing them to add features to both products more quickly.
Microsoft SQL Server 2012 Standard
SQL Server 2012 is here to take out the fear from you! Now you can have complete and optimized control of
your data. It gets you more equipped with the evolving data world all around you. Managing your database
with the cloud is made quite easy and simple as it comes with some of the brilliant new tools. Now you
can get the most detailed reports ever with the most advanced analysis SQL Server has ever had. Get the
most out of your data without compromising its integrity - SQL Server Standard 2012 is the most secure
version to securely manage your business data. Regardless of how you interact with your data, SQL Server
2012 gives you the tools to gain deeper insights, improve security and performance, and extend your
databases in hybrid environments.
Compare SQL Server 2012 - Standard and Enterprise
| SQL Server 2012 Capabilities |
Standard |
Business Intelligence |
Enterprise |
| Licensing Options |
Core-Based or Server+CAL |
Server+CAL |
Core-Based |
| Windows Server Core Edition Support |
|
|
|
| Basic High Availability |
|
|
|
| Basic OLTP |
|
|
|
| Basic Reporting & Analytics |
|
|
|
| Programmability & Developer Tools(T-SQL, CLR, Data Types, FileTable) |
|
|
|
| Manageability(Management Studio, Policy-Based Management) |
|
|
|
| Enterprise Data Management(Data Quality Services, Master Data Services) |
|
|
|
| Self-service Business Intelligence(Power View, PowerPivot) |
|
|
|
| Corporate Business Intelligence(Semantic Model, Advanced Analytics) |
|
|
|
| Advanced Security(Advanced Auditing, Transparent Data Encryption) |
|
|
|
| Data Warehousing (ColumnStore Index, compression, partitioning) |
|
|
|
| AlwaysOn High Availability |
|
|
|
| StreamInsight |
Basic |
Basic |
Advanced |