2013.06.24

   

SQL

   

• The Accidental DBA (Day 23 of 30): SQL Server HA/DR Features - Erin Stellato

  http://www.sqlskills.com/blogs/erin/sql-server-hadr-features

     

• The Accidental DBA (Day 22 of 30): Determining a High-Availability Strategy - Jonathan Kehayias

  http://www.sqlskills.com/blogs/jonathan/the-accidental-dba-day-22-of-30-determining-a-high-availability-strategy

     

• The Accidental DBA (Day 21 of 30): Essential PerfMon counters - Jonathan Kehayias

  http://www.sqlskills.com/blogs/jonathan/the-accidental-dba-day-21-of-30-essential-perfmon-counters

  예전에 주언형이 정리해주신 자료도 있는데,^^

   

• Optimize for… Mediocre?

  http://www.brentozar.com/archive/2013/06/optimize-for-unknown-sql-server-parameter-sniffing/        

     

• sa 로그인 활성화

  http://laigo.kr/740

   

• Maximizing Throughput with TVPs(Table Valued Parameters)

  http://sqlcat.com/sqlcat/b/technicalnotes/archive/2013/06/13/maximizing-throughput-with-tvps.aspx        

     

• Querying SQL Server Index Statistics

  http://www.mssqltips.com/sqlservertip/2979/querying-sql-server-index-statistics/

     

Other

   

• 인텔리J 시작하기 Part3 (Getting Start IntelliJ) – SVN -

  http://beyondj2ee.wordpress.com/2013/06/23/%EC%9D%B8%ED%85%94%EB%A6%ACj-%EC%8B%9C%EC%9E%91%ED%95%98%EA%B8%B0-part3-getting-start-intellij-svn/

     

• Setting up MySQL SSL and secure connections

  http://www.mysqlperformanceblog.com/2013/06/22/setting-up-mysql-ssl-and-secure-connections/

     

• Update on home learning lab – Hyper-V

  http://www.pythian.com/blog/update-on-home-learning-lab-hyper-v/        

     

• DBMS는 어떻게 트랜잭션을 관리할까?

  http://helloworld.naver.com/helloworld/textyle/407507

  트랜잭션 개념을 잘 정리된 자료입니다.