Another good reason to clear out unused code is when you have a column that is used to filter results and you find that it can contain a new...

People like Brent who say "don't clean up old code" apparently don't have much experience with 40-50 year old codebases that are still mission critical for more than 18...

Ah, that's good. I think.

Running that script for me shows no rights for dbo.

Do you have a screenshot? Wondering what you've got here.

I suspect logging in with the DAC might make this possible, but haven't tried. Curious what your system looks like. Can...

Thanks, I think that a lot of DevOps started out as let's be partners, but the automation overshadowed things and too many people don't act as partners with their clients.

Story of Murray's career.

I am getting killed on WRs, no one showing up or hurt. Amazed. I got 60 pts.

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...