SQL Server 2008 Technologies

SQL Server delivers a wealth of features grouped by core technologies that enable you to easily consume and understand the breadth of capabilities available for your business.

Analysis Services- SQL Server 2008 helps enable organizations to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar tools.

Data Mining – Predictive Analytics SQL Server 2008 empowers informed decisions with predictive analysis through intuitive data mining, seamlessly integrated within the Microsoft Business Intelligence platform and extensible into business applications.

High Availability – Always On Microsoft SQL Server 2008 Always On Technologies provide a full range of options to minimize downtime and maintain appropriate levels of application availability.
Integration Services -SQL Server 2008 provides a scalable enterprise data integration platform with exceptional ETL and integration capabilities, enabling organizations to more easily manage data from a
wide array of data sources.
Manageability- SQL Server 2008 provides a policy-based system for managing one or more instances of SQL Server along with tools for performance monitoring, troubleshooting, and tuning that enable administrators to more efficiently manage their databases and SQL Server instances.

Performance and Scale- SQL Server 2008 provides a comprehensive data platform that can grow with your business. SQL Server 2008 is packed with technologies to scale-up individual servers, and scale-out very large databases, and tools to optimize performance.
Reporting Services- SQL Server 2008 Reporting Services provides a complete server-based platform designed to support a wide variety of reporting needs including managed, enterprise, ad- hoc, embedded, and Web-based reporting, and enable organizations to deliver relevant information where needed across the entire enterprise.

Security- SQL Server 2008 offers security feature enhancements that help provide effective management of security feature configuration, strong authentication and access control, powerful encryption and key management capabilities, and enhanced auditing.
Spatial Data-SQL Server 2008 delivers comprehensive spatial support that enables organizations to seamlessly consume, use, and extend location-based data through spatial-enabled applications which ultimately helps end users make better decisions.

SQL Server 2008 Data Platform Technologies

ADO.NET Data Services Microsoft ADO.NET Data Services provides a first-class infrastructure for the next wave of dynamic Internet applications by enabling Web applications to expose data as RESTbased data services that can be consumed by client applications in corporate networks and across the Internet.
ADO.NET Entity Framework The Microsoft ADO.NET Entity Framework is an evolutionary step in data development. It simplifies data access code in applications by enabling developers to create a customizable conceptual model for data from any source, and easily map it to business requirements.
LINQ LINQ is an exciting evolution in data programming that enables developers to build queries over data directly from within any .NETbased programming language. LINQ to Entities, LINQ to DataSet, LINQ to SQL, and LINQ to XML are key implementations of this powerful technology.

Native Data Access Enhanced SQL Server 2008 Native Client provides a high-performance, versatile, data access library that enables developers to take advantage of the new capabilities of SQL Server 2008.
Sync Framework The Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services and devices. Developers can build sync ecosystems that virtually integrate any application, any type of data, using most protocols over virtually any network.