Steve, a EULA is not going to keep your common DBA from opening up a stored proc and messing with it. If there are having problems most likely the...

You know, part of what I don't like about Steve's argument is some protection even easily broken is worth some value. For example: A chain link fence. ...

I think you have the wrong perspective here. My company has been encrypting all of their stored procs since the beginning. I am talking hundreds of stored procs....

The reason we decided the rewrite is necessary is that the performance is poor even with very little data in the test database. It is surprising how sluggish the...

I think it depends on what your project needs are. If you have a more simple project with a simple db design something like the entity framework can work....

Hey Tom,

You make a lot of good points. Thanks for you comments.

Ben

Well Paul, sorry you didn't like the article. Sometimes you just find yourself in a situation and you have to make the best of it. This was my...

Do you live in San Diego? I grew up there. Or perhaps you live in Orlando.

Ben

I have yet to see one of their shows "live." I like very much what they do/achieve. I thought it was fitting with location and job.

Jason,

I had the opportunity...

Hey Jason,

I am glad you liked the article. By the way I like your sqlservercentral name. CirquedeSQLeil is very clever. I have seen their show, it was...

Thanks for your suggestions on the replace. I did feel that part of the code was a little weak. Perhaps your suggestions will be in version two of...

Hey James, glad you liked the article. I was pretty happy when I figured this out. I had been thinking about a solution to this for some time....

Sql 2005 only has a max of 250 indexs for a table. The link points to sql server 2008. Where the max indexes for a table is 1000.

There is an issue with your proc. You use varchar(1000) and varchar(2000), the problem with this is with large tables this is not large enough. I changed all...

We encrypt our sql stored procs. One of the main reasons is so that we don't have a support nightmare. For the causal client, they might try to...