Biometrics are great, until you realize a few things. An injury, like a paper cut to a finger, can cut you out of access. Work in some industries, your fingerprints...

As an FYI, asking for replication to be implemented is a large change, especially with the potential issues of coupling with log backups in the future. More, I would ask...

Not only would I follow that advice, but I'd have that discussion in person then follow up with a bulleted email of the "requirements" discussed, asking for the DBA...

It is, but some maintenance stuff in there. Unless the data changes, I wouldn't expect you to lose rows from an index out of date. You might miss new rows,...

The performance counter. Not total memory, the target memory the reporting instance is wanting

Closing: Post here: https://www.sqlservercentral.com/forums/topic/issue-with-labels-in-a-pie-chart

That's a different article. Many companies don't want to do comparisons because it upsets one or more advertisers. It's also very hard to do a good objective review since many...

This might help you: https://www.sqlshack.com/automatically-maintain-full-text-indexes-catalogs/

Closing, see other thread

What are your target server memory and current memory settings?

I have used data janitor often for other IT people asking.

Thanks for the note. If I get a chance, i'll update the article. Of if you want to write an updated version that talks about the enhancements of sp_executesql over...

I had hopes that the GDPR would actually start to move the needle on this stuff, but I don't think it's going to. It's pretty clear that businesses are...

Did a little work here to solve some customer problem, so added a few. If you have ideas, would love someone to sketch out more complex ones: https://www.sqlservercentral.com/contributions

Yes, it's insane that it isn't taken more seriously.  People will say that they take it seriously, but then not give the people what they need to...