Run a test, look at blocking with drop and create v rebuild. Add some activity on the table while you do this. If that doesn't help a developer understand, document...

I'll throw SQL Backup Pro in the mix. Not sure of the cost for you, but you'd have to ask. https://www.red-gate.com/products/dba/sql-backup/

However, I think Ola's scripts with some simple scripting/alerting...

Better get a thorough review of hardware and start ensuring backups are up to date. This is almost always hardware somehow causing a corrupt write in the filesystem.

Double check all...

Use AES. You'll have to decrypt, encrypt your data, but it's more secure.

I'm slightly confused about your problem. Full backups never truncated the log. They include part of the log, but you've always needed a log backup to get file reuse and...

I see this a little, and Microsoft does. Hence their investment in some PostgreSQL tools with ADS and other Azure services.

What I find often is that someone is short sighted....

Fillfactor, collation, some other change?

Do you have to look at your orders in some sequence? Meaning, I might need 5 Product3 and 2 Product4 for an order, but also 2 Product3 and 4 Product4...

I think Beatrix is on the right track. Something scheduled, likely outside of SQL, is affecting the cards. I would also be sure no "phone home" software is looking for...

Not sure what you mean here?...

Thought this was interesting as I'm doing a little HDFS testing. Haven't seen sp_configure used this way.

How often do your instances reboot/restart? For patching or anything? Take some guess here or use historical data. 12 is good for 3 months with no restarts. If you restart...

Interesting. If you solve it, love to know (or get an article on the solution)

High touch leads and PMs are the bane of getting a project done. The best ones give you an outline of what to do and a phone number to call...

Well, clearly Yahoo is a much better manager than I am. Drafted for me, set the first two lineups because I didn't recognize half the names, and it's worked out...