I know of a case where DBA work was outsourced. Everything ran more-or-less OK until some very old hardware hosting a very old version of some mission critical software...

Unfortunately it seems that the database world lags a bit behind the code world in terms of tooling and approaches.

Products like SonarQube help in the code world as they allow...

I worry about those security provisions that manage to obstruct without securing stuff.

I've just found out why my Kensington lock doesn't work. The rotating bezel had rotated to the...

When I did the SQL6.5 courses they emphasised the usefulness of binding rules to user defined types.

It was only later that I realised that tables created with user defined types...

With the mitigation that a SQL Proc can only be simplified so far I'd say the need to comment inline with the code probably indicates that code should be refactored.

comments...

I'm in the "this misses the point" camp.

Lets take transactions as an example. In the relational world a "thing" would be represented by a set of related tables with...

Nice post Andy. For me this also emphasises that when someone is put in a situation where they don't understand and they seem somewhat aggressive it may be that...

I found that SQL Compare and SQL Data Compare were quite good but the complexities of an environment making heavy use of replication made it difficult.

I think if you are...

Well so far I've gone through data architecture and now have the title of "Big Data Manager".

I'm managing a team, engaging with business people, working out new ways of working....

I've been to paid for conferences that weren't worthy to hold a candle to the free Saturday SQLBits events. The enthusiasm and time that is put into these events...

Ever come back from leave to find that the absolutely imperative world stopping problem your leave would create seems not to have happened?

The danger of believing you are not young...

Absolutely gobsmacked!

In development I can understand it if it is part of a learning exercise.

In production...

Maximum effectiveness in minimum effort.....simplest.....

If you look at well designed well implemented code it looks simple. You'd wonder why it took so long to deliver.

If you try and develop...

I saw an amazing article on how Oracle would save hundreds of thousands of dollars per year because the tooling was so much better that it took Oracle DBAs 10...

I'd be fine if it wasn't for the meetings I have to attend and timesheets I have to fill in and worrying about which pot of wooden dollars are going...