I've been through all 3.

The problem with the nuclear option is that you are looking at the DB in isolation. In my experience the state of various components within...

Gary Varga (12/5/2016)

---

David.Poole (12/5/2016)

---

Our CIO stood up and said that our delivery targets were ambitious and have very little slack in them to investigate the best ways of doing things....

Our CIO stood up and said that our delivery targets were ambitious and have very little slack in them to investigate the best ways of doing things. He then said...

I think I would push for the DDL commands to be part of the ANSI SQL Standard before setting them up in SQL Server.

I think there should be a new...

I've a sneaking suspicion that the law is mainly for the benefit of lawyers rather than the persons under dispute.

Quangos are not for the benefit of those for whom the...

What I'd like to see is a framework to support whistle blowers.

By all means insist on evidence but whistle blowers need protection. Most companies have a whistle blower policy...

It should be and would be but for vehicle cloning

Gary Varga (11/29/2016)

---

David.Poole (11/28/2016)

---

What puzzles me is that developers aren't much better at data modelling. Surely you have to be pretty good to come up with a decent object...

What puzzles me is that developers aren't much better at data modelling. Surely you have to be pretty good to come up with a decent object model in the...

dalland (11/28/2016)

---

David.Poole (11/28/2016)

---

I think context is all with person records. If you are storing medical procedures to be carried out then you absolutely want to make sure the right...

Anyone heard of the Dunning–Kruger effect? For an audio approximation watch the early stages of <insert country here> got talent.

In IT this manifests as people with a reasonable degree...

I think context is all with person records. If you are storing medical procedures to be carried out then you absolutely want to make sure the right person has...

Jeff Moden (11/26/2016)

---

David.Poole (11/26/2016)

---

Storing guids in things like RedShift or Vertica is fun. Not only do you have to store them as CHAR(36) but by definition they are unique...

Storing guids in things like RedShift or Vertica is fun. Not only do you have to store them as CHAR(36) but by definition they are unique and don't compress.

Certain...

We can mask the apparent complexity of a DB with views and stored procedures.

The prejudice against joins was always a mystery to me until Phil Factor nailed it with the...