Well here we go.. my first podcast. Big thanks to Brent Ozar for helping both by critiquing the video ahead of time (and providing some very valuable feedback) as well as offering to encode, setup, and host the video on SQLServerPedia.com. In watching the video on SQLServerPedia I’m already thinking of ideas for topics of [...]
Posts Tagged ‘Audit’
Server Role Audit – a quick and dirty script
Every now and again I like to run a quick audit of the SQL Servers I support and ensure that logins do not have any elevated permissions on a server. With properly auditing and tracking you should be able to identify any problems when they happen but it doesn't hurt to give the server(s) a [...]
Database Role Audit (alpha version)
OK so this is kind of a “part 2″ to a post I made a while back about doing a SQL Server Role Audit. I wanted to go to the next level down and do the same type of thing for all database roles (system and user). This is definitely an “alpha version” of the [...]
