Hands-On Lab 6157A:

What's New in SQL Server 2008 (CTP5)

Length:1 Days
Published:January 31, 2008
Language(s):English
Audience(s):IT Professionals
Level:200
Technology:Microsoft SQL Server 2008
Type:Hands-On Lab
Delivery Method:Instructor-led (classroom)
About This Hands-On Lab
This series of Hands-on-Labs introduce students to the new feature available in SQL Server 2008. The series focus on new features and components in in the relational database, business intelligence and development environment.
Audience Profile
This series of Hands-on-Labs is intended for SQL Server administrators and developers who have experience working with previous editions of SQL Server 2008.
At Hands-On Lab Completion
After completing these labs, students will be able to:
  • Explain new development features in SQL Server 2008 and how they can benefit from these in application development
  • Explain new enhancements to database administration features in SQL Server 2008.
  • Explain new features and enhancements in a SQL Server 2008 Business Intelligence platform
  • Explain how SQL Server 2008 benefits from Visual Studio integration and provides enhancements to work with location data.
Hands-On Lab OutlineExercise 1: SQL Server Platform Vision
This module describes the SQL Server 2008 platform vision and describes the new features added to SQL Server 2008.
Exercise 2: Enterprise Data Platform
This module describes the enhancements in the SQL Server Enterprise Data Platform. Topics covered include High Availability Enhancements, Hardware Support, Secure Data Features, Policy based management and System Auditing Enhancements.
Exercise 3: Dynamic Development
This module walks students through the development enhancements of the SQL Server Database Platform. Topics covered include the .NET Platform integration as well as the capability to build data synchronizing applications using the .NET Compact Framework 3.5 and the .NET Entity Framework.
Exercise 4: Beyond Relational
This module describes new features that go beyond the relational engine, available in SQL Server 2008 Topics covered include the FILESTREAM storage, extensions to working with user defined types, and database enhancements that include new datatypes such as data/time data.
Exercise 5: Pervasive Insight
This module describes new SQL Server 2008 features for Business Intelligence.Topics covered include the new Report Designer, integration with Virtual Earth and Location data tracking, enhancements to Analysis Services as well as new features in Integration Services.
Before attending these labs, students must have:
  • Experience developing applications on SQL Server 2000/2005
  • Experience managing and administering databases on SQL Server 2000/2005
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:
Course index

Find Training Near You

Location:
Eg: Seattle, WA or Paris, France

Related Services