Event Review: Microsoft SQL Server 2008 Database Engine Overview and Data Compression (Session ITPROSQL-301)

Welcome to the material supporting page for this session. The materials on this page have been selected as the best matches to the content covered in the live event session.

Session Outline

In this session, we're going to explore the new features in SQL Server 2008. The topics that will be covered are enhancements to the SQL Server database engine, improvements to the T-SQL programming language including new datatypes, and compression capabilities that decrease the size of the SQL Server database.

Session Agenda

• Database Engine Enhancements
  
• Data warehousing covered separately
  

Session Media

This session consists of a Windows Media presentation and demonstrations:

	View the session presentation View the full multimedia recording of this session.
	Download the full session Download the full multimedia recording of this session.
	Download all slides and transcripts Download just the slides and transcripts of this session.
	Demo: Exploring Table-Valued Parameters In this demonstration, we will look at Table-Valued Parameters and see how this new feature can help reduce the amount of code in applications.   Play online | Download
	Demo: Implementing Hierarchy Management In this demonstration, we will take a look at how hierarchies can be implemented using the new HierarchyID data type.   Play online | Download
	Demo: Exploring the Geography Data Type In this demonstration, we will take a look at the new Geography data type included in SQL Server 2008.   Play online | Download

---

Related Links

Use the following resources to learn more about topics covered in this briefing.

• SQL Server 2008 Database Engine
  
• BLOG: Kimberly L. Tripp: Improving *my* SQL skills through your questions!
  
• TechNet WebCasts: 24 Hours of SQL Server 2008
  
• TechNet Forums: SQL Server 2008
  

Training and Certification

• Course 6232A: Implementing a Microsoft SQL Server 2008 Database; Five days; Instructor-Led
  

  Summary: This five day, instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

• Course 6231A: Maintaining a Microsoft SQL Server 2008 Database; Five days; Instructor-Led
  

  Summary: This five day, instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

• Collection 6187: What's New in Microsoft SQL Server 2008
  

  Summary: In this 3 hour online collection, IT Professionals will learn about the new features in SQL Server 2008. Topics covered within these clinics include: What's New in SQL Server 2008 for Enterprise Data Platform, What's New in SQL Server 2008 for Business Intelligence, What's New in SQL Server 2008 for Database Development.

• Course 6235A: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services; Three days; Instructor-Led
  

  Summary: This three day, instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

• Course 6236A: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services; Three days; Instructor-Led
  

  Summary: This three day, instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.