John Papa

SQL Server and ADO.NET in Toronto

John Papa -

Man have things crept up on me! This past weekend I reviewed my code sample for my presentations at VSLive in Toronto later this week. It should be a good show up in Canada … I enjoyed my trip there last time. For any of you who will be there, here is a brief glimpse at what I will be discussing/demonstrating:

Developing with SQL Server 2005 – Part 1 (April 26th, 10:30 am)

  • XML Data Type
  • XML Schema Collections
  • FOR XML
  • Querying with XQuery
  • Modifying data with XQuery

Hard Core Coding with ADO.NET 2 (April 26th, 2:00 pm)

  • New Features and Major Changes in ADO.NET 2
  • DataTable Enhancements
  • DataTableReader
  • Batch Updates
  • Bulk copying techniques
  • Performance Enhancements

Developing with SQL Server 2005 – Part 2 (April 26th, 3:15 pm)

  • Exception Handling
  • EventData
  • Triggers
  • Common Table Expressions
  • Views and Derived/Inline Tables
  • DRI Enhancements

 

The agenda is now online for VSLive Toronto right here. All of my sessions in Toronto are on April 26th. I’ll be presenting 2 sessions on developing with SQL Server 2005 and a 3rd session on developing using ADO.NET 2. If you are planning on attending the conference, please stop by and say hi!