That's a good summary. We tend to hear "migration vs state" model (however less and less). Database development are more like both.

I love SSDT for the state-based approach and script...

The name common table expression comes from the way that you factor it out of multiple positions in a query expression and move it to the front. By analogy,...

(THUMBS-UP) If it helps to leave the misconception behind, I'm on...

• This reply was modified 3 years, 6 months ago by  f.clems. Reason: Emoji not working

With such a name, CTE were kind of made for misconceptions. Could we rename them LVR (Local View with Recursion)?

Ok tricks and manipulation were surely not appropriate. Pfiou... clear commutation really is an art.

Thanks for the advice. Sincerely. Food for thought at an appropriate time here.

I tend...

, they still are a part of the problem.  It's just that they (we, actually) stand no chance of getting better if they keep getting told things like "Just...

Ok, that is not the full development cycle. And I associated fix it with improve it. I spend my time in a system created out of an ORM reproducing inheritance...

It may all come done to the interpretation, but this cycle seems perfectly relevant.

Do it: get the first draft implementation. I'm to often locked in meeting on how should it...

• This reply was modified 3 years, 7 months ago by  f.clems. Reason: Clarify I'm breaking things in DEV

The bugs daveBoltman mentioned is what keep me away from merge. It has had such a bad press. Has it recently changed? I would love to love merge, but this makes...