Updated: July 13, 2020 (December 19, 2011)

SQL Server 2012 Improves Tools, BI for Developers

Wes Miller analyzes and writes about Microsoft’s security, identity management, and systems management technologies. Before joining Directions on Microsoft, Wes... more

SQL Server 2012, due in the first half of 2012, looks like the most significant SQL Server release for application developers since SQL Server 2005. Among many improvements for developers, it provides a simpler, unified development environment for all database and business intelligence (BI) tasks; a new, more approachable BI stack; and new full-text search functionality that will benefit developers whose applications store documents and other kinds of unstructured data in SQL Server databases. However, the new version delivers a small number of changes that could break existing applications.

Unified Development Experience

For developers, SQL Server 2012 delivers a stand-alone environment, SQL Server Data Tools (SSDT), and a set of plug-ins for Visual Studio (VS) 2010. SSDT handles all SQL Server 2012 development tasks. Previous versions of SQL Server have provided more than one development environment for SQL Server developers, including the following:

Visual Studio (VS 2008 shipped

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now