Over the last six months on the blog, you’ll have seen me mention internal training that Kimberly and I wrote for Microsoft on SQL Server 2008. This deep training covers all the features around database infrastructure and scalability and we’ve just finished revamping it for RTM. We did a one-day version of this content at TechEd in June, and last week for the Microsoft Ireland “SQL Academy” training program, but we’ve never presented the course to the public – until now!


We’re teaching the entire demo-laden 2.5 day course at the Connections event in San Fransisco next month, including the hands-on labs. Click the image for full details and registration.


Here’s the abstract:


SQL Server 2008 offers an impressive array of capabilities for professional developers that build upon key innovations introduced in SQL Server 2005. The use of many of these will have manageability and infrastructure implications for a database – and hence the DBA! There are also enhancements to existing high-availability technologies, plus a variety of significant new tools to aid in managing performance, scalability, administration, and troubleshooting. This workshop helps you understand how to exploit the new toolset and how to manage a database that makes use of the new features in SQL Server 2008. The multi-day format of this event allows us to explore each feature in more detail, with more in-depth demonstrations and labs.

Topics covered include:



  • Availability Enhancements

    • Database Mirroring
    • Backup Compression
    • Peer-to-Peer Replication

  • Security Enhancements

    • Transparent Data Encryption
    • Extensible Key Management
    • All Actions Audited

  • Policy-Based Management and Multi-Server Administration
  • Troubleshooting and Resource Management

    • Resource Governor
    • Extended Events

  • New Development Technologies

    • Spatial Indexes
    • Sparse Columns
    • Filtered Indexes and Statistics
    • Change Tracking and Change Data Capture
    • FILESTREAM

  • Performance Data Collection
  • Scalability Enhancements

    • Data Compression
    • Partition-Level Lock Escalation

Who should attend this workshop?



  • Database administrators
  • IT Pros who also manage databases
  • Application developers who would like to know how feature choice affects database scalability and infrastructure requirements

What are the benefits of attending this workshop?



  • Learn all the essential elements of SQL Server 2008 administration in an interactive, instructor-led format
  • Learn about the new features of SQL Server 2008 that developers will use that have management implications
  • Deep and intensive 200-300-level technical training custom-designed for professional DBAs and IT-Pros
  • Courseware developed by Paul S. Randal and Kimberly L. Tripp of http://www.sqlskills.com/, pre-eminent experts in SQL Server administration
  • Get hands-on experience with SQL Server 2008 administration

This workshop runs Oct 6 (9am – 4pm), Oct 7 (9am – 4pm), Oct 8 (9am – 12pm).