Other notable new features for SQL Server 2012 include greater integration with the SQL Azure cloud solution, which allows databases to be delivered over the Internet and local databases to be synchronized. SQL Azure is managed in SQL Server Management Studio. The new Contained Databases function makes it much easier to move databases and their dependent objects.
With Columnstore-Index (Transact-SQL) a Standard for storing and querying large data warehouse tables is introduced. Columnstore-Index uses column-based data storage and processing to deliver up to ten times better query performance than traditional row-based storage.
Last but not least, the new SQL Server Data Quality Services (DQS) allow you to create a knowledge base that can be used to perform important data quality tasks such as standardization, correction, extension and deduplication of data.
The Microsoft licensing model was also adapted to the current performance of modern server systems. Even the Standard SQL Server 2012, which is available in both 32 and 64 bit versions, has a connection to the cloud. This can be purchased either with a core license or with a server license plus CALs. Each SQL Server 2012 edition has different rules for proper licensing. See below for details.
SQL Server 2012 is also compatible with the older Windows 7 and 8. With a license of SQL Server 2012 you get an extremely powerful server software, which can be used in many scenarios.
Microsoft SQL Server 2012 is available from Wiresoft in the following editions and at an unbeatable price
- SQL Server 2012 Standard
- SQL Server 2012 Business Intelligence
- SQL Server 2012 Enterprise
The SQL Server Standard edition already contains many features for use in daily business as well as comprehensive administration tools to meet the requirements of smaller companies and organizations, including
virtualization and data security.
The Business Intelligence Edition adds another member to the number of server editions available for SQL 2012, with the Premium Edition, SQL Server 2012 Enterprise, providing end users with the broadest portfolio of features and services to build scalable yet highly available SQL Server applications.
We will be happy to advise you on the purchase of the SQL Server edition that best suits your needs and put together a tailor-made server license package for you.
Brief overview of the SQL Server 2012 editions
In addition to the editions Standard - for small to medium-sized companies - and Enterprise, with the full range of functions - developed for the requirements of medium-sized to large companies and organizations - the new Business Intelligence Edition is the new member of the extensive SQL Server family, to which further editions belong. As the name suggests, the BI Edition is designed to meet the needs of organizations that want to deploy powerful tools for typical business tasks.
SQL Server 2012 is available as a 32-bit version in addition to the 64-bit version, but we recommend installing the 64-bit version. For the editions Standard, Business Intelligence and Enterprise the maximum size of the databases is limited to 524 PByte (Petabyte).
Key Business Intelligence Features of the SQL Server 2012 Version
With the comprehensive SQL Server BI capabilities of the 2012 version, organizations can implement a working BI platform. This includes extensive reporting and analysis functions. The most important BI features include the following:
- BI Semantic Model (BISM): With the BI Semantic Model, SQL Server 2012 provides a tool for creating models in SQL Server Analysis Services (SSAS) and Powerpivot for Excel - the latter allows administrators to create purely tabular models.
- Semantic Search for Business Intelligence: Semantic Search extends the existing full-text search functionality in SQL Server with new scenarios that go beyond keyword searching: Semantic Search allows you to query for similarities between documents, analyzing their respective meaning.
- SQL Server PowerPivot for SharePoint: With SQL Server PowerPivot, the SharePoint Server is connected to SQL Server 2012 in order to use the corresponding functions. With PowerPivot, data stored locally in Excel spreadsheets or Access databases can be made available to other users and quickly analyzed.
- Analysis Services in SQL Server 2012: SSAS provides solutions for creating and deploying analytical databases that can be used in BI applications such as Excel, Performance Point, Reporting Services, and more. The Analysis Services instance is designed for different types of solutions: Administrators can choose between a multidimensional or tabular solution.
- SQL Server Data Tools (SSDT): SSDT is the successor to Business Intelligence Development Studio in SQL Server version 2008 R2, which enables you to create data warehouses and manage Analysis Services in SQL Server 2012.
- Column Store Indexes: Column store indexes in SQL Server 2012 are an efficient tool for typical data warehouse applications. They allow you to group and manage and retrieve data in a column-based data format. All columns are linked together to create an overall index.
- Data Quality Services (DQS): The Data Quality Services (DQS) enhance processes such as data cleansing and data matching in SQL Server 2012. DQS cleanses and optimizes data records by finding and eliminating duplicates or inconsistent data before it is used for reports in the Reporting Services or data warehouses.
- Power View: Another BI feature is Power View, an add-in for the SharePoint server. Power View is a Web-based dashboard tool for data analysis and building ad-hoc reports that enables rapid data visualization.
The current licensing model for SQL Server 2012 from Microsoft
For SQL Server version 2012, the changed license metric applies. Microsoft defines the type and need of licenses available per server edition. This means that there are different licensing options for the SQL software.
The processor license known from earlier versions no longer exists. It has been replaced by the core licensing, where each core must be licensed by all processors of a server. If the server performance based on the cores had not played a role in the licensing of older Microsoft Server versions, their number is the starting point for the SQL Server Enterprise editions to calculate the license requirement. Thus, the growing performance of servers that can handle higher workloads and that is enabled by the number of cores becomes the basis for licensing.
Virtual servers can also be equipped with server/CAL licenses, among other things. As with the Standard, additional client access licenses (CALs) are required in addition to the server licenses. With core licensing, however, no CALs are needed to access the server.
SQL Server 2012 licensing options overview
This overview shows the different licensing types for the SQL Server 2012 editions available from Wiresoft:
- Standard Edition (SE) - here you can choose between licensing with cores or per server plus CALs
- Business Intelligence Edition (BI) - can only be licensed per server plus CALs
- Enterprise Edition (EE) - only core-based licensing is possible
Licensing of the Standard
The Standard of SQL Server Version 2012 is the only one to offer the choice between 2-core licensing and server/CALs licensing. This is due to the fact that Microsoft distinguishes between the different requirements of small and medium-sized companies compared to larger and larger companies, which makes the
performance as well as the scalability of SQL functions. With the most affordable licensing alternative of Server & CALs, they can also take advantage of the power and rich cloud capabilities of SQL Server 2012 in the enterprise, adapted to lower, but usually sufficient server performance for their needs.
However, even organizations and companies of smaller size sometimes need the full SQL power, which can only be covered by a core license. To purchase the appropriate licensing form for the SQL Server Standard from the start, you should
First look at the typical workloads and also the number of employees using the SQL Server services. Under certain circumstances, it can therefore be advantageous to purchase core licenses.
The following section explains the differences between the two licensing options for SQL Server 2012, to find out which licensing of the Standard is best for your organization, contact us for a consultation, or use the chat.
Licensing of SQL Server Standard and Enterprise Edition with 2-core packages
SQL Server 2012 core-based licensing is subject to the following requirements according to criteria established by Microsoft:
- Each core license is valid for exactly two cores - not the pure number of cores per processor is counted, but also the number of cores per engine:
- The minimum number of cores is always 16 - regardless of whether an engine actually has fewer cores.
- A server with fewer cores than 16 cannot be licensed at a lower price.
- The core licenses are only available as packages of 2.
This means: You must purchase at least 16 core licenses = 8 packages of the 2-core licenses. The additional licensing with user or device CALs is not necessary.
Server/CAL Licensing for SQL Server 2012 Standard and Business Intelligence
Licensing SQL Server 2012 Standard or Business Intelligence with a server license plus additional Client Access Licenses (CALs) consists of the following two components:
- Each server requires a separate license. This license includes admin access rights, which are exclusively intended for administration.
- Every employee who is to use the server services and functions needs a client access license (CAL).
- These CALs are available in two variants: as User CAL and as Device CAL.
- A client access license cannot be transferred or used in any other way than specified once it has been granted.
Licensing Microsoft SQL Server 2012 with Wiresoft at a special price
Wiresoft offers the SQL Server 2012 version in the editions Standard, Business Intelligence and Enterprise as original Microsoft licenses at a very reasonable price. The reason why Wiresoft's software prices are so low is that the offered licenses are unused, free usage rights, which originate from European companies and were acquired by us completely legally. The purchase and resale of software products such as server licenses was expressly permitted in a European judgement.
You can therefore be sure that you are buying a fully operational license package from Wiresoft, which is 100% usable and has also been thoroughly checked for authenticity.
Many customers already rely on Wiresoft's unusual licensing offer to save costs - including expert advice. If you have any questions about the most advantageous licensing with Microsoft SQL Server 2012 Editions, please contact us.