Jeff Moden (2/10/2012)

---

Since you brought up international time differences for doing a DIR in two different countries, let me ask... what did you do with your CLR to solve this...

True, SharpZipLib and a few other open source libraries are...

Elliott Whitlow (2/9/2012)

---

Solomon,

I have to disagree about the differences..

From Professional SQL Server 2005 CLR Programming by Derek Comingore and Douglas Hinson, Page 296, Unsafe Permission Level.

"We cannot say this any...

Jeff Moden (2/9/2012)

---

First, thank you very much for the explanation. Your explanation is more along the lines of what I...

Jeff Moden (2/8/2012)

---

Elliott Whitlow (2/7/2012)

---

Jeff Moden (4/29/2011)

---

I know little about deploying CLR's so please bear with me. Does the creation of the Asymetric key make it so that a...

Great article. I also rated it 5.

I tried looking through DMVs, Google, etc trying to find any mention of that handle but NOTHING!! 🙁

David.Poole (12/8/2011)

---

If people want to give an...

Dizzy Desi (8/19/2011)

---

As far as having my applications/database servers read tweets and respond to them - absolutely not. I think that's a Denial of Service attack (even inadvertently) waiting...

I completely understand that many responding to this question will be vehemently against such a thing, or cannot fathom a use for connecting your SQL Server to Twitter, but there...

Hi Craig.

I prefer Solomon but am not offended or upset when people use Sol as it is a common shortening.

I sincerely apologize if my tone was unprofessional and/or harsh, especially...

First let me say that this is a great article. It shows a wonderful use of SQLCLR for an area that T-SQL is just not well suited to. In fact,...

Todd M. Owens (4/27/2011)

---

And please think twice before setting the CreateDate and the UpdateDate to the same exact value on insert: this a clear violation of the limited redundancy principle....

DonaldW (4/28/2011)

---

I recently read Solomon Rutzky's article on DBFit (http://www.sqlservercentral.com/articles/Testing/64636/) and I've been working with it. Once I get past a few of the gotchas such...

Nadrek (5/3/2011)

---

Also, an easy way to get SQL Server to output SELECT results to a special character delimited VARCHAR() table, and directly to a text file would be very worthwhile...

Jeff Moden (5/2/2011)

---

David Data (5/2/2011)

---

All these methods use CHARINDEX to efficiently see where the next delimiter is. But what about handling CSV strings with quoted text, e.g. where "John...

Very thorough analysis. Great job!

Take care,

Solomon...