database administrator
Hi everyone, Sometimes we need to monitor a specific activity, for example a Backup, Restore, DBCC etc… And we also need to have, possibly, an estimated time of “arrival” (or ETA) it takes to finish […]
Sometimes we found ourselves into specific situations where we need to find all the stored procedures or functions containing a specific string in their codes, like a table name, specific command etc… For example, last […]
Greetings, The script below is a simple and very effective way to enable Query Store on all the databases that don’t have it yet. If you want to enable Query Store for any further database […]