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...

I'm interested in how Red-Gate are approaching the inclusion of Linux as a supported platform for SQL server?

Are any of the tools porting to Linux or are they sticking with...

I've reached the conclusion that people don't realise what a well thought out data model gives them and they aren't interested in knowing.

They see SQL Server as a dumb data...