SQL Server 2012 w/SP1 - 2 Core Licenses
Unlimited Clients Additional licenses available SQL Server requires a minimum of four core licenses to function.
Additional licenses are sets of 2. Allows unlimited number of clients/users. Product Features
SQL Server 2012 core based will provide Mission Critical Confidence with greater uptime, blazing-fast performance and enhanced security features for mission critical workloads; Breakthrough Insight with managed self-service data exploration and stunning interactive data visualizations capabilities; Cloud On Your Own Terms by enabling the creation and extension of solutions across on-premises and public cloud. SQL Server 2012 Standard offers basic database, reporting, and analytics capabilities:
• Basic OTLP
• Manageability through SQL Server Mgmt Studio and Policy Based Mgmt
• High Availability
• Corporate BI - Reporting, Analytics, Multidimensional Semantic Modeling, Data Mining
• Basic Data Integration - Built in Data Connectors and Designer Transforms SQL Server Standard Licensing is available through the traditional server+client model, where the user must license the software on the server plus each user or device client station that accesses the server. For example, if there is one database server and five users accessing that server, the user must purchase 1 server with 5 CALs. The new licensing model for 2012 is Core Licensing. With Core Licensing, you can have an unlimited number of users accessing the server - ten, one hundred, or even ten thousand. You license the number of physical cores on the server. For example, if you have an 8 core server, then you will need 8 Core licenses. Core licenses are sold in packs of two.Benefits
• Serve data to a customer relationship management (CRM) platform
• Analyze data collected by your organization
• Support a dynamic website or intranet site Capabilities
• The online transaction processing (OLTP) engine allows quick access to large amounts of data.
• Failover clustering support minimizes disruption of service by connecting to other servers to provide service in case one fails.
• The online analytical processing (OLAP) and BI Semantic Model (BISM) multidimensional models allow you to analyze multidimensional data from multiple perspectives and in a tabular model.
• SQL Data Tools provide a development environment for developers, integrated with the .NET framework and Visual Studio, to build web, enterprise, and data-aware mobile applications on premises and in the cloud. Interface The management interface is SQL Server Management Studio, a graphical management tool for all SQL Server components with rich scripting capabilities. SQL Server Management Studio includes Policy-Based Management, which can create policies that manage entities on the server, such as the instance of SQL Server, databases, and other SQL Server objects. Licensing This product operates on a core-based licensing model. Under this model, you will need to license all cores in a physical environment. In a virtual environment, the same minimum requirement applies to virtual cores allocated to virtual machines. CAL’s not required. This model allows you license a physical, virtual, or cloud-based server based on computing power. It is most appropriate for administrators who:
• Do not know the exact number of users and devices that will connect to the server
• Have workloads that face the Internet or an extranet
• Have systems that integrate with external-facing workloads MOLP (Microsoft Open License Program)
