X

Enter Title

Text/HTML

Breakthrough performance

SQL Server 2012 enables customers to build mission-critical applications and Big Data solutions using high-performance, in-memory technology across OLTP, data warehousing, business intelligence and analytics workloads without having to buy expensive add-ons or high-end appliances. SQL Server 2014 uses a common set of tools to deploy and manage databases both on-premises and in the cloud, which makes it easier for customers to take advantage of the cloud with existing skills.

  • Greater availability
  • Breakthrough insight
  • Credible, consistent data
  • Productive development experience

Capabilities

  • Breakthrough, in-memory performance
    With SQL Server 2014, new in-memory capabilities for transaction processing and enhancements for data warehousing complement our existing technologies for data warehousing and analytics.
  • Proven, predictable performance
    SQL Server consistently leads in TPC-E, TPC-H and real-world application performance benchmarks. SQL Server is SAP-certified to run some of the most demanding workloads.
  • High availability and disaster recovery
    Gain greater uptime, faster failover, improved manageability, and better use of hardware resources through AlwaysOn, a unified solution for high availability.
  • Enterprise scalability
    SQL Server 2014 uses this scale, storage spaces and network virtualization to maximize overall infrastructure utilization.
  • Security and compliance
    Help secure data with transparent data encryption, robust auditing, extensible key management and encrypted backups. It is even easier to manage permissions for data access.
  • Consistent data platform
    Leverage existing skills and familiar tools across Microsoft's data platform with SQL Server in a Windows Azure virtual machine when migrating existing on-premises apps into the cloud.
  • Corporate business intelligence
    Build comprehensive, enterprise-scale analytic solutions with Analysis Services and simplify BI model deployment with the BI Semantic Model.
  • Faster insights for all users
    Accelerate time-to-insight, on-premises and in the cloud with SQL 2014 and Power BI for Office 365. Get richer visualizations using Power Map and Power View.
  • Scalable data warehousing
    Support your smallest to your largest data storage needs while handling queries up to 100x faster than your legacy data platform through massive parallel processing and in-memory technologies with SQL Server Parallel Data Warehouse.
  • Data quality and integration services
    Improve data quality by using organizational knowledge and third-party data providers to cleanse data through Data Quality Services.
  • Easy-to-use management tools
    SQL Server Management Studio helps you centrally manage your database infrastructure both on-premises and in the cloud. Simplify application testing on a single database using Distributed Replay.
  • Robust development tools
    SQL Server Data Tools integrate into Visual Studio and are available for download to build next-generation web, enterprise, business intelligence and mobile applications across on-premises and cloud.

Benefits

SQL Server 2014 makes it easier and more cost effective to build high-performance, mission-critical applications, enterprise ready Big Data assets, and BI solutions that help employees make better decisions, faster. These solutions have the flexibility of being deployed on-premises, in the cloud or in a hybrid environment, and can be managed through a common and familiar tool set.

  • Mission-critical performance
    SQL Server 2014 accelerates reliable, mission critical applications with a new in-memory OLTP engine that can deliver on average 10x, and up to 30x transactional performance gains.
  • Faster insights on any data
    Get to insights faster with a complete BI platform that speeds up how you access, analyze, clean and shape both internal and external data.
  • Platform for hybrid cloud
    These tools provide an easy on-ramp to the cloud for on-premises SQL Server databases, enabling customers to use their existing skills to take advantage of Microsoft's global datacenters.
  • Comprehensive database server
    Productive data management software and development tools, and equip people with powerful self-service business intelligence (BI).

Back to Top