Microsoft SQL Server

Microsoft SQL Server 2014 is a feature-rich edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.

SQL Server 2014 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.

Microsoft SQL Server 2014 is at the heart of a comprehensive data platform that enables you to access and manipulate business-critical data from a variety of diverse devices, platforms, and data services across the enterprise.

Top New Features
  • Map data structures to business entities by using the new ADO.NET Entity Framework.
  • Use consistent syntax to query diverse data through .NET Language Integrated Query (LINQ) extensions to Microsoft Visual C# and Microsoft Visual Basic.NET.
  • Create occasionally connected solutions using SQL Server 2014 Compact Edition and Microsoft Synchronization Services.
  • Consolidate data storage through the SQL Server 2014 support for relational, XML, Filestream, and geo-location-based data.

Microsoft SQL Server 2014 is a comprehensive data platform that provides the scalability, availability, security, and manageability that you need for mission-critical OLTP applications.

Top New Features
  • Implement peer-to-peer replication quickly with the new visual designer, and add nodes without stopping system activity
  • Audit all actions across the enterprise and consolidate audit reporting
  • Help protect sensitive data with automatic, transparent data encryption
  • Use Performance Studio to troubleshoot, tune, and monitor SQL Server 2014 instances across the enterprise
  • Take control of workload resource use with Resource Governor
  • Store all kinds of business data with native support for relational data, XML, file streams, and spatial data