| Trusted |
Run your most mission-critical applications on a highly secure, reliable, and scalable platform. |
| Protect Your Data Dynamically encrypt your valuable data within an entire database, data files, or log files, without the need for application changes. Simplify increasing regulatory compliance by using the advanced data auditing abilities of SQL Server 2008. Minimize exposure to security attacks by using the SQL Server Configuration Manager to enable only the services you require and Policy-Based Management to enable only the features you require. Ensure Business Continuity Seamlessly increase the reliability of applications with Database Mirroring. Simplify the recovery of applications from storage failures. Transfer operational data between the active operational systems and backup systems. Add system resources, like CPU and memory, without affecting applications. Provide Predictable Response Ensure consistent performance by using Resource Governor to define resource limits and priorities for different workloads and enable consistent performance. Reduce your storage costs and improve performance of large I/O bound workloads by using data compression. |
 |
| Productive |
| Reduce the cost of managing your data infrastructure while streamlining development of data applications. |
| Spend Less Time on Operations Manage your enterprise data infrastructure easily with Policy-Based Management. 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. Enable Performance System Analysis by collecting performance data from your system and storing it in a centralized data repository. View reports to benchmark and analyze system performance and health. |
|
| 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 data type 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. |
|
| Deliver Location Intelligence Consume, use, and extend location-based data through spatial-enabled applications. Build location-aware applications by using new spatial data capabilities in SQL Server 2008. |
|
| Intelligent |
| Drive business intelligence throughout your organization, manage reports and analysis of any size or complexity, and empower users by providing powerful visualization and integration with the Microsoft Office system. |
| 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. |
|
| Deliver Relevant Information Empower users to answer complex questions by providing the relevant information through reports with powerful visualizations and rendered in Microsoft Office Word 2007 and Microsoft Office Excel® 2007. Enable users to create complex reports and share them internally and externally with customers and partners. |
|
| Drive Actionable Insight Provide a consistent set of key performance indicators (KPIs) and business metrics to all users by using the comprehensive and scalable analysis platform of SQL Server Analysis Services that has intuitive access through Office Excel 2007. Integrated Data Mining enables predictive analysis so you can investigate common issues like forecasting and identifying key influencers for decisions. Develop scalable analysis models with enhanced designers that incorporate best practices into the design experience. Increase the scale and performance of analysis by using enhanced analytical capabilities and complex computations and aggregations. |
 |
| 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. | 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. |
| 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. | 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. |
| 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. |
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. |
| 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. | 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. |
| 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. | 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. |
| 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. | 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. |
| 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. | 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. |
| SQL Server 2008 Editions | |
| SQL Server Editions Enterprise - SQL Server 2008 Enterprise is a comprehensive data platform that meets the high demands of enterprise online transaction processing and data warehousing applications. |
SQL Server Specialized Editions Workgroup - Workgroup is a reliable data management and reporting platform providing secure, remote synchronization and management capabilities for running branch applications. It includes the core database features of the SQL Server product line and is easy to upgrade to Standard or Enterprise. |
| Usage Scenarios • Business-critical • Large-scale online transaction processing (OLTP) • Large-scale reporting • Data warehousing • Advanced analytics • Server consolidation |
Express - SQL Server 2008 Express is a free edition of SQL Server ideal for learning and building desktop and small server applications and for redistribution by ISVs. SQL Server Express includes powerful features such as SQL Server 2008 Reporting Services, a server-based platform for creating and delivering traditional and interactive reports, and a graphical management tool, SQL Server 2008 Management Studio Express, for easily managing your database. |
| Standard - SQL Server 2008 Standard is a complete data management and business intelligence platform providing best-in-class ease of use and manageability for running departmental applications. Usage Scenarios • Departmental • Small-to-medium scale OLTP • Reporting and analytics |
Compact - SQL Server Compact is a free SQL Server embedded database ideal for building stand-alone and occasionally connected applications for mobile devices, desktops and clients. SQL Server Compact runs on all Windows® operating systems, including Windows XP and Windows Vista®, and on Pocket PCs and smartphones. |
| COURSEWARE TITLES: Microsoft includes a FREE English copy of SQL Server 2008 with each of the following courseware titles: 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL 6158: Updating Your SQL 2005 Skills to SQL Server 2008 6231: Maintaining a Microsoft SQL Server 2008 Database 6232: Implementing a Microsoft SQL Server 2008 Database 6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services 6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services 6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services 6317: Upgrading Your SQL Server 2000 Database Administration (DBA) Skills to SQL Server 2008 DBA Skills If you should have additional questions regarding the Microsoft SQL Server 2008 promotion, do not hesitate to contact 1StaffTraining at 888.556.7568 or 402.898.8700. |