2013.09.04

MS의 MCM 인증이 종료 되었나봐요~ 헐~ 요즘 그 이슈로 트위터에서 한참 난리네요^^   

SQL

   

• DBCC CHECKDB Execution Memory Grants ? Not Quite What You Expect
  http://www.sqlskills.com/blogs/jonathan/dbcc-checkdb-execution-memory-grants-not-quite-what-you-expect/

     

  

• http://www.youtube.com/user/sqlpassion
• 

  이분 동영상 아주 쥑이져^^ 실제 화장실에서 촬영해서 올려주신 자료도 있어요^^
   

   

• Forced Parameterization Can Lead to Poor Performance

  http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/09/03/forced-parameterization-can-lead-to-poor-performance.aspx

   

• Solving Session Management Database Bottlenecks with In-Memory OLTP

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/09/03/solving-session-management-database-bottlenecks-with-in-memory-oltp.aspx

     

• Last Weeks Top "Reading" Links #47

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/09/03/last-weeks-top-reading-links-47.aspx

     

• Introduction to Integrity: Interpreting DBCC CHECKDB Results

  http://www.sqlsoldier.com/wp/sqlserver/introductiontointegrityinterpretingdbcccheckdbresults

     

• Fixing SQL Server error in-row data RSVD page count is incorrect

  http://www.mssqltips.com/sqlservertip/3029/fixing-sql-server-error-inrow-data-rsvd-page-count-is-incorrect/

     

• 실행 제한 조건 - 우주의정복자

  http://blog.naver.com/ioahn/90180371645

  궁굼했는데... 인옥형님이 후딱 정리하셨네..

     

• Transactional Replication ? Violation of Primary Key Constraint

  http://www.sql-server-performance.com/2013/transactional-replication-violation-of-primary-key-constraint/

     

• SQL ? Find CPU,Memory,Connections, VLF's,I/O of all the Databases

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/09/03/sql-find-cpu-memory-connections-vlf-s-i-o-of-all-the-databases.aspx

     

• Variable Default Values to a Stored Procedure (SQL Spackle)

  http://www.sqlservercentral.com/articles/Stored+Procedures/101488/

     

• Large transaction log files

  http://sqlmonitormetrics.red-gate.com/large-transaction-log-files/

     

• SQL Server Software: Ask the Right Questions and Start Small

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/09/03/sql-server-software-ask-the-right-questions-and-start-small.aspx

     

• SQL Server Reporting Services Tips and Tricks to Improve the End User Experience

  http://www.mssqltips.com/sqlservertip/3023/sql-server-reporting-services-tips-and-tricks-to-improve-the-end-user-experience/

     

• Tabular Basket Analysis: Simple Data Mining in Tabular databases

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/09/03/tabular-basket-analysis-simple-data-mining-in-tabular-databases.aspx

     

• Full text rebuild option ? and SQL Server performance

  http://www.sqlserver-dba.com/2013/09/full-text-rebuild-option-and-sql-server-performance-.html

     

• How to Get Your Manager to Pay for Training

  http://www.brentozar.com/archive/2013/09/how-to-get-your-manager-to-pay-for-training/

     

• THE #SQLMCM IS DEAD, BUT THE EXPERIMENTS GO ON

  http://ozar.me/2013/09/the-sqlmcm-is-dead-experiments-go-on/

     

• Microsoft shut down MCM/MCSM/MCA programs?my recap #msmcm

  http://sqlblog.com/blogs/marco_russo/archive/2013/09/03/microsoft-shut-down-mcm-mcsm-mca-programs-my-recap-msmcm.aspx

     

     

Other

   

• Memcached: In-memory Caching System

  http://java.dzone.com/articles/memcached-memory-caching