Office Hours: One-Word Answers Edition


Some of the questions y’all post at https://pollgab.com/room/brento are pretty straightforward. Let’s get ‘er done.

LetTheDbaHandleIt: My friend needs to track who has accessed what data. This is easy at OS and app level, but how can my friend verify that those who have direct DB access are not snooping on data inappropriately? e.g. payroll or HR DB. Yes, trust them, but how to verify (efficiently)? SS Profiler?
Erik: Do you know how to see last execution of a SQL view in SQL server?

Auditing.

PaginationWoo!: Hi Brent. In all of your training and demos you’re very AR (lol) about