SQLBits 2010

SQL CLR Demystified

A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
An introductory session on CLR integration within SQL Server, looking at what is required for implementation of CLR types, aggregates, triggers, stored procedures and functions. A few practical examples will also be covered, including some performance-based CLR implementations, as well as maintenance based ones.
  • Overview of CLR in SQL Server
  • Explore all types of CLR object
  • The differences in CLR permission sets
  • Worked examples of problem-solving with the CLR