Viimeisin kampanjatiedotteemme on ilmestynyt 16.5.22, kts tarkemmat tiedot KAMPANJA-linkistä!

Softa SuperStore

20.05.2022 • • 04:41

ark. 10.30 - 16
09 - 3424 370



 Muokkaa evästevalintoja
Näytä ostoskori
Luotettava Kumppani –yritys
Softa SuperStore - yksi Suomen vahvimmista!


Microsoft SQL Server 2012

SQL Server 2012 on merkittävä versio
Paketointi on yksinkertaistunut
  • Hintakilpailukyky säilynyt
  • CAL-hinnat ovat nouseet n. 27%
  • Muut hinnat periaatteessa ennallaan (paitsi laskenta- ja paketointimuutokset)
  • Datacenter ja Workgroup -versiot jääneet pois valikoimasta (SQL Server Datacenterin ominaisuudet ovat tuleet Enterprise-versioon)
  • Uutena versiona saataville tullut SQL Server 2012 Business Intelligence.

Asiakkaiden investoinnit turvataan ja lisenssien laskenta muuttuu

  • Voimassa olevat sopimukset eivät muutu
  • Suoritinpohjainen lisensointi muuttuu paremmin palvelimen tehoa vastaavaksi ydinpohjaiseksi (core) lisensoinniksi.
  • Ytimien laskennassa minimimäärä prosessoriin on 4 ydintä eli 4 core lisenssiä
  • Nykyisten Standard ja Enterprise versiot ylläpidossa saavat tilalle vähintään 4 core lisenssiä ja Datacenterissä 8 core lisenssiä (katso kuvake alla)
  • Nykyiset Enterprise-versiot per prosessorimallilla säilyvät sopimusten loppuun asti, mutta rajoitukseksi tulee 20 ytimen prosessorit, tätä ei saa ylittää!

Product Information

SQL Server 2012 is a robust data platform for data storage, management, business intelligence, availability and scalability. Store structured, semi-structured and unstructured data (such as images) directly within databases and provide your users with a rich set of integrated services so they can query, search, synchronise, report on and analyse data.

Take advantage of a range of new features in SQL Server 2012 including enhanced business intelligence capabilities, AlwaysOn availability, increased performance, new Data Quality Services, a new set of development tools and much more.

SQL Server 2012 is delivered in three main editions: SQL Server Standard for basic database capabilities, reporting and analytics, SQL Server Business Intelligence for advanced, self-service business intelligence capabilities and SQL Server Enterprise for mission critical applications and data warehousing.

New Features

Enhanced business intelligence capabilitiess

  • BI Semantic Model - provides a single model for scalable Business Intelligence applications - from reporting and analysis to dashboards and scorecards. Enable flexibility in design and creation of business logic including direct access to the underlying data for real-time analysis.
  • PowerPivot enhancements - features new analytic capabilities such as the ability to create KPIs, rank, perspectives, hierarchies and sophisticated business logic. Also extends the functionalities of DAX (Data Analysis Expressions) giving end users the power of building sophisticated analytical solutions with the familiarity of Excel like functions.
  • Power View ('Project Crescent') - a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, it is an interactive data exploration, visualisation, and presentation experience. It provides drag-and-drop ad hoc reporting for business users such as data analysts, business decision makers, and information workers.

New Reporting Services features

  • Reporting Services reports can now be exported in the new Microsoft Office document formats first introduced in Office 2007 for Word and Excel.
  • Reporting Services data alerts are a new data-driven alerting solution that informs you about changes in report data that are of interest to you.
  • Reporting Services SharePoint Integration enhancements provide better integration between Reporting Services and the self-service BI features.

New and enhanced data services

  • Data Quality Services - Data Quality Servers (DQS) helps you create a Data Quality Knowledge Base for improving data quality and easing data management. Profile, cleanse and match data by running Data Quality Services either as a standalone tool or integrated into Integration Services (SSIS).
  • Master Data Services - Master Data Services (MDS) have been enhanced with new Entity Based Staging that means you can load all members and attribute values for an entity at one time. Additionally, enhancements have been made to the Master Data Manager Web application, including a new Silverlight look and feel. A new MDS Add-in for Excel means data management applications can be built directly in Excel by information workers. Administrators can also use the add-in to create new entities and attributes.
  • SQL Server Integration Services Enhancements - SQL Server Integration Services (SSIS) features usability enhancements, deployment and administration enhancements, new reports for troubleshooting package operations, a new DQS cleansing transform (integrates with Data Quality Services) and more.

Improved development capabilities

  • New Visual Studio based IDE - available standalone or integrated (with source control, unit testing, etc.). It's designed for both database and BI developers.
  • Improved functionality for database developers - features declarative and model-based development, integrated tools with modern language services, the ability to work connected or offline with local testing and more.
  • Improved functionality for SSIS developers - for data flow design, undo/redo and human readable packages.
  • Data-tier Application Component (DAC) framework - support for additional objects including permissions, role memberships, synonym, CLR system types: hierarchy ID, geometry and geography, spatial index and statistics.
  • DAC Parity with SQL Azure - offers 'anywhere support' for moving a DAC database between SQL Server databases across server, private cloud or SQL Azure. Build once and deploy anywhere.
  • Microsoft Driver for PHP for SQL Server - designed for integration with SQL Server and PHP applications deploying on Windows.
  • Connectivity for Java - provides secure, highly available connectivity for Java.
  • Microsoft JDBC Driver for SQL Server - provides connectivity for Tier 1 enterprises and mission critical Java applications to SQL Server.
  • LocalDB - SQL Server Express Local Database Runtime - a lightweight version of SQL Express with a fast zero-configuration installation and a short list of pre-requisites.

