T-SQL Tuesday #45–Follow the Yellow Brick Road

Is it me or does it seem like we just had a T-SQL Tuesday blog party? These days are just flying by! This week Mickey Stuewe (b|t) is hosting and she has brought up a fabulous question about auditing with the topic being Follow The Yellow Brick Road. I have been on both sides of …

Continue reading T-SQL Tuesday #45–Follow the Yellow Brick Road

Database Auditing ~ Who Did What?

Real life scenario ~ I've seen companies that I've come into not have their production environment on lock down and every one who is anyone has access to the environment. I like the idea of having a table with the following columns: AuditID - Unique Identifier AuditDate - Date the event occurred LoginName - Who …

Continue reading Database Auditing ~ Who Did What?