SQL Slayer

http://www.sqlslayer.com/wp/admin-database/

New object (DBExtProps) added.

We are very excited to finally release our first “official” release of the admin database objects. While we are still not yet ready for the documentation (shocking, I know), the objects have gone through a fair amount of testing and we’re confident that your environment is ready to utilize them. Lots of new changes and [...]

http://www.sqlslayer.com/wp/admin-database/

We’re one step closer to having our first “official” release with this latest release. The configuration now properly supports build specific as well as 2008. Next step is to make an update to the utility and finish up the documentation. We’re almost there!

Rewrote configuration to use new buildMin and buildMax parameters.
Fixed collation problem with CheckDB/FileIO [...]

http://www.sqlslayer.com/wp/admin-database/

Added a new view to show last time a user logged in and what database they accessed. Credit given to Jack Corbett.

http://www.sqlslayer.com/wp/admin-database/

who/who_vw: Added net_transport and auth_scheme
JobOperators: Added checks to make sure @Email, @Page or @NetSend was passed, Fixed Changed column to properly display that a job was updated

http://www.sqlslayer.com/wp/admin-database/

Added LRTRIM/RTRIM to several of the who columns (who procs and view).
Added exclusion for QueueReader job steps in JobLogging.

http://www.sqlslayer.com/wp/admin-database/

Resolved issue with SQLServerStartupNotification blowing up when additional startup procedures existed.
Enhanced maintenance procedures for more selective maintenance.
Added JobOperators procedure.

http://www.sqlslayer.com/wp/admin-database/

Removed model database from BackupDB

We are finalizing a new version of the admin update utility which will better support specific versions of SQL (ie two part OBJECT_ID was not supported until 2005 SP2), as well as better support 2008. Once we have updated the configuration, we are planning to release an official release of the [...]

http://www.sqlslayer.com/wp/admin-database/

Minor bug fixes for ChangeOwner, JobLogging
File naming enhancements for Trace_Blocking

http://www.sqlslayer.com/wp/admin-database/

Added support for RedGate backups
Added additional permissions for StandardGroupPermissions and new roles
Removed two part object_name call in CHECKDB for support pre-SP2
Resolved problem where ‘renamed’ column was not being updated when database owner was changed with ChangeOwner