I've never had much use for GUIDs, I much prefer INT identities.

However, I once had a situation that required unique keys across distributed computers, potentially tens of thousands of...

Oooh, you just hit my berserk button. 🙂

First, the initial problem is at the student level. They learn the bare minimum and get kicked out the door. Everybody...

I also got 8069 in the error message. (Using 2008R2)

There's a reason they're called monkey suits.

Although the language is dressed up PC-speak ("professional appearance") the truth behind "dress to impress" is purely and simply boasting. "Look at...

How about "unnormalized" instead of unstructured? As many have said there's really no such thing as unstructured data.

Take Word files, for instance. Word files are *very* structured, it's just...

Granted, people are patenting software, my point is the patent office is IGNORING the fact software is math. Therefore no software patents are valid by definition.

Of course convincing...

The first argument is security, specifically separation of powers.

The SQL Server database is the logical place to do anything that:

1) manipulates the data.
2) needs authorization based on...

It's really simple.

Software is math.

You can't patent math.

Full stop.

The fact the courts are ignorant of this simple truth has caused an uncountable number of...

I suppose it depends on both the exact position and the personality of the employee.

You said you had a position that basically left you in isolation, and...

Automated testing is GREAT for regression testing, especially in an OOP environment.

T/SQL isn't OOP, hasn't heard about OOP and frankly is anti-OOP. Militantly so.

Concerning the "invisible" aspects of...

I actually like spaces in conjunction with square bracket quoting (of course, to be used consistently for specifical lexical reasons).

On a second note, I see people using camel case a...

I dunno. Voice is a SEVERELY limited bandwidth channel. It's slow, prone to numerous potential error conditions, and just plain tiring to use for extended periods.

Yes, there are certain...

One reason to split a table vertically into a 1:1 relationship is when you don't need all the columns of a table to be used together. A good example might...