2013.07.05

   

SQL

   

• SQL 2014 In-Memory OLTP 'Hekaton': training videos and white papers

  http://blogs.msdn.com/b/arvindsh/archive/2013/07/03/sql-2014-in-memory-oltp-hekaton-training-videos-and-white-papers.aspx

  Hekaton에 정리된 문서를 올려주었네요. 올려진 동영상과 문서를 참고하세요.

     

   

• July, the 31 Days of SQL Server DMO's – Day 3 (sys.dm_exec_connections)

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

   

• July, the 31 Days of SQL Server DMO's – Day 4 (sys.dm_exec_sql_text)

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

     

• SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes

  http://blog.sqlauthority.com/2013/07/04/sql-server-how-to-refresh-ssms-intellisense-cache-to-update-schema-changes/

     

• Database Health Reports – 800th download

  http://stevestedman.com/2013/07/database-health-reports-800th-download/

     

• Baselining with SQL Server Dynamic Management Views

  https://www.simple-talk.com/sql/database-administration/baselining-with-sql-server-dynamic-management-views/

     

• It ain't always easy; backup failure troubleshooting

  http://sql-sasquatch.blogspot.kr/2013/07/it-aint-always-easy-backup-failure.html

     

• Will Instant File Initialization Really Help My Databases?

  http://www.brentozar.com/archive/2013/07/will-instant-file-initialization-really-help-my-databases/

  디비 파일 즉시 초기화를 위해서 설정방법 소개(필수로 알아야 하죵?)

     

• Pending query memory grant requests; Resource Governor to increase query concurrency

  http://sql-sasquatch.blogspot.kr/2013/07/pending-query-memory-grant-requests.html

     

• Find the permission path of a Windows logon with XP_LOGININFO

  http://www.sqlserver-dba.com/2013/07/find-the-permission-path-of-a-windows-logon-with-xp_logininfo.html

     

• Stairway to Database Design Level 1: Data Elements

  http://www.sqlservercentral.com/articles/Stairway+Series/69801/

     

• Comparing Data Warehouse Design Methodologies for Microsoft SQL Server

  http://www.mssqltips.com/sqlservertip/2976/comparing-data-warehouse-design-methodologies-for-microsoft-sql-server/

     

• What's the Data Modeling Standard for Business Intelligence Systems?

  http://sqlblog.com/blogs/kevin_kline/archive/2013/07/02/what-s-the-data-modeling-standard-for-business-intelligence-systems.aspx

     

1. sp_ssiscatalog v1.0.4.0 available now with new feature - view most recent failed execution [SSIS]

   http://sqlblog.com/blogs/jamie_thomson/archive/2013/07/04/sp-ssiscatalog-v1-0-4-0-available-now-with-new-feature-view-most-recent-failed-execution-ssis.aspx        

      

      

      

Other

   

• When it's faster to use SQL in MySQL NDB Cluster over memcache API

  http://www.mysqlperformanceblog.com/2013/07/03/when-its-faster-to-use-sql-in-mysql-cluster-over-memcache-api/

     

• "The Lean Startup" 책에서 트윗 가능한 23가지 명언들

  http://mimul.com/pebble/default/2013/07/03/1372829720480.html

     

• Memory is the New Disc with Redis

  http://architects.dzone.com/articles/memory-new-disc-redis