2013.06.28

   SQL

   

SQL Server 2014

   

• SQL Server 2014 – Public CTP Now Available

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/25/sql-server-2014-public-ctp-now-available.aspx

   

• AlwaysOn in SQL Server 2014 CTP1

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/27/alwayson-in-sql-server-2014-ctp1.aspx

     

• More XEvents in SQL Server 2014 CTP1 – don't wait any longer

  http://www.sqlskills.com/blogs/bobb/more-xevents-in-sql-server-2014-ctp1-dont-wait-any-longer/

  헐... 763개의 확장 이벤트들 여기서 145개가 새롭게 생겼군요. 여전히 프로파일러와 이벤트 시스템을 유지되었다고 합니다. 휴~ 다행이야^^

  추가된 이벤트에는 4개의 패키지에는 3개는 Hekaton 관련 이벤트라고 하네요(internals, compiler, runtime)

  68개 이벤트들은 sqlserver 패키지, 여기에는 10개 이상의 Hekaton event들이 패키지에 속한다고 하네요. 추가적으로 azure storage 등등~~

     

• The Accidental DBA (Day 27 of 30): Troubleshooting: Tempdb Contention - Paul S. Randal

  http://www.sqlskills.com/blogs/paul/the-accidental-dba-day-27-of-30-troubleshooting-tempdb-contention

   

• Lazy Log Truncation – Clearing of SQL transaction log VLF status deferred

  http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/06/27/lazy-log-truncation-clearing-of-sql-transaction-log-vlf-status-deferred.aspx

     

• The Top 3 Indexing Mistakes in SQL Server (video)

  http://www.brentozar.com/archive/2013/06/the-top-3-indexing-mistakes-in-sql-server-video/

     

• Managing Transaction Log Growth

  http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/managing-transaction-log-growth

     

• Which loads faster – 2008, 2008 R2 or 2012

  http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/which-loads-faster-2008-2008        

   

• Export to XML Using SSIS

  http://www.sql-server-performance.com/2013/export-to-xml-using-ssis/

     

• SQL SERVER – Another lesser known feature of SQL Server Management Studio 2012 – Guest Post by Balmukund Lakhani

  http://blog.sqlauthority.com/2013/06/27/sql-server-another-lesser-known-feature-of-sql-server-management-studio-2012-guest-post-by-balmukund-lakhani/

     

• SQL Swiss Army Knife #12 - Index information galore!

  http://blogs.msdn.com/b/blogdoezequiel/archive/2012/04/08/sql-swiss-army-knife-12-index-information-galore.aspx#.UczLNvl7LE0

     

• Expand your Powershell mind – Three key cmdlets

  http://www.sqlserver-dba.com/2013/06/expand-your-powershell-mind-three-key-cmdlets.html

     

Other

   

• MongoDB 모니터링 툴인 mongostat의 웹 버전 mongoowl을 출시

  http://mongodb.citsoft.net

     

• [입 개발] Redis Sentinel의 동작 방식에 대하여…

  http://charsyam.wordpress.com/2013/06/27/%EC%9E%85-%EA%B0%9C%EB%B0%9C-redis-sentinel%EC%9D%98-%EB%8F%99%EC%9E%91-%EB%B0%A9%EC%8B%9D%EC%97%90-%EB%8C%80%ED%95%98%EC%97%AC/