Top new features in SQL 2008
– Use Resource Governor to manage concurrent workloads.
Ensure consistent performance by using Resource Governor to define resource limits and priorities for different workloads and enable consistent performance.
– Enforce policy compliance consistently across the enterprise with the Declarative Management Framwork.
Manage your enterprise data infrastructure easily with Declarative Management Framework (DMF). Reduce the time spent on daily maintenance operations by defining a common set of policies for most database operations like query optimizations, naming conventions, backup and restore operations, and index management. Apply policies to many servers for consistent management across the enterprise.
– Reduce storage requirements and increase query performance with data compression and sparse columns.
Reduce your storage costs and improve performance of large I/O bound workloads by using data compression
– Protect sensitive data with Transparent Data Encryption and advanced auditing.
Dynamically encrypt your valuable data within an entire database, data files, or log files, without the need for applying application changes. Minimize exposure for security attacks by using Surface Area Configuration to enable only the services you require.
– Troubleshoot, tune and monitor SQL 2008 instances across the enterprise with Performance System Analysis.
Enable Performance System Analysis by collecting performance data from your system and storeit in a centralized data repository. View reports to benchmark and analyze system performance and health.
– Build high performance analysis solutions with scalability, performance, data mining, and user interface enhancements in SQL Analysis Services.
Drive business intelligence throughout your organization, manage reports and analysis of any size of complexity and empower user by providing powerful visualization.
– Take advantage of improved Performance, usability, visualization, and integration with the 2007 Microsoft Office Suites in SQL Server Reporting Services.
Empowers users to answer complex questions by providing the relevent information through reports with powerful visualizations and rendered in Microsoft Office Word and Microsoft Office Excel. Enable users to create complex reports and share them internally and Externally with customers and partners.
– Integrate location-enabled application through support for spatial data.
Introduction of new Geography data type to store geodetic spatial data and perform opertaions on it. Also introduction of new Geometry data type to store planar spatial data and perform operations on it.
– Accelerate Development
Access data by defining business entities instead of tables and columns with the ADO.NET Entity Framework. Query and retrieve these entities natively within any .NET language with Language Integrated Query (LINQ). Enable developers to work with the logical entity model, and administrators to define the physical implementation of the model as tables and columns.
– Access your data from anywhere
Create flexible, occasionally connected applications that can function when disconnected from the network. Create a next generation of applications that can work on a local data store and automatically synchronize the local store with a central store when a connection is available.
– Store and consume any type of data
Use the new FILESTREAM datatype to manage unstructured data such as documents and images outside the database. Store XML efficiently and enable easy access with XQuery. Improve the handling of temporal data by using new date and time data types.
– Integrate any data
Scale and manage large numbers of users and data with improved query performance on large tables. Optimize queries for data warehousing scenarios, and increase I/O performance with efficient and cost effective data storage. Integrate growing volumes of data from disparate systems with the scalable data integration features of Integration Services. Consolidate real-time data into the data warehouse with Change Data Capture functionality.
– Drive actionable insight
Provide a consistent set of KPIs and business metrics to all users by using the comprehensive and scalable analysis platform fo SQL Server Analysis Services that has intutive acess through Office Excel. Integrated Ata Mining enables predictive analysis so you caninvestigate common issues like forecasting and identifying key influences for decisions, Develop scalable analysis models with enhanced designers that incorporate best practices into design experience, Increce the scale and performance of analysis by using enhanced analytical capabilities and complex comutations and aggregations