2013.06.21

하이여~ 오늘은 좋은 자료들이 많이 없네요^^

황금주말 잘 보내세요

   

SQL

   

• The Accidental DBA (Day 20 of 30): Are your indexing strategies working? (aka Indexing DMVs) - Kimberly L. Tripp

  http://www.sqlskills.com/blogs/kimberly/the-accidental-dba-day-20-of-30-are-your-indexing-strategies-working-aka-indexing-dmvs

     

• SQL Server Resource Governor Monitoring reports

  http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/06/20/sql-server-resource-governor-monitoring-reports.aspx

  좋은거 내놓았네요^^ 이걸로 리소스 거버너 모니터링하면 되겠어여..

     

• Avoid HA/DR Solution Self-Delusion

  http://www.sqlperformance.com/2013/06/system-configuration/hadr-delusions

     

• Mirror Mirror, On the Server – Part 2 [Video]

  http://www.brentozar.com/archive/2013/06/mirror-mirror-on-the-server-part-2-video/

     

• Email Formatted HTML Table with T-SQL

  http://www.sqlservercentral.com/articles/T-SQL/99398/

     

• Avoiding Parameter Sniffing in SQL Server

  http://www.sql-server-performance.com/2013/avoiding-parameter-sniffing-in-sql-server/

     

• String Replace in text file with Powershell

  http://www.sqlserver-dba.com/2013/06/string-replace-in-text-file-with-powershell.html