2013.02.04

SQL

   

• SQL Server 2012 Diagnostic Information Queries (Feb 2013) - Glenn Berry

  http://sqlserverperformance.wordpress.com/2013/02/01/sql-server-2012-diagnostic-information-queries-feb-2013/

   

• Don't change value of that parameter - CSS SQL Server

  http://blogs.msdn.com/b/psssql/archive/2013/02/03/don-t-change-value-of-that-parameter.aspx

  흥미로운 이슈입니다.

  1) option (optimize for (@BatchID unknown))

  2) dbcc traceon (2389,2390,-1)

  enable automatically generated quick statistics for ascending keys

  http://sqlblog.com/blogs/kevin_kline/archive/2008/05/19/why-isn-t-auto-update-statistics-running.aspx

     

• SQL Server support levels        

  http://www.sqlserver-dba.com/2013/02/sql-server-support-levels.html        

  지원일정 확인하세요^^

  SQL Server 2000 – Extended support will finish on April 19th,2013.

  SQL Server 2005 – Extended support started on April 12th ,2011

   

• Hurricane Sandy Mash-Up: Hive, SQL Server, PowerPivot & Power View        

  http://blogs.msdn.com/b/cindygross/archive/2013/01/31/mash-up-hive-sql-server-data-in-powerpivot-amp-power-view-hurricane-sandy-2012.aspx

     

• Intel Flash Storage Products for SQL Server - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/interesting-flash-storage-products-from-intel-2/

   

• SQL Server 2012 Service Pack 1 Cumulative Update 2        

  http://www.sqlskills.com/blogs/glenn/sql-server-2012-service-pack-1-cumulative-update-2/

     

• SQL Server disaster-recovery poster now available

  http://www.sqlskills.com/blogs/paul/sql-server-disaster-recovery-poster-now-available

     

• Customizing Extended Events Templates in SQL Server 2012

  http://www.sqlskills.com/blogs/jonathan/customizing-extended-events-templates-in-sql-server-2012/

     

• ASK THE UNICORN: HOW TO BECOME A DBA?

  http://www.jasonstrate.com/2012/10/ask-the-unicorn-how-to-become-a-dba

     

• Difference between System DSN and User DSN

  http://www.sqlserver-dba.com/2013/02/difference-between-system-dsn-and-user-dsn.html

     

• Benefits of the Bulk-Logged Recovery Model

  http://sqlsalt.com/benefits-of-the-bulk-logged-recovery-model/

     

• Database mirroring cannot be enabled because the database is not in full recovery mode on both partners

  http://www.sqldbadiaries.com/2013/02/01/database-mirroring-cannot-be-enabled-because-the-database-is-not-in-full-recovery-mode-on-both-partners

     

• Silent Truncation of SQL Server Data Inserts

  http://www.mssqltips.com/sqlservertip/2857/silent-truncation-of-sql-server-data-inserts/

     

• SQL SERVER – Difference Between NOLOCK and NOWAIT Hints

  http://blog.sqlauthority.com/2013/02/01/sql-server-difference-between-nolock-and-nowait-hints/

     

     

ETC        

   

• 페도라-오픈수세, 오라클 마이SQL 뺀다

  http://www.zdnet.co.kr/news/news_view.asp?artice_id=20130202024310

   

• Hadoop 적용 사례 기사 정리

  http://blrunner.com/41

     

• elasticsearch로 로그 검색 시스템 만들기

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