@GFritchey Similar to SQL Server’s built-in index recommendations. Folks will still need to perform their due diligence and review existing indexes vs adding overlapping or duplicates.
Ok. That's it. I'm done with @evernote.
I spend more time dealing with their constant, unending "Upgrade Now!" popups than I do using the product.
It's time to move on. I'm thinking of OneNote as a replacement. Does anyone have any other recommendations?
LinkedIn algorithm: "Hey, we see you're a SQL DBA with 25+ years of IT experience, working remotely for the last decade. Here's our recommendation for you!"
@BrentO We commonly find this while doing health checks for new clients. It's like hitting the turbo button after configuring the socket count correctly :). Thanks for checking this in sp_blitz!
SQL Server's "Total Server Memory" consumption stagnant for months with 64GB+ more available dba.stackexchange.com/a/204099/426 In which sp_Blitz saves the day yet again.
Perform test restores of your critical #SQLServer databases regularly. Better yet, script out a process using #TSQL or #PowerShell & #dbatools and schedule to happen automatically.
You know, I just noticed that a DBA's standard phrase is "It Depends", the Network Engineer's is "I can ping it; it's not the network", and the Infosec's is "no, that's not allowed"
Five issues we frequently discover during our #SEROShield SQL Health Checks. Fortunately, these can be easily addressed. We also see a lot of SQL Servers that are behind on patching. What common configuration issues do you see when reviewing SQL Server settings?