Event Review: What's New In Microsoft SQL 2008 (Session ITPROSQL-300)

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 will be going through an overview tour of the new features of SQL Server 2008, split into four core areas. Microsoft's Data Platform provides a business solution that enables organizations to store and manage many types of data using a rich set of services for interacting with their data. SQL Server 2008 increases our strong support of non-relational data with new data types that allow developers and administrators to easily manage and store unstructured data types such as documents and images. With an integrated development environment that simplifies access to data, developers will be able to create the next generation of data applications for your business.

Session Agenda

• Enterprise Data Platform
  
• Beyond Relational
  
• Dynamic Development
  
• Pervasive Insight
  

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: Using The Declarative Management Framework In this demonstration, we will explore policy management using the Declarative Management Framework. In particular, we will be looking at both a table policy and a database policy.   Play online | Download
	Demo: Creating Table Valued Parameters In this demonstration, we will look at Table Valued Parameters and see how this new feature can greatly reduce the amount of code required in applications.   Play online | Download
	Demo: Using New Date and Time Data Types In this demonstration, we will look at the new date and time data types introduced in SQL Server 2008.   Play online | Download
	Demo: Creating a Tablix Report In this demonstration, we will look at the new Tablix component in Reporting Services.   Play online | Download

---

Related Links

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

• What's New (SQL Server 2008)
  
• Overview (SQL Server 2008)
  
• SQL Server 2008 TechNet Tech Center
  
• Getting Started (SQL Server 2008)
  
• BLOG: Kimberly L. Tripp: Improving *my* SQL skills through your questions!
  
• TechNet Virtual Lab: What's new in SQL Server 2008 for Database Administrators
  
• 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, and 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.