Using SQL Server 2005 Technologies to Develop a RealWorld Application

1
Using SQL Server 2005 Technologies to Develop a
 Real-World Application
John Mollman Software Design Engineer Microsoft
Pre-requisites for this presentation 1)
Working knowledge of C 2) Some exposure to SQL
Server 2005 features (Service Broker and SQL CLR
integration) Level Intermediate - Advanced
San Francisco 2006 February 1
2
Agenda

• Intro Background
• Quick Overview of MSDN Aggregation System
• Demos Lessons Learned
• Q A

3
MSDN Aggregation Problem Domain

• MSDN and TechNet content is rich and varied
• How can we add value to that content?
• Discovering and surfacing relationships
• User rating
• User tagging
• Personalizing views based on content attributes
• Drive usage data back to editorial decision
  makers
• Many scenarios all revolving around metadata
• How can we support them all in a generalized way?

4
Solution Space

• Scenario-based development
• Aggregate metadata with minimal constraints
• Avoid imposing global taxonomy
• Specific scenario implementations aware of their
  message semantics, system is not
• Support incremental addition of new scenario
  implementations
• Simple framework for adding new JobProcessors
• Class Factory creating JobProcessor
  implementations based on Service Broker message
  types
• Versioning strategy for JobProcessor
  implementations

5
MSDN Aggregation System Architecture
6
Demos
7
Debugging Tips Tricks

• Disable Connection Pooling when Debugging
• Connections which are recycled in the connection
  pool have debugging disabled.
• SqlConnectionStringBuilder sqlSb new
  SqlConnectionStringBuilder()
• // init sqlSb
• if DEBUG
• sqlSb.Pooling false
• endif

8
Debugging Tips Tricks

• Use a Trusted Connection for Debugging
• Auto-enables per-connection and SQLCLR debugging
  whenever you set a breakpoint
• SQL Logins can debug, but only if member of
  sysadmin Role
• T-SQL and SQLCLR code can only be debugged on
  connections created after you attach a debugger
• Step into doesnt work between tiers
• Need to set breakpoints on transition boundaries

9
Resources

• http//blogs.msdn.com/cbrumme/archive/2004/02/21/7
  7595.aspx (great explanation of SQL CLR hosting)
• http//msdn2.microsoft.com/en-us/library/ms165050.
  aspx (SQL CLR Debugging documentation)
• http//msdn2.microsoft.com/en-us/library/ms166100.
  aspx (Service Broker Dev Center)
• http//blogs.msdn.com/mollman (Ill post these
  slides and other resource pointers)

10
Questions?