Your structure would depend on what questions or reports you want to produce from it.

As a starting point, a single table might be enough. In the table below,...

The deployment guide in the PerfCollector folder shows how to modify that; SQLH2 V2 Perf Collector Deployment Guide.

Should be able to add the counters you want in H2PerfConfigFile.xml.

SQL Server Health and History Tool (SQLH2)

The SQLH2 Performance Collector is a separate download that you'll need to collect perfmon data.

I'd suggest the same as AndyD, by using the Security Configuration Wizard the endpoints will be setup for you automatically. Each server can only have only one mirroring endpoint...

Unless you setup a named instance change ".\MSSQLSERVER" to "." or your computername.

By default, SQL Server express installs a named instance which is why it's specified that way in...

Can only confirm what you're seeing.

Both sp_send_dbmail and the SQL Agent didn't appear to use of the "Reply e-mail" even though it was configured.

From looking at a packet capture...

This BOL topic might be what you were looking for: OLE DB Provider for Microsoft Directory Services

BACKUP DATABASE [SPGLPROD] TO DISK = N'G:\Database_backup\SPGLPROD_Full_backup' WITH NOINIT , NOUNLOAD , NAME = N'BACKUP SPGLPROD Full backup', NOSKIP , STATS = 10, ...

It sounds like the backup file is being appended to instead of overwritten during each backup. Look in the maintenance plan to see how it's setup.

You could also run...

Thanks for the steps Mark. Would not have known that property existed otherwise.

Your Anti-virus software will have a problem with anything that uses port 25 unless you change the anti-virus software.

Assuming you're managing McAfee with ePO, is there a reason not to...

In SSMS select Database Mail under Management, right-click and Configure Database Mail. After that's complete send a test mail using the new profile to confirm that works.

Next, open the...

I kind of thought you might be looking for a way to change in VS...

I don't know if there's a setting in the report designer but you could change the behavior by specifying additional parameters in the URL.

For example if there's a report named...

Sounds like an interesting project.

With SQL 2005 you'll probably want to consider using VARBINARY(MAX) instead of the IMAGE data type.

At least one benefit to storing in the database would be...