Thanks, interesting approach. I didn't think about adding the LAGs, which makes sense.

I certainly didn't think about NULLs in the balance. It wasn't part of the original spec, but you're...

Same....

I'd agree with this. VB is really...

If you are designing a new object with DML triggers, especially nested or recursive enabled triggers, then you should take a step back and consider if there is a...

When you mentioned over source control systems than Git, it reminded me at one of my early employers (can't remember which) we used to use MS Visual SourceSafe.  That...

IT DEPENDS !

Database mirroring is not dead yet! ( Such a shame Microsoft uses that terminology now in its cloud context ) It still works and in some cases...

Thanks. I learned this at Redgate, where we had like 5 web frameworks at one point and realized that it took weeks to...

Should I bother?

...

I've sat in management meetings where people have expressed frustration that people don't auto-magically know stuff and that surely something is common sense.  The people outside of the room...

I certainly need it. Autodraft did not help me this year.

Good luck

Scalability or popularity first? From what I've seen its popularity first, but who's popularity are you looking for? From my point of view, it is an upper-level manager whose...

To be frank, I don't see NFRs (non-functional requirements) in general given the attention to detail they deserve.

...

Beyond those typical NFRs it would be useful to knowing more about...

I'm staying at the Hampton in West Mifflin, recommended by Mr. John. I get there relatively late Fri (7p), so not sure if I'll make dinner then, but leave Sun,...

Indeed. We both barely avoided shutouts

We also have some people that apparently just suck at this