This script gives a server level snapshot of recent security changes  Read more...

Using sys.dm_os_buffer_descriptors we can find out how much memory a database or a object is consuming.  Read more...

You can use the following query to find the currently active requests, their associated T-SQL statement, and the corresponding query plan that is allocating most space resources in tempdb.  Read more...

Louis Davidson describes why all DBAs should strive to be replaceable, and what that really means.  Read more...