2013.03.29

   

SQL

   

• Clarification of Microsoft's SQL Server 2012 Servicing and Support Policy - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/clarification-of-microsofts-sql-server-2012-servicing-and-support-policy/

     

• Squishy Limits in SQL Server Express Edition

  http://sqlblog.com/blogs/kevin_kline/archive/2013/03/28/squishy-limits-in-sql-server-express-edition.aspx

  Express 버젼 사용하시는 분들이 봐두시면 좋겟네요^^. db마다 10G 저장용량 제한, 메모리 1G 제한이지만(메모리 1기가 제한이 딱 데이터버퍼만 이야기 한다 플랜캐시나 다른 데이터 영역은 제한하지 않았으니 1기가 보다 더 쓸수 있다.)

     

• Making the Case for Regular SQL Server Servicing

  http://www.sqlperformance.com/2013/03/system-configuration/sql-server-servicing

     

• Conditional aggregation - SUM Vs COUNT

  http://beyondrelational.com/modules/2/blogs/70/posts/19240/conditional-aggregation-sum-vs-count.aspx

     

• Re-throw Errors with Logging

  http://www.sqlservercentral.com/articles/Error+Handling/97007/

     

• Ad-Hoc XML File Querying

  https://www.simple-talk.com/sql/database-administration/ad-hoc-xml-file-querying/

     

• Using Event Viewer Logging for SSIS Performance Trouble Shooting

  http://itknowledgeexchange.techtarget.com/sql-server/using-event-viewer-logging-for-ssis-performance-trouble-shooting/

     

• Comparison of Queries Written in T-SQL and SQL Server MDX

  http://www.mssqltips.com/sqlservertip/2916/comparison-of-queries-written-in-tsql-and-sql-server-mdx/

     

     

기타

   

• Simple JSON Encode/Decode in Pure Lua        

  http://regex.info/blog/lua/json

     

• [MongoDB] Deployment Best Practices: Monitor your resources

  http://blog.mongodb.org/post/46504096409/deployment-best-practices-monitor-your-resources

     

• 충격 고로케 개발! 알고보니..

  http://readme.skplanet.co.kr/?p=4338