Viewing 15 posts - 1 through 15 (of 1,496 total)
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...
January 13, 2021 at 3:44 pm
Many places now have a group policy that when a PC goes inactive for 5 minutes it will automatically lock.
January 13, 2021 at 1:00 pm
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...
January 6, 2021 at 9:20 pm
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...
November 25, 2020 at 12:52 pm
There IS a ransomeware thing going around effecting SQL Servers.
https://securityaffairs.co/wordpress/108341/hacking/mrbminer-mssql-miner.html
September 16, 2020 at 2:00 pm
Thank you for your input. We decided to go with a new server running 2019.
September 15, 2020 at 6:06 pm
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. ...
August 6, 2020 at 1:18 pm
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...
August 4, 2020 at 7:13 pm
Thanks Jeff but that is above my SQL coding abilities.
August 4, 2020 at 6:33 pm
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...
August 3, 2020 at 12:57 pm
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...
August 3, 2020 at 12:56 pm
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
July 31, 2020 at 11:53 am
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...
July 24, 2020 at 5:03 pm
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...
July 24, 2020 at 12:17 pm
This is perfect. Thank you.
June 25, 2020 at 12:58 pm
Viewing 15 posts - 1 through 15 (of 1,496 total)