New Service Pack 4 is now included, containing a lot of new features, fixes and more:
SQL Server 2012 Service Pack 4 (SP4) contains a roll-up of released hotfixes as well as more than twenty improvements centered around performance, scalability, and diagnostics based on the feedback from customers and SQL community. These improvements enable SQL Server 2012 to perform faster and scale out of the box on modern hardware design. It also showcases the SQL Server product team’s commitment to providing continued value to in-market releases.
- SQL Server 2012 Service Pack 4 will include:
- All fixes and Cumulative Updates (CUs) for SQL Server 2012 up to and including SQL Server 2012 SP3 CU10.
- Scalability and performance improvements for SQL Server.
- Additional monitoring capabilities through enhancements in DMV, Extended Events and Query Plans and the ability to clone the database including statistics with DBCC CLONEDATABASE.
- New improvements based on Connect feedback items filed by the SQL Server Community.
- Some of the improvements originally introduced in SQL Server 2014 SP2 and SQL Server 2016 SP1.
For a comparing of the different SQL Server 2012 Editions, please see later in this description.
Microsoft SQL Server Overview
Microsoft SQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.
Highlights
* The AlwaysOn you need for your database stability and security
* Blazing-fast query performance with ColumnStore Index
* Rapid data discovery via Power View and PowerPivot
* Credible, consistent data via BI Semantic Model and Data Quality Services
* Scale on demand from devices to datacenter to cloud
* Write applications once, run anywhere with SQL Server Data Tools
The Enterprise Edition
The premium offering, SQL Server 2012 Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence — enabling high service levels for mission-critical workloads and end user access to data insights.
Enterprise Information Management
EIM delivers a rich set of technologies designed to improve the overall relevance and value of organizational information. Empowering people to discover and resolve problems with data and streamline existing data management processes using familiar tools like Microsoft Excel.
Key Capabilities
* Deliver credible, consistent data to the right users.
* Help ensure data confidence with easy to use tools.
* Self-service data management with the MDS Add-in for Excel.
* Improved developer productivity.
* Simplified deployment and management.
Knowledge-driven
* Based on a Data Quality Knowledge Base (DQKB) that stores all the knowledge related to a specific type of data source, and is created/maintained by the organization’s data experts (Data Stewards).
* DQKB contains multiple data domains that capture the semantics of your data.
* Acquires additional knowledge the more you use it.
* Support use of user-generated knowledge and Intellectual Property from 3rd party reference data providers.
* Build once, reuse for multiple data quality improvements.
Approachable
* Cleanse the data and keep it clean.
* Business-IT shared responsibility for data integration, data management, and data quality.
* Designed for ease of use to empower users.
* Help the consumers of data; structure the data worthwhile to them.
* Speed the adoption/conversion to a managed process by enabling users to build their own simple solutions.
* Enable business users, experts in data content rather than data management tools, to continue working in familiar tools like Microsoft® Excel.
* Increase Developer and IT Pro productivity with new SSIS usability, deployment, configuration and management enhancements.
Open and Extensible
* Windows Azure Marketplace DataMarket interoperability in DQS.
* Explore and integrate with cloud-based 3rd party reference data and user-generated knowledge.
* Integrate SSIS and DQS with the new DQS Cleansing transform to leverage the Data Quality Knowledge Base.
* Integrate SSIS and MDS with subscription views and entity based staging.
* Enable organizations to integrate existing databases, data warehouses, enterprise applications, and other heterogeneous sources of information.
* Leveraging existing data and application assets can help mitigate risk and allows the extension of Line of Business systems into analytical applications that provide a complete view across data sources.
Managed and Secure
* Build confidence in your enterprise data.
* Leverage a familiar tool, SQL Server Management Studio (SSMS), to manage SSIS projects.
* Make use of parameters as a simplified way to configure projects and packages.
* Make use of configurable logging to collect comprehensive information on package execution.
* Leverage built-in SSIS reports and views for troubleshooting package failures, performance, and data issues.
* Ensure data integrity by centralizing storage and distributing administration.
* Ensure object definitions across systems.
* Create, maintain and storage of master data structures used for providing object mapping, reference data, metadata management, and dimension and hierarchy management.
Comparing the Editions of Microsoft SQL Server 2012.
SQL Server edition | Definition |
Enterprise (64-bit and 32-bit) | The premium offering, SQL Server 2012 Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence — enabling high service levels for mission-critical workloads and end user access to data insights. |
Business Intelligence (64-bit and 32-bit) | SQL Server 2012 Business Intelligence edition delivers comprehensive platform empowering organizations to build and deploy secure, scalable and manageable BI solutions. It offers exciting functionality such as browser based data exploration and visualization; powerful data mash-up capabilities, and enhanced integration management. |
Standard (64-bit and 32-bit) | SQL Server 2012 Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud — enabling effective database management with minimal IT resources. |
Web (64-bit and 32-bit) | SQL Server 2012 Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties. |
More info.
You can find a lot more info about MS SQL Server 2012 on the internet.
Please notice:
If you have any questions about this item, please ask them before purchasing, because we don’t accept returns of opened software items (the license code is inside the wrapped box, therefore).
Picture 1 is promotional only, Pictures 2 and 3 are the actual photo of the item.