Yeah. the term 'Code Smell' was certainly around in the early eighties, more the general impression of how 'off' it was.

@david.Poole

You must have forgotten the Ironical Data model

@[Yet another DBA]

That's true, we all use whatever we think will make the clearest column heading when we are generating reports. These aren't rules, just indications, but I think...

@dg81328

Absolutely right. The problem is inevitably in the design. If developers designed their databases properly, we'd be out of a living. Developers give their problems fancy names but...

I have to confess I'm forever doing this....

SET Statistics time on

Set statistics io on

$SELECTEDTEXT$ -- sql to execute and time

SET Statistics time off

Set statistics io off

--and I'm always wanting...

For a development Wiki as a 'group memory' , I use DocuWiki on a Synology box. It is no effort to maintain and things don't get lost. I think a...

@Beatrix Kiddo

So often for DevOps, read 'Let the Lunatics take over the Asylum'

@jeff Moden

I think that once you've worked out how an RDBMS...

@david.andrew 41944

I loved the story. It is so typical that I winced.

It sounds like you've worked at the same places I have.

Ed,

I was also going to say that in the editorial you mention that it missed some differences - you should definitely raise connect items or post them in the SSDT...

I suspect that the most important feature was to be able to update an existing database so that it...

[p]I hope this helps[/p]

[font="Courier New"]

-- we prepare the sample data and put it in a temp table

SELECT  * INTO #sampleData

FROM

(SELECT 'AAA' AS name, 0 AS 'Jun-08' , 0 AS 'Feb-08',...

I'm basically a Dev too.

I'm told that some...

@Jurgen.lottermoser

Yeah. ALM was supposed to fix exactly this issue but the tool providers couldn't resist the temptation to lock their customers in to the one solution. Also,...

@TomThomson

Oh dear, perhaps I've got it wrong. Let me explain a bit. DBAs, along...

@TomThomson

Yes, you're right. We must operate from a broad base of knowledge rather than expect to survive on 'training' in specialized techniques. Although OO is now quite rightly...