I am speaking next week at TechEd in Barcelona, Spain.
DAT302 Database Design Patterns: Architecting the Right Data Model for the Right Application Mon, Nov 5 17:45 - 19:00 Tent 1 Architecting an application starts with the database. Different applications need different data models. Fifth normal form is great for an OLTP database, but reporting databases need more of a flat denormalized structure and different Web sites need several different types of data models: eCommerce sites need different data models than traditional publishing sites. You need to optimize your data model for your application's performance needs. Concurrent users, data load, transactions per minute, report rendering, and query seek time all determine the type of data model you will need. See how different applications and different parts of an application can use different data models and how you can architect your database to fit into your application's needs and not the other way around.
DAT315 T-SQL Querying: Tips and Techniques Tue, Nov 6 17:00 - 18:15 Room 117 Take your queries to the next level! This highly technical, yet entertaining session focuses solely on advanced querying techniques to get the most out of your SQL Server 2005 database. See a series of real-world examples to extract data from your databases in ways you've never seen before. Techniques demonstrated include an ultra-fast way to do crosstab queries in SQL Server, running totals and ranking. Along the way you'll get some insight into how SQL Server works and we’ll preview some of the new capabilities in SQL Server 2008 (“Katmai”).
WEB02-IS Top Ten ASP.NET Scaling Tips Wed, Nov 7 15:45 - 17:00 Room 112 This interactive session pulls together the best methods for improving the scalability of your ASP.NET Web site. See a variety of techniques, including caching, pooling, paging and asynchronous processing. But more importantly, learn a method for ranking each of the techniques according to the benefit to your Web site. By comparing the potential benefit of a technique with its cost to implement, this interactive session will give you a plan for what to do next to most improve your site’s performance.