SQL Server AlwaysOn

The new integrated high availability and disaster recovery solution provides redundancy within a datacenter and across datacenters to help enable fast application failover during planned and unplanned downtime.

  • SQL Server AlwaysOn Availability Groups - provide an integrated set of options including automatic and manual failover of a group of databases, support for up to four secondaries, fast application failover and automatic page repair.
  • SQL Server AlwaysOn Failover Cluster Instances - enhances SQL Server Failover Clustering and supports multi-site clustering across subnets which helps enable cross-datacenter failover of SQL Server instances.
  • SQL Server AlwaysOn Active Secondries - enable secondary instances to be utilised for running report queries and backup operations.
  • SQL Server AlwaysOn Connection Director Capabilities - multi-subnet failover - enables faster client connection failover for AlwaysOn in multi-subnet scenarios. Read-only intent - provides a way to control the type of workloads that run on HA servers.
  • SQL Server AlwaysOn AutoStat - auto-creates and updates temporary statistics needed for queries running on the readable secondary.

Enhanced performance

  • In-memory column store - provides significant speed ups for common data warehouse queries - up to 100x improvement in star join and similar queries.
  • Full-text search performance overhaul - features numerous enhancements: developers can now include properties scoped searches without having to maintain file properties (such as Author Name, Title, etc…) separately in the database. Developers can now also benefit with improved NEAR operator that allows them to specify distance in-between words as well as the order of words. In addition Full-text Search has revamped all language word-breakers to latest Microsoft editions and includes support for two more languages in Czech and Greek.
  • Full-text statistical semantic search - T-SQL developers can now query non-structured data files stored in SQL Server databases using FTS Semantic Search. It provides deep insight into unstructured documents stored in SQL Server databases by extracting and indexing statistically relevant key phrases. Then it also uses these key phrases to identify and index documents that are similar or related.


Standard Edition

For basic database capabilities, reporting and analytics. Licenced by server and CAL or processor cores.

  • Basic OLTP
  • Basic high availability
  • Basic corporate BI (Reporting, Analytics, Multidimensional Semantic Model, Data Mining)
  • Basic data integration (Built-in Data Connectors, Designer Transforms)
  • Programmability and developer tools (T-SQL, CLR, data types, FileTable)
  • Manageability (Management Studio, Policy-based Management)
  • Windows Server Core Edition support
  • StreamInsight - Basic

Business Intelligence Edition

For advanced corporate and self-service Business Intelligence capabilities. Licenced by server and CAL. Features all of the above, and...

  • Enterprise data management (Data Quality Services, Master Data Services)
  • Self-Service business intelligence (Alerting, Power View (requires SharePoint Server with Enterprise CAL), PowerPivot for SharePoint Server (requires SharePoint Server with Enterprise CAL))
  • Advanced corporate BI (Tabular BI Semantic Model, Advanced Analytics and Reporting, VertiPaq In-Memory Engine, Advanced Data Mining)
  • StreamInsight - Basic

Enterprise Edition

For mission critical applications and data warehousing. Licenced by processor cores. Features all of the above, and ...

  • Advanced security (SQL Server Audit, transparent data encryption)
  • Data warehousing (ColumnStore Index, compression, partitioning)
  • Advanced data integration (fuzzy grouping and lookup, change data capture)
  • Advanced High Availability (multiple, active secondaries; multi-site, geo-clustering)
  • StreamInsight - Advanced.

Developer Edition

Has all the capabilities and features of the Enterprise edition but can be used for development, test or demonstration purposes only (licenced per user). It cannot be used in a production environment.

System requirements

Supported Operating Systems:

  • Windows 7
  • Windows Server 2008 R2
  • Windows Server 2008 Service Pack 2
  • Windows Vista Service Pack 2
  • 32-bit systems
    • Computer with Intel or compatible 1GHz or faster processor
      (2 GHz or faster is recommended.)
  • 64-bit systems
    • 1.4 GHz or faster processor
  • Minimum of 1 GB of RAM (2 GB or more is recommended.)
  • 2.2 GB of available hard disk space

You may also review the detailed Systems Requirements for more information.

Julkisesti kerrottuna:

  • 1.7.2012 SQL Enterpise 2008R2 tippuu hinnastosta pois

Lisensointi ja paketointi:   

Hyvää lisäluettavaaa

  • SQL Server 2012 Licensing Datasheet (pdf lataus)
  • Frequently Asked Questions SQL Server 2012 - Editions and Licensing. (pdf lataus)

Materiaali englanniksi, mutta päivitetään suomeksi heti, kun materiaali saatavilla. Lisätietoa myös osoitteessa

Per-User CAL Prices Raised 15%

Uusi SQL Server 2014 julkaistaan huhtikuussa 2014

Mitä ostaa ennen uuden version ilmestymistä? Kyllä, vanhaa versiota vanhalla hinnalla ja ylläpitoa (SA), jotta saat samalla uuden version seuraavan kahden vuoden aikana ilman lisäkustannuksia. Lisätietoa SQL:n lisenssoinnista: 

Softa SuperStore
Softa SuperStore
Softa SuperStore