I spoke yesterday at SQL Saturday event in Gainesville, GA. My topic was CLR Integration in SQL Server.
CLR stands for Common Language Runtime or .NET Framework. This SQL Server 2005 or higher feature allows developers to write .NET assemblies and deploy them in SQL Sever. You can implement scalar and table-values functions, stored procedures, triggers, user defined types and aggregates.
In my talk I spoke of features that I worked or had a need for. Those included interacting with OS, such as file access or registry access. I also talked about implementing fuzzy matching logic, creating custom bitmaps and utilizing them in SSRS reports.
You can download the sides and sample project here.