Microsoft SQL Server 2012 Standard 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.
SQL Server 2012 Standard is a complete data platform for departments and small organizations. It provides core data management functionality, limited business intelligence for operational reporting and functional data marts, and built-in developer tools. Standard Edition can be licensed in either the core-based licensing model or the Server + CAL licensing model.
Scalable data warehousing
Scale to petabytes for relational data warehousing and integrate with non-relational sources like Hadoop. Support your smallest to your largest data storage needs while handling queries up to 100x faster than your legacy data platform through massive parallel processing and in-memory technologies with SQL Server Parallel Data Warehouse.
Data quality and integration services
Integration services includes rich support for extract, transact and load (ETL) tasks, and the ability to run and manage as a separate SQL Server instance. Improve data quality by using organizational knowledge and third-party data providers to cleanse data through Data Quality Services.
Easy-to-use management tools
SQL Server Management Studio helps you centrally manage your database infrastructure both on-premises and in the cloud. Added support for Windows PowerShell 2.0 automates management tasks and enhancements to Sys Prep let you more efficiently create virtual machines. Simplify application testing on a single database using Distributed Replay.
Robust development tools
SQL Server Data Tools integrate into Visual Studio and are available for download to build next-generation web, enterprise, business intelligence and mobile applications across on-premises and cloud. Customers can use industry standard APIs (ADO.NET, ODBC, JDBC, PDO, and ADO) across varied platforms including .NET, C/C++, Java, Linux, and PHP.
- Max 16 cores
- Basic OLTP
- Programmability (T-SQL Data Tyes FileTable)
- Manageability (SQL Server Management Studio Policy-based Management)
- Basic High Availability
- Basic Corporate BI (Reporting Analytics Multidimensional Semantic Model Data Mining)
- Basic Data Integration (Built-in Data Connectors Designer Transforms)