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

There is a definite skill in assigning appropriate work and keeping staff interested.

There's also a skill in working out their strengths and weaknesses, how best to capitalise on the strengths...

I would not describe myself as an Apple fanboy. What they are is industrial design rather than technical innovation. Unfortunately people tend to praise the things they can...

I was always reluctant to go with Macs. Not for any technical reason, more for the price and the sort of people I saw using them.

Then I was...

I find that automation and testability have to be designed in from day one. It's a bitch to try and implement it later.

If you want flexibility then...

Gary Varga (11/14/2016)

David.Poole (11/10/2016)

Then there is the rule of 2s for assembling a team to address the problem