SQL CLR
As I mentioned in my last post I've begun investigating the SQL Server CLR. I decided after getting warmed up to commit to an entire series of articles and I've just finished the first one on security. I figured it would be the best place to start as I know it's an unknown for a lot of people who are either still considering a SQL 2005 upgrade or have upgraded and aren't sure what to think of the new CLR feature. In fact I'm willing to bet there are a lot of DBAs out there who won't give it a...
I've started investigating the SQL CLR and decided as my first article to tie in a bit to my article on using SQL parameters in ad hoc queries. This time I'm touching on an advanced topic of sql parameters - how to pass an array as a parameter. This takes advantage of the performance benefit you get from parameters because the plan can be cached for queries that use dynamic IN statements.http://www.codeproject.com/cs/database/TableValuedFnsAsArrays.aspNext, I plan on writing a series of articles on the SQL CLR discussing the following topics:CLR SecurityCLR Performance/StabilityCLR vs T-SQLCLR Best PracticesI've almost finished the first article on...