We’re writing a book – finally!

Well, almost… Kimberly and I have agreed to co-author the upcoming SQL Server 2008 Internals book with our good friend Kalen Delaney. This is the 2008 evolution of Kalen’s Inside SQL Server series of books and will be published by MS Press around February 2009. The other authors are (also our good friends) Adam Machanic and Conor Cunningham.

Kimberly’s going to write the chapter on Index Internals and I’m going to write the chapter on DBCC Internals. This is very exciting as these are our respective favorite subjects, as you probably already know – these won’t be short chapters :-)

It’s going to be a busy rest of the year – phew!

PS Next year we have plans to write a book ourselves – watch this space…

2008 Conferences: TechEd EMEA, SQL Connections, PASS Community Summit


September, October, and November are going to be a whirlwind this year – after 3 weeks in the UK and Ireland in September, teaching and the San Francisco Power Workshop in October, we have three back-to-back conference weeks in Barcelona, Las Vegas, and back to Seattle! Hey – who booked that schedule?!?!?! Well, at least it helps us keep our top frequent-flyer status on United :-)

Here’s the line-up – see our Upcoming Events page for all the abstracts (including those from Bob Beauchemin and Stacia Misner too).

TechEd EMEA IT Pro, November 3-7, Barcelona, Spain

  • We’re still working with the TechEd team to finalize the content we’ll be delivering but it’s looking like the same three sessions from TechEd US, plus a bunch of new ones and Instructor-Led-Labs
  • Sessions (at least):
    • Are Your Indexing Strategies Working?
    • Corruption Survival Techniques: From Detection to Recovery
    • Essential Database Maintenance

SQL Server Connections Fall, November 9-14, Las Vegas, USA

  • This is the second of the twice-yearly SQL Connections conferences that Kimberly and I Co-Chair
  • Workshops:
    • November 9: Pre-pre-con: Database Best Practices for the Involuntary DBA
    • November 10: Pre-con: Relational Data Warehousing: Leveraging Key Features of SQL Server 2005/2008
  • Sessions:
    • Index Internals and Usage
    • Essential Database Maintenance
    • DBCC CHECKDB: The Definitive Guide
    • Follow the Rabbit: Interactive Q&A on Database Maintenance

PASS Community Summit 2008, November 17-21, Seattle, USA

  • As unbelievable as this may be, I’ve *never* been to PASS before, even in the few times it was in Seattle – something always conflicted. Kimberly hasn’t been since 2005 so it’ll be cool for us both to be there this year.
  • Workshop:
    • November 18: Database Maintenance: From Planning to Practice to Post-Mortem
  • Spotlight Session:
    • Corruption Survival Techniques: From Detection to Recovery


Dev Connections SQL Power Workshop on SQL Server 2008, October, San Francisco

People have been complaining that I’ve stopped blogging so much – vacation folks, vacation! Today I’ve got a few class and conference posts to get through and then I’ll get back to the technical posts.

We’re doing a 2.5 day public class based on the SQL Server 2008 material we developed earlier this year. This will be part of a larger conference being hosted by Dev Connections in San Francisco, USA. Our workshop will run October 6th through 8th.

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 Throttling
    • Resource Governor
    • Extended Events
  • New Development Technologies
    • Spatial Indexes
    • Sparse Columns
    • Filtered Indexes and Statistics
    • Change Tracking and Change Data Capture
  • Performance Data Collection
  • Scalability Enhancements
    • Data Compression
    • Partition-Level Lock Escalation

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