I use ModelRight to create the ERD. More importantly, ModelRight has the ability to generate DDL SQL for *every* feature of the model, from tables to relationships to indexes to...

I suspect it's simple ignorance on both sides.

DBAs don't really get it. Developers are all about problem solving. The problem is, developers don't *fully* understand the importance (and difficulty) of...

Unfortunately 99 times out of 100 these are just dog and pony shows meant to look like you're doing something when you're just sighing heavily *along with the auditors* and...

GoofyGuy (8/17/2015)

---

Question for anyone working in a small shop (which I'll define here as five or fewer developers): do you use a source control management system? If so, which one,...

Part of the problem is the rapid release cadence mentality the industry has been seduced/coerced into. Win 10 updates come to mind. It isn't just planes crashing that cause problems,...

Development

QA/UAT (same database)

Production

Between this question and the one on varchar conversion the takeaway is never trust implicit conversion? To be honest once the real was truncated the value should have remained the...

Almost my entire career has been spent as the solo IT person at whatever company I was with. On the one occasion I actually was part of a large IT...

The cloud has no security. Full stop.

Any temporary security built into clould solutions has vulnerable points that can be attacked, no matter what. Worse, the defenders won't know about the...

Your editorial I think overlooks the inherent priorities that must be present in a DBA's role.

First, the data must be kept *safe*, full stop.

At the bare minimum that means reliable...

Having read the entire thread I think it boils down to a cautionary tale with these points.

1) Good enough is often judged by people who are not qualified to make...

I've been a developer for over 35 years. While there is a *little* merit in "good enough" coding (but who decides "good enough"?) the refrain of "shipping is a feature"...

I admit it, I got caught by the "fromTest" 😀

This is yet another example of how badly designed SQL syntax really is, from an ambiguity standpoint. If the "AS" keyword...

I've been in this business for over 30 years and seen the enthusiasm for certificates wax and wane several times. In my experience they're totally useless "cram" tests that cover...

Sigh.

Ok, first whoever this guy was, he's an idiot. If his group allows him to lead then they're all idiots.

Therefore let the punishment fit the crime. If that group doesn't...