SQL Server 2012 Programmability

Create next generation database applications that support the most demanding end-user requirements.

New Unified Development Experience

• SQL Server Data Tools unifies the development experience for database development.

• A single integrated environment for database development across database, BI, and web for any SQL Server platform on and off premises within Visual Studio.

New Frameworks

• Support for the Data-Tier Application Framework dramatically simplifies the development, deployment and management of database applications across on-premises and cloud.

SQL Language Improvements

• SQL Server 2012 supports new Transact-SQL language improvements.

• Simplify complex programming tasks and ease database migrations with improved support for ANSI SQL standards.

Leverage SQL Server’s built-in data type support to easily manage relational and non-relational data as part of the database.

Choice in Data Storage

• FileTable permits organizations to store unstructured files directly in the database table.

• Remote Blog Storage allows management simplicity or externally on separate hardware for scalability.

Expanded Spatial Support

• Spatial enhancements include:

• Circular arcs on the ellipsoid (an industry first for relational database systems).

• Support for full globe spatial objects.

• Functional parity of geography and geometry data types.

• Added spatial indexing performance.

FILESTREAM Improvements

• Manages files and documents efficiently while leveraging SQL Server security and transaction support.

• Improvements in SQL Server 2012 yield improved performance, manageability and availability.

New Statistical Semantic Search

• Enables T-SQL developers to bring deep insight to the organization within non-structured data files stored in the SQL Server database.

• Reveal previously undiscovered relationships across stored data.

Choose from an array of delivery options that best suits customer needs.

New Support For Desktops

• SQL Server 2012 Express offers a new Local Database Runtime (LocalDb) deployment option.

• Ideal for developers who need to redistribute an embedded database within their desktop application or tool.

Cloud On Your Terms

• Build applications exclusively for the cloud, or hybrid applications that consume both on-premise and cloud services.

• Windows Azure Platform offers powerful database and BI functionality delivered as a service.

New SQL Server Appliances

• Microsoft is partnering with some of the industry’s most well-known and respected hardware OEM’s to offer a line of SQL Server appliances.

• Targeting a variety of enterprise scenarios.

Better with Windows Server

• SQL Server 2012 is designed to be the best database server for Windows Server.

• Offering several points where capabilities are tightly woven.