back to Course Categories | back | print
New Features in SQL Server 2005          

Duration: 2 days

Description 
This class focuses on the new features in SQL Server 2005. Features such as XML, data encyrption, enhanced tools and new scalable features will be covered.

Topics

  • SQL Server Management Studio
  • Database mirroring
  • Online restores
  • Online Indexing Operations
  • Performance enhancements
  • Fast Recovery
  • database encryption
  • Secure default settings
  • Password policy enforcement
  • Fine grained permissions control
  • Enhanced security model
  • Partitioning enhancements
  • Schema change replication
  • User defined types and aggregates
  • Native XML support
  • Retrieving data with XQuery
  • Creating an XML Web Service
  • Multiple Active Result Sets
  • ADO.NET in SQL Server
  • Fine-grain access
  • New security model
  • apturing queries with Profiler
  • Working with the Database Tuning Advisor (DTA)
  • Working with SQLH2
  • Enhancements to error handling
  • Recursive query capabilities
  • Operators PIVOT, APPLY, ROW_NUMBER
  • Row ranking functions
  • SQL Service Broker
  • Notification Services
  • HTTP listener
  • New cataloging capabilities
  • Data Transformation Services
  • Data Mining
  • Clustering
  • One-Click Cube

Prerequisites

  • Attendees must have previous experience in SQL Server database administration.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design