Jeff Moden (2/6/2009)

---

BWAA-HAA!!! Man, I'm right there with you on that one! Now, all we...

Jeff Moden (2/6/2009)

---

Ya beat me to it on the other thing... I didn't realize the binary was quite so wide in your code and started fixing it as you were...

Its taken me close to a year to create a series of articles that have sufficient utility to be worthwhile, and are logically good use of SQLCLR so as to...

sean hawkes (2/6/2009)

---

To me the SQLCLR vs. xp_cmdshell seems like the old script vs. small application debate. Seems that SQLCLR is very similar to writing a small application. ...

Jeff Moden (2/6/2009)

---

Heh... listen to you... Anyone capable of writing either the CLR or the T-SQL isn't going to miss the sp_OADestroy. Anyone who doesn't understand enough about T-SQL...

Jeff Moden (2/6/2009)

---

When I run that bit of computational heaven against the test data I built above, here's the results I get...

1263 ms for...

Phil Factor (2/5/2009)

---

Oooh. This is getting very useful. I'd missed out on the advantages of passing string parameters as SQLStrings and the trick of passing back a NULL. It...

Ok, what did I miss?? I don't quite know what I missed? If it was the exception from providing a bad path... I didn't miss that, like I...

noeld (2/5/2009)

---

I am not talking about UNSAFE. Not all developers have solid programming skills to write something that "scales". Putting bad code on the server is not a good thing....

It's not that I love SQLCLR. In fact I more or less hate how...

don_goodman (2/5/2009)

---

I did not read past the first paragraph. Instead I scanned the code samples. I saw a lot of code. If I was a DBA that wrote lots and...

Attached is a new installer that will includes the source file so you can view the code natively in SQL Server, and handles the exception being raised if the path...

Phil Factor (2/5/2009)

---

Yes, Agreed! However, I've recently started using NET...

noeld (2/5/2009)

---

Although SQLCLR has great power I think it is very important to tell the reader that it also brings MANY undesirable things in.

- Bad Exception handling is just one...

Phil Factor (2/5/2009)

---

I'd be interested to see if anyone has a solution to the problem of preventing a barf when an invalid path is passed to DirectoryInfo. The obvious...