Steve Jones - SSC Editor (5/24/2011)

---

I haven't said don't test it or throw it out the door. The decision to move something out before it is complete doesn't mean that...

Shudder.

Steve, that's a recipe for absolute disaster.

First, you're falling into the "get it out the door, we'll test it afterward" trap. Second, users will initially love it, and cause it...

I think the point about being risk-averse is absolutely true--and gets the cart before the horse.

Think about it. Would *you* want somebody who enjoyed high-stakes risk taking being a DBA?...

Am I the only one who thinks "none of the above" is the correct response, because the script is so buggy it won't compile?

Unless I'm crazy you can't insert 'a'...

Personally I think the data dictionary approach would be better served using a data modeling tool like Toad Data Modeller or Rational Rose. (I use Toad myself).

That way not...

I'm reading all these comments about how Access and VB and .NET are horrid compared to the competition. Sure, there are a few "it's not the tool..." comments but for...

tommyh (12/2/2010)

---

roger.plowman (12/2/2010)

---

I had the need for this and used a non-clustered unique filtered index. Simple, efficient, and solves the problem neatly while letting SQL Server enforce it.

As to why...

I had the need for this and used a non-clustered unique filtered index. Simple, efficient, and solves the problem neatly while letting SQL Server enforce it.

As to why you'd ever...

GSquared (11/9/2010)

---

I know what deterministic means.

So what you're saying is that you're an industry insider who knows that there's a huge security flaw in the product your company sells, and...

Mike Caldwell (11/8/2010)

---

Dictionary words aren't as secure as you make them out to be. A dictionary word has far less entropy than a random sequence of characters, hence the...

Biometrics are a nightmare for authentication.

The central, unsolvable issue is that once your biometric is compromised, *it can't be changed*. Lose your fingerprint and spoofers will be able to pose...

No approach to passwords is ideal, because the whole login id/password paradigm tries to serve two masters and as we all know that means it serves neither particularly well.

The whole...

Face it, in the days before the internet systems were far less complex, it was *possible* to know just about everything there was to know about a system.

Today? Not so...

Ok, I have a problem with the approach from the word go, and it's this:

"implement "ideal" auditing, where the app itself can recall all versions of the data that were...

I've needed GUIDs exactly once, when I was creating an application that was intended for distributed authorship of items to be stored in (author local) databases.

My solution for the ID...