For those interested in attending the Windows Phone 7 Deep Dive workshop in Adelaide later this month but also want to attend the SQL Server User Group where Conor Conningham (Query Optimizer guru) will be presenting, fear not. As part of the WP7 workshop we will make sure we align the lunch break so that you can attend the user group session.
Date: 27th-28th September
Venue: Board Room | Level 26, Santos House, 91 King William Street Adelaide SA 5000
- Session 1: Introduction and Windows Phone User Experience Overview
- Session 2: Animation, Orientation and Overlays
- Session 3: Application Lifecycle, Navigation, Application Tiles and Notification
- Session 4: Tasks and Touch
- Session 5: Working with the Accelerometer, Sounds and Location
- Session 6: Connecting and Consuming the Web
- Session 7: Retrieving, Storing and Synchronizing Data
- Session 8: Silverlight Analytics, Unit Testing and other Frameworks
- Session 9: Security, Authentication and Performance
Venue: L2 Westpac House (91 King William St, cnr Currie St)
On: Tuesday, 28 September 2010
So how does SQL Server pick which plan to run? If you’ve ever wanted to get a better understanding of how the Query Optimizer works, this is the talk to attend. Come listen to a member of the Query Processor development team explain how a query goes from SQL to the final plan. This talk will cover conceptual topics like how query trees are built and how the optimizer stores all of the alternatives it is considering. Additionally, the talk will examine examples in areas including index matching, parallel query generation, and update processing so that you can apply these concepts to better debug your own queries using the same techniques.
Conor Cunningham is a Principal Software Architect at Microsoft on the SQL Server Query Processor Team. He’s worked on database technologies for Microsoft for over 10 years and is holds numerous patents related to Query Optimization and Query Processing. Conor is the author of a number of peer-reviewed articles on query optimization techniques. Recently, he authored a chapter for the book "Microsoft SQL Server 2008 Internals" on how the Query Optimizer works. He publishes a blog called "Conor vs. SQL" (where he answers questions about databases.
Conor will be joining us via LiveMeeting. If you are unable to attend in person, please ask Rob Farley for the link so that you can join remotely.