SQLTeam Blog has plenty of scripts for this type of thing. This should be the one you are looking for. They also have ones to use if you need...

The best option would be to try the command line install. It would allow you to specify what can be installed, down to specific features.

Itzik Ben-Gan is the best author to look for on T-SQL fundamentals and deep dive things. he has some good books on Amazon for nice price.

I don't really believe you have taken in Gail's advice completely. You might want to go back and read through from the beginning.

Find out why your logfile is big...

Just curious but why do you care about LOGOUTs? If your security hardening is for purposes of policy (company or vendor such as PCI or HIPPA) most only want...

The read-me file that comes with the download or is in BOL should suffice in giving you all this information.

Most important thing BACKUP, BACKUP, BACKUP...and not just the databases (especially...

Brent Ozar is the expert (or one of them) you can check out this sectin on his blog for documentation to backup your request: http://www.brentozar.com/sql/sql-server-san-best-practices/%5B/url%5D

You might also Bing/Google for Denny...

Sadly I only had Standard Edition on my Windows 7 so I have not tried installing SQL 2008 R2. If you have exausted Bing/Google and can't find anything you can...

Something I noticed reading this: Using the DTS Package Migration Wizard

Does it show up under "Other Upgrade Issues"? The upgrade advisor cannot analyze some DTS things in the msdb database,...

Do you have any databases that show compatibility levels of "80"? It may have done this check if it sees any at that level.

I think they had that issue with SQL Server 2008 in Windows 7 but fixed it in SP1. You might try loading the latest CU for SQL Server 2008...

If viewing SQL Server Configuration Manager you only see the SQLEXPRESS instance name, then the Standard edition you "installed" did not get installed properly or at all. If in the...

This is an article Paul Randal wrote on how Checkpoints work in SQL Server:

How do checkpoints work and what gets logged

In the post he goes into how he views what...

See Brad McGeHee...

Change the

PRINT @cmd

TO

sp_executesql @cmd

See here for reference (BOL)

Ain't it fun to learn new stuff...unless you are an MCM :w00t: you can always learn something new with SQL Server 😉