Customer Service or Enrol: 0800 282 353 or +44 1372 364610
 

SQL Server® 2008 New Features: Hands-On

Course: 136   Type: Hands-On   Duration: 3 Days
Quick Enrol  

You Will Learn How To

  • Leverage new SQL Server 2008 features and tools to support database administration and development
  • Simplify server-side programming with new Transact-SQL commands
  • Monitor and log data changes for auditing compliance
  • Enhance security and high availability through improved encryption and mirroring
  • Improve query performance with plan guides and extended event capabilities
  • Integrate new components of Business Intelligence (BI) for better reporting and analysis

Course Benefits
In order to properly evaluate and prepare for SQL Server 2008, experience with the cutting edge capabilities of this version is critical. This course provides hands-on experience with the latest features that enable you to extend your administration and development skillset. You leverage SQL Server 2008 in order to transform databases beyond the relational model and gain business advantage.

Who Should Attend
Experienced SQL Server 2005 administrators and developers considering or currently migrating to SQL Server 2008.

Hands-on Training
Throughout this course, extensive hands-on exercises provide experience with SQL Server 2008 new features. Practical exercises include:
  • Upgrading from SQL Server 2005 to SQL Server 2008
  • Handling date and time values with new datatypes
  • Saving storage with backup compression
  • Pinpointing performance bottlenecks with extended events
  • Setting up CDC with Management Studio
  • Restoring an encrypted database to a different instance of SQL Server
  • Configuring mirroring with log stream compression

Course Content
Introducing SQL Server 2008 New Features
  • Exploring new and enhanced components
  • Upgrading from SQL Server 2005
  • SQL Server Management Studio
  • Coding with Intellisense
Easing Development with Transact-SQL
Working with new data types and statements
  • Date
  • Time
  • DateTimeOffset
  • DateTime2
  • SparseColumn
  • HierarchyID
  • Grouping data by sets
  • Combining insert and update with merge
Manipulating Geo-Spatial data
  • Storing and retrieving geographic information
  • Querying data with Spatial Index
Extending beyond relational data
  • Configuring the Internal Full Text Search (IFTS)
  • Enabling the storage and access of binary files with Filestream
Improving Data Management
Scrutinising internal information with Dynamic Management Views (DMVs)
  • Analysing DMVs for memory usage
  • Verifying dependencies among objects
Allocating processor time and memory
  • Specifying resource limits
  • Prioritising workloads with Resource Governor
Policy-Based Management Framework
Establishing policy-based management
  • Defining guidelines for SQL Server instances
  • Reducing TCO by simplifying administrative tasks
Enforcing policy compliance
  • Creating policies, conditions and facets
  • Detecting compliance issues in Management Studio
Proactively Monitoring Data
Recording modifications
  • Configuring Change Tracking
  • Logging primary keys for rows that have changed
Auditing with Change Data Capture (CDC)
  • Enabling CDC for history logging
  • Tracking Data Manipulation Language (DML) statements
Data Protection and High Availability
Securing your data through encryption
  • Transparent Data Encryption (TDE)
  • Storing keys externally
  • Restoring encrypted data
Employing replication enhancements
  • Managing efficiently with Replication Monitor
  • Joining to an exisiting Peer-to-Peer transactional replication
Enhancing database mirroring
  • Recovering damaged or corrupted data with automatic page repair
  • Improving performance with log stream compression
Simplifying clustering setup
  • Addressing hardware compatibility changes
  • Streamlining cluster configuration
Boosting SQL Server Performance
Optimising query execution
  • Attaching query hints with the plan guide
  • Taking advantage of the query plan freeze
Collecting performance data
  • Analysing data capture from queries
  • Reporting on performance bottlenecks
Monitoring with the extended events engine
  • Handling events uniformly across SQL Server
  • Dynamically inspecting active processes
Integrating BI Enhancements
SQL Server Analysis Services (SSAS)
  • Creating multidimensional data with Cube Designer
  • Improving business insight with Data Mining
SQL Server Reporting Services (SSRS)
  • Presenting intelligent data reports with Tablix
  • Eliminating the need for IIS
  • Rendering reports to Microsoft Word
SQL Server Integration Services (SSIS)
  • Building an ADO.NET source or destination
  • Integrating SSIS with merge
  • Incorporating C# into the script task
  • Handling advanced data types in the SQL Server Import and Export Wizard
  

request more info Salutation*:

First Name*:

Last Name*:

Job Title:

Company*:

Post Code*:

Country*:
   Codes
Office Telephone*:

Extension:

E-mail*:

* Required

A Learning Tree representative will contact you to follow up your request for information.

Save 55%
SQL Server 2008 New Features
Course Schedule
19 - 21 Nov, 2008
London
28 - 30 Jan, 2009
London

Participants enforcing policy compliance with DMF.

£ 1,395 - Standard Tuition
Savings Plans
£ 810 - 10-Day Training Pass
£ 995 - Flex-Training Passport
£ 800 - Short Course Vouchers
£ 1,255 - Alumni Gold Tuition

 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610