Tag: SQL-TIPS

Get last time Integrity Checks ran successfully on all databases

One of our responsibilities as DBAs is to perform all kind of maintenance tasks in our databases. Sometimes we create jobs and once these jobs work fine for some weeks we just forget about them and assume they’re all running fine all the time. Of course, you set alerts in case one of those jobs ...

Find Databases not backed up since specific date

One of our daily (and very important) tasks as Database Administrators is to ensure backups are being performed correctly. We also need to ensure that backups are functional but we’ll talk about that in later posts. You arrive at the office in the morning, tasting your first sip of coffee while your mailbox is loading ...