Microsoft SQL Server Enterprise 2008 R2
Microsoft SQL Server 2008 R2 continues to build on the Information Platform Vision by enabling businesses to deliver near real-time information through rich applications. Not only does SQL Server offers a complete approach to managing, accessing and delivering information across the organization; but now the power of SQL Server is extending to the Cloud through SQL Azure. SQL Azure provides a consistent program model and common tools while offering new business opportunities, high availability, and massive scale through distributed data services.
Product website: Click for the official Microsoft SQL Server Enterprise 2008 R2 website
Click for Product Description (or scroll down the page)
Trusted, Scalable Platform
Line-of-business applications (LOB) are the critical link between the IT department and the business. The ability to securely and reliably store, centralize, manage and distribute data out to users is key to these LOB applications. SQL Server 2008 provides businesses with a high performance database platform that’s reliable, scalable, and easy to manage. SQL Server 2008 R2 builds on the 2008 release and helps IT departments provide even more cost-effective scalability on today’s most advanced hardware platforms using familiar SQL Server administration tools.
IT & Developer Efficiency
There has never been greater demand for IT to provide more value with existing budgets and resources. To achieve this, they need tools and capabilities that help them maximize efficiency across the application lifecycle with streamlined management, rapid development, and predictable deployment. SQL Server 2008 R2 builds on a long history of enabling DBA and developer productivity with new tools and capabilities to help IT administrators and developers make the best possible use of time and resources.
SQL Server 2008 R2 provides new tools for managing large multi-database environments along with improved capabilities to help maximize the value of consolidation efforts, and ensure the streamlined development and deployment of data-driven applications.
Microsoft SQL Server 2008 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 2008 Compact Edition and Microsoft Synchronization Services
Consolidate data storage through the SQL Server 2008 support for relational, XML, Filestream, and geo-location-based data
Improve developer productivity by providing seamless integration between frameworks, data connectivity technologies, programming languages, Web services, development tools and data.
Build next generation data-centric applications with the ADO.NET Entity Framework
Define a rich conceptual object model based on the Entity Data Model (EDM) and logically organize database tables and columns into higher-level entities
Model database applications quickly by using the ADO.NET Entity Framework to create entities that are tightly aligned with business requirements
Remain focused on developing business solutions rather than worrying about how data is organized in a database
Understand and maintain any size of database application by abstracting the conceptual data model from how the data is stored in a database
Revolutionize data access queries with LINQ
Take advantage of native query language extensions to C# and Visual Basic .NET
Use consistent query syntax to retrieve data from diverse data stores, including entities, relational databases, XML, ADO.NET DataSets, and in-memory objects
Take advantage of the efficient data processing capabilities of LINQ, as well as design time error checking and type validation
Reduce the amount of code that is required to access data and make applications more efficient and easier to maintain
Harness Data Platform technologies with Visual Studio
Bring all of the Microsoft Data Platform technologies together in a highly productive and easy to use manner with Microsoft Visual Studio
Write code that targets rich Internet applications, client applications, and server applications; and experience a powerful end-to-end development environment
Boost productivity through Microsoft IntelliSense and built-in support for the ADO.NET Entity Framework and LINQ
Streamline collaboration between architects, developers, and testers by using Visual Studio Team System Edition