Base de datos

Overview
Microsoft® SQL Server® 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across onpremises and public cloud, backed by mission critical confidence.

Mission Critical Confidence
Enable mission critical environments including availability and performance at low TCORequired 9s and protection
Deliver required uptime and data protection, server to cloud without wasting time and money  Help reduce downtime with the new integrated high availability and disaster recovery solution, SQL Server AlwaysOn.  Achieve maximum application availability and data protection with options to configure active, multiple secondaries and ability to quickly failover and recoverapplications.  Significantly reduce OS patching with new support for Windows® Server Core.  Eliminate idle hardware and improve IT cost efficiency and performance using Active Secondary which enables offloading of various workloads to the secondaries.

Highlights
  Get required 9s with SQL Server AlwaysOn Blazing-fast performance with xVelocity in-memory technologies Rapid data explorationvia Power View and PowerPivot Credible, consistent data via BI Semantic Model and Data Quality Services Write applications once, run anywhere with SQL Server Data Tools Scale on demand from devices to datacenter to cloud

 

 Maintain uptime during maintenance operations using enhanced online operations and eliminate planned downtime on Hyper-VTM using Live Migration.  Simplify deploymentand management of high availability requirements using integrated configuration and monitoring tools.  Help enable a more predictable and optimal restore sequence for database recovery and backup with Database Recovery Advisor.  Achieve highest level of availability regardless of whether applications are deployed on-premise or on Microsoft private or public cloud.

Blazing-fast performanceGain breakthrough and predictable performance backed by industryleading benchmarks  Experience next-generation performance across SQL Server with xVelocity in-memory technologies for both Data Warehousing and Business Intelligence.





1

http://www.microsoft.com/sqlserver/en/us/product-info/benchmarks.aspx ² http://technet.microsoft.com/en-us/library/bb964719(v=SQL.100).aspx

Significantly boost Data Warehouse query performance by 10x to 300x for star join and similar queries with xVelocity in-memory technologies.  Interact and explore billions of rows of data at the speed of thought using xVelocity in-memory technologies for Business Intelligence.  Support blazing-fast queries with dramatic improvements to Full-Text Search that offer serious performance and scaleadvances.  Accelerate the performance of I/O intensive workloads by cutting growing volumes of data ~50-60%² with compression capabilities.  Gain consistent performance for concurrent and mixed workloads by defining resource usage across different applications with Resource Governor.  Analyze query execution plans, capture database activity, optimize indexes and structures, and help ensureconsistent query performance with familiar, easy-touse management tools.  Make a bet on a trusted platform that continuously leads in industryrelevant TPC and real-world application performance benchmarks¹. Release over release SQL Server is SAP-certified to run some of the industry’s most demanding workloads.

 Help ensure security enhanced deployments and minimize surfacearea attacks by enablingonly required services through Configuration Manager—built-in services turned off by default.  Help secure end user data analytics with built-in IT controls, including new Microsoft SharePoint® and Active Directory® security models for end user reports published and shared in SharePoint.  Control database access to deployed applications while improving manageability through Contained Database...