Create a Custom Collection Set That Uses the Generic T-SQL Query Collector Type

http://msdn.microsoft.com/en-us/library/bb677277.aspx

Data Collection Terminology

http://msdn.microsoft.com/en-us/library/bb677279.aspx

SQL Server 2008 Management Data Warehouse

http://msdn.microsoft.com/en-us/library/dd939169(SQL.100).aspx

Create the RSExecRole

http://technet.microsoft.com/en-us/library/cc281308.aspx

Auditing DDL (Create, Alter, Drop) Commands in SQL Server 2005

DDL_Events

http://msdn.microsoft.com/en-us/library/ms186449.aspx

Auditing DDL (Create, Alter, Drop) Commands in SQL Server 2005

http://www.mssqltips.com/tip.asp?tip=1006


DDL Triggers in SQL Server - audit database objects

http://www.sqlbook.com/SQL-Server/DDL-Triggers-in-SQL-Server-34.aspx


DDL Statements with Database Scope

http://msdn.microsoft.com/en-us/library/ms189871(SQL.90).aspx

Free SQL Server tools

http://weblogs.sqlteam.com/mladenp/archive/2007/11/20/Free-SQL-Server-tools-that-might-make-your-life-a.aspx

Getting User Session information in SQL server 2005

1 . select * from sys.dm_exec_sessions
But the above command will show the user sessions and as well as the system sessions, if you want to only see the user connections then following is the command;

2. select * from sys.dm_exec_connections
you can also get the session id from the below command and match it with the session_id column of the 2 or 1 command for viewing the specific session information.

3. Select @@SPID

Getting User Session information in SQL server 2005

In SQL server 2005 if you want to check all SQL server sessions following is the command for viewing this;
1 . select * from sys.dm_exec_sessions
But the above command will show the user sessions and as well as the system sessions, if you want to only see the user connections then following is the command;
2. select * from sys.dm_exec_connections
you can also get the session id from the below command and match it with the session_id column of the 2 or 1 command for viewing the specific session information.
3. Select @@SPID

tablediff Utility

tablediff Utility

http://msdn.microsoft.com/en-us/library/ms162843(SQL.105).aspx

SQL Server 2005: TableDiff.exe GUI

http://weblogs.sqlteam.com/mladenp/archive/2007/08/10/60279.aspx

ex:

tablediff.exe -sourceserver king\uat -sourcedatabase courses -sourcetable pweb_parameters -destinationserver nelson\dev -destinationdatabase courses -destinationtable pweb_parameters -et diff.dbo.diff -f c:\update.sql

Database Mirroring Best Practices and Performance Considerations

http://msdn.microsoft.com/en-us/library/cc917681.aspx


Microsoft SQL Server 2005 Database Mirroring (EMC)

http://www.emc.com/collateral/hardware/white-papers/h2649-microsoft-sql-srvr-2005-db-mirror-wp-ldv.pdf