My personal bugbear is that IT sectarianism rears its ugly head when it comes to commenting code. There are hard core polarised views held by noisy evangelists and a...

A big part of the problem (I think) is the tendency to move responsability for testing away from development, and employ test/QA people who have no idea what the software...

I come from an era where you had to know a bit of everything to work in IT including how to use a soldering iron and crawl through roof spaces.

I...

I'd love to hear what Microsoft do with testing SQL Server. Do they use TDD/BDD, manual methods and are they designing SQL Server code to be testable?

What are the...

It's a blame system with proof:hehe:

I think this one can be chalked up to immaturity. Business people would cheerfully descope a whole raft of IT concerns if they could. Auditing is not seen...

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