|
The new SQL Server 2008 builds on top of the SQL Server 2005 version,
and extends this in many areas: Development, management as well as Business
intelligence. The first three days of the course, we take developers and
IT pros with a working knowledge of SQL Server 2005 into the new development
and administration features of SQL Server 2008. Topics: Introducing the
pillars of Sql Server 2008, Policy Based Management, Maintaining
SQL Server 2008, Beyond relational: new and enhanced data types and enhancements
to Transact-SQL. The last two course days, targeted at people who are already
familiar with the business intelligence products on SQL Server 2008, we
present the new and improved aspects of SQL Server 2008 in Integration Services,
Analysis Services and Reporting Services, with demos as well as hands-on
exercises.
Target Audience
This 5-day course is targeted to SQL Server 2005 developers and administrators
who want to learn the new features of MS SQL Server 2008.
Prerequisites
Students should have a good knowledge of SQL Server 2005.
Things you will learn
Introducing the pillars of Microsoft SQL Server 2008
- Enterprise Data Platform
- Beyond Relational Data
- Dynamic Development
- Pervasive insight
Policy Based Management
- Reactive versus proactive database management
- Working with facets, conditions, policies and policy groups
- Understanding and setting different execution modes
Maintaining SQL Server 2008
- Working with compressed databases
- Backup compression
- Changes and improvements in encryption
- Change data capture
- Resource governor
- Mirroring improvements
Beyond relational: new and enhanced data types
- Working with XML: what’s new
- Two types of geographical data: storage, indexing and use
- Stream data with the Filestream feature
- HierarchyID data type
Enhancements to Transact-SQL
- Multi-row inserts
- Table-valued parameters
- Query and table hints
- MERGE statement
- Setting compatibility levels
- Grouping sets
- New dynamic management views
What’s new in Integration Services
- New script environment: VSA is replaced by VSTA, web service references,
C# integration
- Working with change data capture
- New data flow data types for date and time
- Data profiling: Data profiling task and data profile viewer
- ADO.NET source and destination components
- Controlling data type conversion
- Lookup transformation improvements
- ForEach Database enumerator
- New row count tasks and performance counter components
What’s new in Analysis Services
- Dimension Designer improvements: new attribute relationship designer,
Analysis Management Object warnings, enhancements in the wizard, new
key column dialog box, and updated dimension structure tab.
- Backup and restore improvements
- Aggregation Design improvements: Browse and edit aggregations, improved
wizard, appending aggregates.
- Cube Design wizard improvements
- Block computations
- Data mining: improvements in the time series algorithm
What’s new in Reporting Services
- Modified reporting engine: IIS elimination, performance benefits
- New Report designer environment
- Flexible table and matrix creation with the Tablix component
- Working with the new Chart and Gauge components
- Word Rendering
- Improvements in Excel rendering
|