2013.05.28

SQL

   

• SECURITY QUESTIONS: DIFFERENCE BETWEEN SYSADMIN AND CONTROL SERVER PERMISSION

  http://www.jasonstrate.com/2013/05/security-questions-difference-between-sysadmin-and-control-server-permission

     

• Looking for Buried Treasure in the Transaction Log

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

     

• LAST WEEKS TOP "READING" LINKS #34

  http://www.jasonstrate.com/2013/05/last-weeks-top-reading-links-34

     

• Deadlock Detector: Drop it like it's hot!

  http://devjef.wordpress.com/2013/04/23/deadlock-detector-drop-it-like-its-hot/

   

• Updating the TCP Port on a SQL Server Cluster Node

  http://www.mssqltips.com/sqlservertip/2928/updating-the-tcp-port-on-a-sql-server-cluster-node/

     

• SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods

  http://blog.sqlauthority.com/2013/05/27/sql-server-how-to-insert-data-from-stored-procedure-to-table-2-different-methods/

     

• SQL Server monitor

  http://mssqlwiki.com/2013/05/11/sql-server-monitor/

     

• Do You Enable "Optimize for Ad Hoc Workloads"?

  http://www.bradmcgehee.com/2011/04/do-you-enable-optimize-for-ad-hoc-workloads

   

추천 사이트

   

• 파워쉘 스크립트들이 많네요^^

  http://powershell.com/cs/media/p/20804.aspx

  http://powershell.com/cs/media/p/20796.aspx

     

• mssql 잘 정리된 사이트입니다. 강추

  http://mssqlwiki.com/

  http://sqlserverscribbles.com/        

     

• The SQL Server MVP Daily라는 곳도 있네요.                

  http://paper.li/StrateSQL/sql-mvp#

     

Other

   

• 마세라티 문제

  http://blog.kivol.net/post/51143318331        

     

• [빅데이터]파이썬, 빅 데이터 시대의 비밀병기

  http://www.itworld.co.kr/news/78477

  분석용 script 언어는 역시, 파이썬... 너무 어려븜 흑흑.. 골 때림 ㅠㅠ

     

• Singleton, Lazy loading 그리고 WeakSingleton

  http://mimul.com/pebble/default/2013/05/27/1369640835148.html