|
|
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.
|
Editions
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. |
Muuta Julkisesti kerrottuna:
- 1.7.2012 SQL Enterpise 2008R2 tippuu hinnastosta pois
Lisensointi ja paketointi:
www.microsoft.com/SQL
Kokeiluversio:
www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx
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
http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx
|
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:
http://www.microsoft.com/licensing/about-licensing/sql2012.aspx
|
|
|
|