When you move away from SQL Server you realise just what a fantastic product it is, how good the query optimiser is, its integration with a wide toolset, the ease...

I'd agree with Steve.  Migrations work in the vast majority of cases.  The problem is that non-DBAs have a tendency to think the majority of cases = all cases.

With regard to software and letting people or teams choose their tools, assuming pricing and licencing aren't issues integration becomes a sticking point.
Team A use a different setup to...

At work it's a Macbook pro with that odd little bluetooth keyboard and Apple mouse and dual 22" monitors.
I'm not keen on the keyboard and the mouse brings back...

Back in the days of DTS it was possible to write a DTS package that altered itself dynamically at run time.  We tended to use this for things that are...

Single source of truth in one place is a paradigm that has scuppered many an EDW project.  Once an organisation gets beyond a certain scale you are on a hiding...

If I was worried about disk space then I'd be asking how I could determine the amount of disk space required through automated means. Similarly could I predict locking/blocking impact...

The ridiculous thing is that the cost of peoples time arguing why you shouldn't have a RAM upgrade far exceeds the cost of that RAM upgrade.
The cost of nursemaiding...

Given the variability of the preferences this could be an example of where a good Document DB would fit.
Of course if youvyo got the in-house skills to keep an...

For all there faults RDBMS's have been tested pretty damn thoroughly over the past decades.  That testing has been in the real world rather than isolated to academia and in...

I think triggers work particularly well when used as a pattern.  An example would be to maintain Type 4 slow changing dimensions.
I've also used them on tables representing a...

I went to a presentation that gave the opinion that technology is moving so fast that in a 4 year Computer Science degree the stuff you learn in the 1st...