Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR

Play Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR

The Discussion

  • User profile image
    AdamMachanic

    If you're planning to attend this session, please add a comment here and let me know what you're using SQLCLR for today. Or, if you're not, what kinds of complex problems you're trying to solve in your queries. I'd love to be able to tailor a demo or two to fit whatever people are most interested in seeing.

    Looking forward to talking with all of you in NOLA!

  • User profile image
    JLOrdaz

    I am using SQL CLR for consuming web services from may apps y call from procedure in my database business process

  • User profile image
    AdamMachanic

    Thanks for the comment JLOrdaz! I won't be discussing Web Service calls specifically as that's more a process/orchestration topic than an area where SQLCLR can help improve performance. But I will certainly keep it in mind as I finish writing the demos.

    --Adam

  • User profile image
    isoquark

    I am considering attending this session; however, I'll echo JLOrdaz's comment. From within SQL Server 2005, I have called web services and it was a major pain to set up the security, serialization seemblies, etc. It would be nice to know whether there is a smoother development process available for integrating CRL procs/triggers/etc with web service calls.

  • User profile image
    RichH

    +1 to other comments re:  calling web service interfaces from SQLCLR. 

  • User profile image
    CarolFackler

    Accessing and using spatial data.
    I won't be able to attend but will video be available to everyone?
    I'd love to see you presentation.

  • User profile image
    AdamMachanic

    Thanks, isoquark, RichH, and CarolFackler!

    I can't help ease the setup pain but I'll definitely add some content about some of the caveats (performance and otherwise) that you might want to keep in mind with web services from SQLCLR.

    CarolFackler, the spatial components in SQL Server are all based on SQLCLR already, so I don't think there's anything that can be added there in a general SQLCLR presentation.

  • User profile image
    CGLuttrell

    Thanks for the presentation Adam, and putting it out here for those of us who couldn't make TechEd this year.  I wathced it last night and learned a lot of useful information not only about using CLR better but how it and the database OS work in general.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.