Rich Application Development

Create departmental and enterprise applications faster by using Visual Studio 2010 and SQL Server 2008 R2 together for a more complete data platform.

Experience integrated data development

• Access data tips and the call stack, watch variables, and set breakpoints when debugging Transact-SQL.

• Work with the application database in an offline sandbox, minimizing conflicts.

• Use powerful development tools like refactoring for the database schema and Transact-SQL.

• Enforce coding standards with Transact-SQL Static Code Analysis.

• Improve productivity with connected and offline IntelliSense for Transact-SQL.

• Optimize queries by viewing the execution plan and client stats when writing stored procedures.

Manage database change

• Improve overall quality of code through check-in and checkout and other controls.

• Keep stored procedures and database code alongside application code for break-free rollbacks.

• Develop enterprise applications, such as data warehouses.

• Maintain full-fidelity, offline database schema versions.

• Compare, refactor, and incrementally deploy database schemas.

Simplify database deployment

• Speed deployments and upgrades with the new data-tier applications (DACs).

• Package the database schema along with deployment requirements.

• Create DACs from existing or new applications, on-premises or in the cloud.

• Ensure tight integration of data-tier development with associated application code.

Easily build complex event-processing applications

• Query large data streams in near real time with StreamInsight.

• Capture data from sensors, operational data, or other business-related events.

• Use StreamInsight in conjunction with Visual Studio 2010, the Microsoft .NET Framework, and LINQ.

• Integrate StreamInsight with other platforms by using adapters.

Gain more options for unlocking data and exposing it in ways that help people make better-informed decisions by using Visual Studio 2010 and SQL Server 2008 R2.

Take advantage of the Microsoft ADO.NET Entity Framework

• Interact with database through programming objects.

• Write data access code with support for lazy load, pluralization, and n-tier applications.

• Import stored procedures as functions in an entity model.

• Enjoy a robust extensibility model, including custom code generation with the Text Template Transformation Toolkit (T4).

Expose data as a service with the Open Data protocol

• Use the Open Data protocol (OData) to incorporate data previously hidden in isolated silos.

• Bring data into a variety of applications, including with PowerPivot for Excel.

• Build easily queryable and updateable services.

• Use out-of-the-box OData clients for .NET, Microsoft Silverlight, AJAX, PHP, and Java.

Get creative with reporting

• Build better experiences for reports embedded in applications.

• Take advantage of additional API capabilities for JavaScript, AJAX, and extended control.

• Customize the look and feel of reports according to business requirements.

• Create custom report parts, report models, and Reporting Services extensions.

Create compelling data-driven experiences that people can use to derive important business insights, and take advantage of new features to build more useful solutions in shorter amounts of time.

Easily bind data for WinForms, Silverlight, and WPF

• Use drag-and-drop features to bind data to Windows Presentation Foundation (WPF) applications.

• Easily create new applications against a database.

• Bind data to rich Internet applications and Microsoft SharePoint Server data.

• Perform drag-and-drop operations for forms for WinForms and Windows Presentation Foundation.

Enable powerful, user-generated BI solutions

• Provide people with powerful, collaborative BI tools that pull data from various sources.

• Take advantage of PowerPivot for Excel to give secure data access to a broad set of users.

• Send feeds through business logic to ensure that users receive meaningful information.

• Correlate data from SharePoint Server, creating "data mashups" within Excel.

• Use an Internet data feed, custom data feed, or Reporting Services report as a data feed.