Yes, at work we were TOLD many times lock your PC when you leave your office.  The group policy is the catch all.  Granted, it won't stop all eyes and...

Many places now have a group policy that when a PC goes inactive for 5 minutes it will automatically lock.

It does seem crazy that you have to have ADMIN rights to monitor systems doesn't it?  The different operating system developers need to come up with a way to view/capture...

This is a stretch but could it be after your delete that the data is spread all over the disk within the db still so the time it takes to...

There IS a ransomeware thing going around effecting SQL Servers.

https://securityaffairs.co/wordpress/108341/hacking/mrbminer-mssql-miner.html

Thank you for your input.  We decided to go with a new server running 2019.

Oh yes that is the plan.  Identify, communicate to everyone the lists of databases, back them up to a non expiring place, OFFLINE them for 2-3 months then drop them. ...

Lowell.   THANK YOU.   I was overthinking it.  Why didn't I think of your first one for the NOT IN.  But thanks for the second one as well.  That...

Thanks Jeff but that is above my SQL coding abilities.

Yea, that is the problem with this one.  It only lists the dbs since last server restart that have been accessed, I want an opposite list.  In a SQL Server...

That is all fine.  But with some of our servers having 500+ databases on them that is going to be way too hard to interpret the output.  I simply need...

Great query.  Question though.   What is the difference between the date/timestamp for a database of the server restart versus NULL though?

2020-07-17 20:47:46.113 DB_AX_20190724 2020-07-17 20:47:55.650 NULL 2020-07-17 20:47:55.550 NULL

2020-07-17 20:47:46.113 DB_AX2 2020-07-17 20:47:59.580 NULL NULL NULL

If you would drive a Dodge Hellcat Charger, Challenger, or a 700HP Jeep Grand Cherokee you would be shocked how much fun those are to drive.  Any Challenger is a...

Designers hands are tied today.  CAFE standards force designers to make a vehicle go through the wind tunnel with the least amount of drag.  That is why every car and...

This is perfect.  Thank you.