CHECKDB

Finding and listing all columns in a database with default values

I was troubleshooting an issue last week on a vendor-developed database when they stated we needed to look at each one of the 50 tables in their database to make sure that all fields expecting default values, had default values assigned.

Options for scripting database objects

SQL Server Management Studio is rich with features. So rich, in fact, that after almost 3 years I am still finding new tools in the application that afford me more control over my databases and the methods for supporting them. Recently I found myself needing to script out a database and its objects for reviewing a problem offline.

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