Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.

SQL Overview IV - DBA's Morning Review

Continuing on with his very popular series on monitoring your servers, David Bird takes a look at how you manage checking on multiple servers.

Telecommuting – Thinking Outside the Cube

The concept of telecommuting is arguably the most controversial working arrangement to evolve from the 1990's technological revolution. Tim Ford explains what it requires to work remotely – not just the tools you need, but the also character traits.

usp_SecurCreation - SQL 2k5/2k8

Creates statements for securables creation.

usp_SecurCreation - SQL 2k

Creates statements for securables creation.

usp_ActiveProcesses - SQL 2k5

Returns list of active processes and their buffer contents over a specified time.

usp_IndexesUnused - SQL 2k5

Checks index usage

usp_ShowOrphanUsers - SQL 2k5

Check Orphaned logins ie, not associated with any database on the current instance.

Moving Databases

SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.

Statistics