From a developer perspective the NOSQL databases do cool stuff and make the developers task of interacting with data much simpler.

The boring stuff that makes it all work is the...

Actually, having been given Aquafold Data Studio to play with I think SSMS needs to take a good hard look at multi-platform integration.

I've got to look at MySQL, HP Vertica,...

A sophisticated full-text search with sophisticated phonetic matching capability would go down a treat.

Being able to deploy onto Linux would be fantastic.

A formal metadata and lineage facility that takes into...

I'd make the point that being a DBA is a mindset as much as a set of technical skills.

Is the need for the mindset getting any less? I'd argue...

I'm obviously reading this editorial differently to the rest of you. I'm not reading it as an attempt by management to scam employees to do ever more for ever...

[

There's your problem. Perhaps testing the product at expected volumes would have exposed this shortcoming. The company's refusal to adapt and correct an obvious flaw would automatically generate an RFP...

Fragmentation

Fullness of files and prediction for when we will have to grow them. We don't want autogrowth in large production systems we like to plan it.

Absence of...

It's not just Excel, it's BI in general.

Does BI development go through the same rigour that application development has to? I seriously doubt it!

Excel is particularly prone because its...

I always do the best I can do within the constraints I am given. If it is time and resource constraints and I know that these are not sufficient...

This works fine in favourable business conditions. The true test comes in difficult times where difficult and unpopular decisions are needed.

Committees aren't great at setting directions. The best...

I saw a blog on the Brent Ozar website where his minimum spec for a quad core 2CPU box was 96GB RAM and 2xSSD drives. The charge of over-speccing...

The thing I like about graph databases is that the relationship between nodes is a whole concept in its own right. It performs the equivalent of a link table...

Only needs that to be bi-directional and you've got the solution.

There is an inherent conflict here. A...

I wish that the old SQL functions would be updated with the times to take into account larger data types.

I know that if you change the behaviour of a function...

The more senior the level you are trying to communicate with the less time they have to listen to your case and the more people they have trying to put...