Enjoy the movie. I hope we'll go see it as well. No fireworks for us, but we did lightly hike and go to the mountains for the weekend. Working today,...

Exactly. These people need access, they aren't affected by least privilege. They also can't all be fired all the time, though perhaps a few terminations would slow this down.

Ha, everything takes hours on the ranch. Cutting the property takes about 40-44 hours. Do it once a year, but behind this year.

The CEK isn't stored on the client, though maybe we could argue this is accessed by the client. I used accessed because the CMK can be stored in a cert...

My day was a half bust. My kid is the touch of death to machines, taking down both the riding mower and rotary mower last week as I was getting...

LOL, the auto bump was something we had for years, got lost, and now it's back.

At least it got you to respond that you read the post 😉

Times change and people change. No one is a criminal until they commit a criminal act.

Monitoring makes sense, not the least of which is from privilege/credential theft or malware under...

You mentioned the user picks the database in the report. Wouldn't that be the value you use to query the db?

If there's one row, then for comfile_sql, use this:

            
July 2, 2019 at 8:26 pm
            
#3659508

            
            
                                                
        

If you're populating the report with the company name, then this is only querying one table, correct?

I assume your context isn't the right database, so you really need a query...

Status update has a list now - https://www.sqlservercentral.com/forums/topic/status-update-2-jul-2019

OK, sharded/federated databases. Is there a reason you search all dbs rather than asking if this user as access in this db/company? I assume that the humres table exists everywhere?

Not...

I hate to duplicate all GH issues here, but I can perhaps add a list to the status update of the front end items that might let you know what's...

Issue in backlog already. Below search and a few other things.

+1 to what Jeff said

Is this a one time thing or a regular query? Because searching across all databases and checking if a table exists is going to be bad for performance and not...