2013.02.14 (1)

안녕하세요. 주디아줌마입니다.

설 연휴동안에 너무 쉬었더니~ 아직도 엄청 남았네요^^ 부랴부랴 올려야겠어요.

   

SQL

   

• Buffer pool disfavoring - 폴

  http://www.sqlskills.com/blogs/paul/buffer-pool-disfavoring/

     

• Breaking Down 18065 - CSS SQL SERVER Engineers

  http://blogs.msdn.com/b/psssql/archive/2013/02/13/breaking-down-18065.aspx

     

• Graphically Viewing Extended Events Deadlock Graphs - Jonathan Kehayias

  http://www.sqlskills.com/blogs/jonathan/graphically-viewing-extended-events-deadlock-graphs/

   

• DBCC SHOW_STATISTICS Works With SELECT Permission - Benjamin Nevarez

  http://www.benjaminnevarez.com/2013/02/dbcc-show_statistics-works-with-select-permission/

   

• The Halloween Problem – Part 1 - Paul White

  http://www.sqlperformance.com/2013/02/t-sql-queries/halloween-problem-part-1

     

• DBA Best Practices - A Blog Series: Episode 3 - Use a Wiki for Documentation

  http://sqlblog.com/blogs/argenis_fernandez/archive/2013/02/13/dba-best-practices-a-blog-series-episode-3-use-a-wiki-for-documentation.aspx

  제가 요즘 고민하는 것들이 올라오네요? 문서를 위한 위키~~ 저도 이거 고민중에요^^

     

• Day 25 of 31 Days of Disaster Recovery: Improving Performance of Backups and Restores

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

  backup시 buffer 관련도 야그가 나왔네요.

     

• How to get list of all available parameter of .EXE file ?

  http://mssqlfun.com/2013/02/13/how-to-get-list-of-all-available-parameter-of-exe-file/

     

• Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above

  http://mssqlfun.com/2013/02/11/refresh-intellisense-in-ssmssql-server-management-studio-2008-above/

  인테릴젼스 리플래쉬 기능 이런 기능도 있군요??

     

• Move or Relocate the files of Resoruce Database in SQL Server 2005

  http://mssqlfun.com/2013/02/07/move-or-relocate-the-files-of-resoruce-database-in-sql-server-2005/

  master, resource db는 같은 경로에 있어야 한다는군요.

     

• How to find/modify SQLServer Agent logfile location?

  http://mssqlfun.com/2013/01/31/how-to-findmodify-sqlserver-agent-logfile-location/

     

• SQL Server Silent unattended installation using configuration file

  http://mssqlfun.com/2013/01/29/sql-server-silent-unattended-installation-using-configuration-file/

  예전, 주언형님 책에 나와있던 내용이네요^^ 설치 간편하게 하는 방법.. 200백대~300백대는 그냥 껌이죵~~

     

• Extracting DACPACs from all databases with Powershell        

  http://spaghettidba.com/2013/02/13/extracting-dacpacs-from-all-databases-with-powershell/

   

• Cannot execute as the database principal

  http://www.sqlserver-dba.com/2013/02/cannot-execute-as-the-database-principal.html

     

     

ETC

   

• SQL and NoSQL Symbiosis

  http://architects.dzone.com/articles/sql-and-nosql-symbiosis

   

• Using R — .Call("hello")

  http://architects.dzone.com/articles/using-r-%E2%80%94-call%E2%80%9Chello%E2%80%9D

  우리도 R 공부해 보아요..