SQL Server CLR function to improve performance of validating email addresses

I had been doing the validation with a T-SQL User Defined Function (UDF), but it was getting too slow as the number of e-mails grew. I needed a faster alternative, what options do I have?

Writing to an operating system file using the SQL Server SQLCLR

Reading files from the operating system can be done with T-SQL as I showed in the tip Using OPENROWSET to read large files into SQL Server. What if you want to write to an operating system file? For example, writing to a text file. There's no T-SQL that supports writing to a file.

Managed Data Access Inside SQL Server with ADO.NET and SQLCLR

Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.

How To Return a Result Set from a SQL Server 2005 CLR Stored Procedure

We occasionally come up with a requirement that would be a good fit for a CLR function or stored procedure. For instance we would like to call a stored procedure to get the list of files in a particular folder. How can we return the list of files as a standard result set (i.e. rows and columns) using the CLR?

CLR Assemblies

DMVs

Which of the following limitations apply to SQLCLR...

To be used in an indexed computed column,...

Which of the following CREATE ASSEMBLY statement WITH...