I consider CLR functions to be one of the least useful features introduced in SQL Server 2005. Although I can see a niche use for it when a developer needs...

mendesm (10/5/2011)

---

Don't take this personally, but when a resume comes my way with "MCITP/MCTS" and other MS certifications I pass the resume on to the trash barrel.

These days, the more...

When writing DDL deployment scripts, I try to leverage information schema views rather than system views.

-- If a named constraint exists, then drop it:

if exists (select * from information_schema.table_constraints...

Charles Kincaid (9/29/2011)

---

You said; "Aren’t we all destined to have so much uncategorized stuff and as long as we limit it to one drawer, does it matter?"

So, getting back to...

paul.jones (9/29/2011)

---

When one colleague left we found, along with the usual selection of pens and stuff, some crackers and a range of individually wrapped cheese portions.

Unfortunately it took us a...

GilaMonster (9/26/2011)

---

...

That alone won't do anything other than raise an error that says something untrue. It's not rolling back the transaction. That transaction committed.

...

Probably not sufficient, it...

The most common disaster that I seem to hear about is the "whoops" disaster. A disaster that's human error, a situation where someone makes a mistake in data entry. The...

djackson 22568 (9/22/2011)

---

Eric M Russell (9/22/2011)

---

Steve Jones - SSC Editor (9/21/2011)

---

djackson 22568 (9/21/2011)

---

...

And you want us to worry about things like whether a business is closed?

...

We are fighting against significant...

Steve Jones - SSC Editor (9/21/2011)

---

djackson 22568 (9/21/2011)

---

...

And you want us to worry about things like whether a business is closed?

...

We are fighting against significant odds of success. I...

Data provided from 3rd party sources can be pruned or perhaps even corrected by cross referencing it with other more official or trusted databases. For example when an anonymous user...

WayneS (9/20/2011)

---

Lon-860191 (9/20/2011)

---

Maybe, it just that students are doing what they have learned from big business; when you want something done, outsource or subcontract the work to be done. They...

The most secure and best paying jobs are those where you do something that would be extremly difficult for another person to do. That's a good position to be in,...

Ian Scarlett (9/20/2011)

---

All of this just reiterates the need to make job candidates answer real technical questions and/or sit a relevant test as part of an interview.

You have to take...

I do think there should be a formal mentoring process for new IT hires, especially developers. A new developer would therefore be considered an Apprentice until they really understand the...

Of course a lot of programmers did get their degree from a vocational school rather than a university. I don't think a four year degree should be required, however, there...