Some useful SQL Server installation/configuration advice

I tended to do most of this automatically, but a reminder is good.

http://www.sql-server-performance.com/2014/post-installation-steps/

One thing that I love in recent versions of SQL Server, I think it started in the ’08 release, is the ability to use non-Exchange email accounts.  My current project is a hosted server that is not part of our domain, and we didn’t want to install Exchange on it just so it could send me emails: too many resources consumed in terms of disk and CPU.  Conveniently I could set it up with its own Gmail account and then configure the operators to send alerts to both my work email and my personal email along with the DBCC summary.

Here’s the article that I used that explains the process of setting up non-Exchange email for SQL Server:

http://www.mssqltips.com/sqlservertip/2578/setup-sql-server-database-mail-to-use-a-gmail-hotmail-yahoo-or-aol-account/