Also a point that I missed earlier about the use of NULLs - in SQL referential integrity terms they are vital.

Table A is a set of some data....

While I'm quite an advocate of using NULL values instead of magic values, due to the slightly interesting way that NULL values are handled in comparisons and sorts there are...

Interestingly written. There is no security in obscurity however, as the article author notes, obscurity can slow down or deter more casual attacks. One would hope that if you're careful...

Just a semi-related note to the original article writer and anybody else reading...

As demonstrated above by Dohsan: always, always, always write date strings in International/Standard format, never use a local...

With a few exceptions with regards to actual hardware I can do all my technical work remotely.

However do not underestimate the human factor. Much of communiction is non-verbal (the amount...

Same here, I guess it's a genuine mistake rather than a deliberate one as the other answers just won't work. Made me think rather harder on it though!

It was an interesting point though, but if you don't record why a specific alternative wasn't assessed somebody looking at the article will wonder why it didn't include it. Not...

The mosting damning thing in this brief analysis is the note about the Progress JDBC being delivered by *******'s (aka:idiots). The only "sensible" conclusion that can be had from their...

Steve Jones - SSC Editor (12/23/2015)

---

loyd.gravitt (12/23/2015)

---

Here is the way the problem usually develops

1) Developers begin developing an application and use sa on their personal copy of mssql.

2) DBA warns...

That's possibly rather unpleasant. I'll have to check that.

I can see it's use, but it's also rather dangerous...

whoops. Duplicate, need to find the delete function...

nice bit of thread necroing here, but it's worth all the responses together I suppose.

My most recent example: The sa user was used by a web application to access the...

It's articles like this when you realise how much effort and smart the MS-SQL development team put in. I don't remember seeing this change in any headline features (which often...

"Who's a Good Developer" is quite an open question and is best answered by answering the question "What do we want this person to do?"

For example, there are roles where...