2013.03.25

   

SQL

   

• CPUID PerfMonitor 2 Utility - Grenn

  http://www.sqlskills.com/blogs/glenn/cpuid-perfmonitor-2-utility/

   

• How to Reclaim Disk Space in your Windows\winsxs directory on Windows Server 2008 R2 SP1 - Grenn

  http://www.sqlskills.com/blogs/glenn/how-to-reclaim-disk-space-in-your-windowswinsxs-directory-on-windows-server-2008-r2-sp1/

     

• Slide 1 - T-SQL Rediscovered with SQL Server 2012

  http://beyondrelational.com/modules/29/presentations/483/slides/19200/slide-1-t-sql-rediscovered-with-sql-server-2012.aspx

   

• Recommended reading from mrdenny for March 22, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-march-22-2013/

     

• Using FileTable in SQL Server 2012

  http://beyondrelational.com/modules/24/syndicated/391/Posts/19198/using-filetable-in-sql-server-2012.aspx

     

• SSIS 2012 Deep Dive presentation

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/03/22/ssis-2012-deep-dive-presentation.aspx

     

• Moving system databases to the default data and log paths

  http://spaghettidba.com/2013/03/22/move-system-databases-to-the-default-data-and-log-paths/

     

• Sp_updatestats RESAMPLE option

  http://www.sqlserver-dba.com/2013/03/sp_updatestats-resample-option.html

     

• SQL Server : Part 6 : Design consideration of Clustered Index

  http://beyondrelational.com/modules/24/syndicated/535/Posts/19194/sql-server-part-6-design-consideration-of-clustered-index.aspx

     

• An Introduction to SQL Server IO for Developers (video)

  http://www.brentozar.com/archive/2013/03/an-introduction-to-sql-server-io-for-developers-video/

     

• SQL Server Case Sensitive Collations and DMVs

  http://www.mssqltips.com/sqlservertip/2913/sql-server-case-sensitive-collations-and-dmvs/

     

• SQL SERVER – Fix – Error: 1060 The number of rows provided for a TOP or FETCH clauses row count parameter must be an integer

  http://blog.sqlauthority.com/2013/03/22/sql-server-fix-error-1060-the-number-of-rows-provided-for-a-top-or-fetch-clauses-row-count-parameter-must-be-an-integer/

     

• Corruption case

  http://sqlblog.com/blogs/michael_zilberstein/archive/2013/03/22/48339.aspx

  재미있는 case이네요 "A time-out occurred while waiting for buffer latch" 시작 옵션 661으로 서비스 올려서 체크하면 되네요^^

  Express Edition doesn't support DAC에서는 사용할 수 없군요?

     

     

기타

   

• Amazon 클라우드에서 S3 Read/Write 성능 높이는 방법 - 같은 Region 사용하기

  http://bcho.tistory.com/731        

     

• [입 개발] Redis Tips

  http://charsyam.wordpress.com/2013/03/22/%EC%9E%85-%EA%B0%9C%EB%B0%9C-redis-tips/

  레디스를 쓰기 위해서는 공부를 좀 더해야겟네요.^^

     

• System Center Advisor is now free

  http://blogs.msdn.com/b/psssql/archive/2013/03/20/system-center-advisor-is-now-free.aspx