Like Steve (and many others) I've had great success with using SQL roles to manage database permissions and adding AD groups to those roles. The pertinent question is, does...

Huh? APL, Malbolge... I'm 51 and can barely recognize APL. These are languages developed before dirt was invented. What a treat hanging out with people that can...

BWAA-HAA! Don't need cursors when you have CLR's.

---

Didn't want you to wait too long Jeff 😎

Give 'em hell katesl. DBA <> doofus.

I've had "architects" hand off some of the goofiest architectures that they expected me to implement without any question. I...

LOL: Way to go...

Scott White (7/30/2008)

---

If you have around 50 tables in a system and you have just 4 sprocs for each (create, update, delete & select) you would have at minimum 200...

I like the opinion but disagree with large chunks of it.

Not all developers are created equal. What may work well in one shop will fail in another because of...

I'd say GilaMonster has it right. Dynamic SQL in any form (in an application or in a stored procedure) is vulnerable to SQL injection. The safest and best...

Wow Ted, this is a question I've been asking for years. I've know IT people that got masters in both business and/or technology and what I've discovered is that...

Hey Jeff -- a good thread is a good thread. 😉

Jeremy Giaco

---

It is very nice to walk into a company, read the naming conventions document, and pretty easily guess at how to query the data based on the tables names...

I'm fine with a discussion on naming conventions. I have one that I use and have shared with many. My objection is that the title of the article...

What a let down. I was expecting an article on good database design practices. Instead we're treated to another diatribe on naming conventions. About the only thing...

Thanks Ian,

I thought that may have been the purpose of the StringBuilder. I've had several developers ask me how to consume xml output from the database. So, when...

Jacob Sebastian

---

Many people find the usage of EXPLICIT is very complex. The difficult part is ordering the rows in the correct way so that the XML is generated in a...