Scary Sql Surprises and Mistakes with Brent Ozar Redgate

BrentOzarl.com/sp_blitz for any disabled indexes in any databases DDL triggers for when people create a table without a clustered index

https://www.youtube.com/embed/UesS08AUcDQ?start=639&end=1057

SQL Server, dont install SSIS, SSRS, SSAS onto the sql server box, the RAM is the most valuable thing you have there Dont run SSMS on the SQL server dont even remote in dump as much memory as you can into it