I agree completely. In fact, the intent of of mentioning the code generation in my last post was to debunk the development time argument.

pe johnson said "stored procedures, anyone?"

In my own defense, I did say "If you need to build and execute ad hoc queries" but maybe I did not stress the need...

Validating user input is really not complex at all. If you need to build and execute ad hoc queries you just need to remember two things.

With strings, always replace ticks/single-quotes...

Where do the alarm messages come from? Would there be a way to dump them to a flat file or something? The .NET framework provides a file/folder listener that can...

I thought about the serialization thing a little more and figured out a way to handle the situation where notification needs to be sent when changes are made to the database....

Business Rules in the DB

The only rules that should be in the DB are the ones that are used to enforce data integrity. Triggers are often used to enforce data...

Triggers vs. Polling

This is a trade-off decision.

Is the trigger load greater than the load would be if you polled every few minutes? If the database is getting hammered then the...

I would like to add a little bit of personal opionion on the OODB topic.

The concept of an Object-Oriented Database just seems wacky  to me. Objects...

quote:

---

I'm sure that after reading about a few of my "In The Real World" adventures, there are more than a couple of...

It is very nice to see a viewpoint that is different from what all the pundits are touting. This is a very good article but it does miss a couple...

This is available in SQL 2000 according to BOL (SQL Server Architecture > Database Architecture > Logical Database Components > Full-Text Catalogs and Indexes) but I have never tried it:

Formatted...

This may be a little nit-picky but I recommend building the query in Query Analyzer outside the boundaries of a stored procedure and just using variables for the parameters. It's...

quote:

---

I've got a question on this subject.

Somewhere along the line (back when I was a mere programmer), I got the...

One other thing in reference to "Remove BUILTIN/Administrators". If the SQL Server is clustered, you will need to create a login for the service account that the Cluster Server service...

Updated link to the Retina Sapphire utility:

http://www.eeye.com/html/Research/Tools/register.html?file=RetinaSapphireSQL

I think they caught on and want to get everyone's personal information now. Linking directly to the exe doesn't appear to work.

Bryant E. Byrd,...