With regard to the IT profession in the UK, the question whether we engage in "software engineering" can be left moot.

Established professional bodies are given the power to confer Chartered...

I am also hoping for a reply to this - I found the same when restoring some copied database backup files last week. The Restore still works normally if...

I thought you started by saying you would be installing Enterprise Edition? And then installed Standard Edition?

Anyway, the rule for installing SQL Server 2005 from a single directory is...

My thanks to Brandie and Grant - Brandie for pointing out that there are factors that are nothing to do with the product and everything to do with who will...

Visio has always seemed OK for SQL Server, but since we also work with Oracle we have been moving towards ERWin. Do those with experience of both find that...

Hey, what other use have you people found for that whiteboard?

ouch - I was just kidding

I too am just weighing up text BLOBs against stored file locations, and it isn't a simple decision. But BOL says image is deprecated, and varbinary(max) preferred. (And...

I have backed up across the network to make migration easier between versions - you just need to restore the backup on the new server and you're in business -...

Assuming you've read Janet Wong's "What makes a good programmer" article that picked up from Steve's editorial, what more do you want anyone to say?

I am far from a newbie...

There are so many different aspects you could choose - quality of design, testing standards, clarity... - which will get different weighting according to the requirements and business environment.

On the...

... and not forgetting that RBAR [© J Moden] - inappropriate use of cursors - is the sign of the programmer used to variations on

for i = 0 to n-1...

Data breeches: what the well-dressed DBA is wearing this season.

This time next year: tuple trousers.

🙂

but as you've been a DBA for 5 years, there is no point going back to prove your IT skills again with another...

Regarding SQL2K: it is a bit complicated but you don't have to reinstall from scratch. To change default collation you do need to Rebuild the master and reattach...

Pursuing my view that you try to change the small things, I would say that you can read some of those books in order to change yourself, following their guidance...