2012.12.18

MSSQL

   

• The DBA's Holiday Checklist

  http://blogs.technet.com/b/dataplatforminsider/archive/2012/12/17/the-dba-s-holiday-checklist.aspx

   

• Trimming the Transaction Log Fat (By Paul Randal)

  http://www.sqlperformance.com/2012/12/io-subsystem/trimming-t-log-fat

   

video http://www.youtube.com/watch?v=yTtIqEj_xjE&feature=youtu.be

Source http://www.sqlskills.com/InsiderContent/YouTube/Insider201104-2Code.zip

   

• "Don't Touch That Button!" Four Dangerous Settings in SQL Server (video)

  http://www.brentozar.com/archive/2012/12/dont-touch-that-button-four-dangerous-settings-in-sql-server-video/

     

  절대 세팅하지 말것!

  

     

  

     

  

     

  

     

  

     

• Logon Triggers Can Stop SQL Agent From Starting

  http://shaunjstuart.com/archive/2012/12/logon-triggers-can-stop-sql-agent-from-starting-2/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+ShaunJStuart+%28Shaun+J+Stuart+-+SQL+Server+DBA%29

  로그온 트리거로 인한 SQLAgent가 시작할 수 없을 수도 있다. 이때는 시작 타입을 지연된 시작으로 설정한다.