2013.07.03

   

SQL

   

• A gentle introduction to transaction isolation levels and Hekaton tables - Bob Beauchemin

  http://www.sqlskills.com/blogs/bobb/a-gentle-introduction-to-transaction-isolation-levels-and-hekaton-tables/

  저도 white paper 보고 hekaton의 격리수준을 가져가도 동시성은 해결되는 것일까~ 좀도 공부해보고 알려드려야겠어요. Hekaton에서 지원되는 격리수준은 기존 격리수준과 다르게 SNAPSHOT, REPEATABLE READ, SERIALIZABLE 3가지만 지원됩니다.

     

• July, the 31 Days of SQL Server DMO's ? Day 2 (sys.dm_exec_sessions)

  http://sqlblog.com/blogs/tamarick_hill/archive/2013/07/02/july-the-31-days-of-sql-server-dmo-s-day-2-sys-dm-exec-sessions.aspx

  dmv 2일째네요. 중요한 dmv 중에 하나죠.. 연결된 세션 정보 보기 ^^ 여기에는 연결 정보, 언어, 데이타 포맷, quoted identifier, arithabort, ansi padding, ansi nulls 등등 볼 수 있구요. session_id가 spid인거 아시죠?

     

• On Bobcats per 100 Orders and Other Spurious Metrics

  http://www.brentozar.com/archive/2013/07/on-bobcats-per-100-orders-and-other-spurious-metrics/

     

• Index Internals and How Filtered Indexes Look Like (Part 2)

  http://www.pythian.com/blog/index-internals-and-how-filtered-indexes-look-like-part-2/

     

• SQL 2014 CTP1 Forum on MSDN

  http://blogs.msdn.com/b/arvindsh/archive/2013/07/02/sql-2014-ctp1-forum-on-msdn.aspx

     

• SSMS Tools Pack 2.7 is released. New website, improved licensing and features.

  http://weblogs.sqlteam.com/mladenp/archive/2013/07/02/ssms-tools-pack-2-7-is-released-new-website-improved.aspx

     

• Understanding What sp_updatestats Really Updates

  http://www.sqlperformance.com/2013/07/sql-statistics/statistics-updates

     

• Running SSMS Under A Different Windows Account

  http://shaunjstuart.com/archive/2013/07/running-ssms-under-a-different-windows-account/

     

• How to perform an in-place upgrade of Powershell

  http://www.sqlserver-dba.com/2013/07/how-to-perform-an-in-place-upgrade-of-powershell.html

     

• Change the Maintenance Plan Owner

  http://www.sqlservercentral.com/articles/Maintenance+Plans/98189/

     

Other

   

• "김정선님" SQL Server 2012 특강 - 7월 6일 특강~

  http://blog.naver.com/visualdb/50174611703

     

• Algorithm of the Week: Practical Parallelizing in R

  http://architects.dzone.com/articles/algorithm-week-practical