2013.01.30

SQL

   

• SQL2012 보안가이드 PDF - 최인규 이사님, 이장래 수석님

  http://www.sqlroad.com/62 내용이 알차고 좋습니다 @.@

  

     

• [SQL2012BI]5. MSSQL 2012 DW 셋팅 - 김상수님
  http://www.sqler.com/539653#5
  DW 환경 SQL 세팅올려 주셨는데 DW 환경에서 고려해야 할 사항들입니다. DW 가이드라인으로 쓰면 아주 좋을 것 같네요 ~

     

• How Does the Cloud Change a Database Administrator's Job?

  http://sqlblog.com/blogs/buck_woody/archive/2013/01/29/how-does-the-cloud-change-a-database-administrator-s-job.aspx

   

• SQL Server – How to use READ_COMMITED_SNAPSHOT isolation level

  http://www.sqlserver-dba.com/2013/01/sql-server-how-to-use-read_commited_snapshot-isolation-level.html

     

• Providing SQL Agent Job Log Data for Developers

  http://www.mssqltips.com/sqlservertip/2858/providing-sql-agent-job-log-data-for-developers/

     

• Day 23 of 31 Days of Disaster Recovery: Restoring Differential Backups With New Files

  http://www.sqlsoldier.com/wp/sqlserver/day-23-of-31-days-of-disaster-recovery-restoring-differential-backups-with-new-files 연재식으로 재해복구를 31일간 올려주네요~ 내용도 알차요 ㅎ.ㅎ

     

• Visualizing Data File Layout III

  http://sqlblog.com/blogs/merrill_aldrich/archive/2013/01/28/visualizing-data-file-layout-iii.aspx

     

• Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using T-SQL

  http://www.mssqltips.com/sqlservertip/2869/configure-sql-server-2012-alwayson-availability-groups-readonly-routing-using-tsql