Standard Production DBA Tasks: DBCC CHECKDB

Standard Production DBA Tasks:

DBCC CHECKDB (Transact-SQL)
Updated: 1 February 2007
Checks the logical and physical integrity of all the objects in the specified database by performing the following operations:
Runs DBCC CHECKALLOC on the database.
Runs DBCC CHECKTABLE on every table and view in the database.
Runs DBCC CHECKCATALOG on the database.
Validates the contents of every indexed view in the database.
Validates the Service Broker data in the database.
This means that the DBCC CHECKALLOC, DBCC CHECKTABLE, or DBCC CHECKCATALOG commands do not have to be run separately from DBCC CHECKDB. For more detailed information about the checks that these commands perform, see the descriptions of these commands.

New SQL Server 2005 Features: DDL Trigger

New SQL Server 2005 Features: DDL Trigger

SS05 has a nice feature that allows you to control who is dinking with your tables and what they can do.

“A DDL Trigger can fire after execution of any Transact-SQL event that belongs to a predefined grouping of similar events. For example, if you want a DDL trigger to fire after any CREATE TABLE, ALTER TABLE, or DROP TABLE statement is run, you can specify FOR DDL_TABLE_EVENTS in the CREATE TRIGGER statement. After CREATE TRIGGER is run, the events that are covered by an event group are added to the sys.trigger_events catalog view.” http://msdn2.microsoft.com/en-us/library/ms186406.aspx

New SQL 2005 Features - On-line Restore.

Favorite SQL 2005 Features On-line Restore.
On-line Restore. This works well with restoring one filegroup while not bringing down the whole system