2012.11.27

SQL

• SQL Server Performance Statistics Using a Server Side Trace
  http://www.mssqltips.com/sqlservertip/1035/sql-server-performance-statistics-using-a-server-side-trace/

     

• How to set the default transaction isolation level server wide?
  http://blogs.msdn.com/b/ialonso/archive/2012/11/26/how-to-set-the-default-transaction-isolation-level-server-wide.aspx

     

• The Importance Of Trust
  http://shaunjstuart.com/archive/2012/11/the-importance-of-trust/
  Check constraints option의 활성화와 비 활성화에 따른 플랜.

     

• Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth
  http://www.sqlservercentral.com/articles/Stairway+Series/94579/

     

• Handling Backups for Rapid Resilience
  http://www.simple-talk.com/sql/database-administration/handling-backups-for-rapid-resilience/

     

Cloud & BigData

• SQL SERVER – Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3
  http://blog.sqlauthority.com/2012/11/26/sql-server-sends-backups-to-a-network-folder-ftp-server-dropbox-google-drive-or-amazon-s3/