2013.03.26

   

Update

   

KB Article For CU10 of SQL Server 2008 SP3

CU#10 KB Article: http://support.microsoft.com/kb/2814783

   

SQL

   

• What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores/

   

• DBCC CHECKDB performance and computed-column indexes - Paul S. Randal

  http://www.sqlskills.com/blogs/paul/dbcc-checkdb-performance-and-computed-column-indexes/

     

• Recommended reading from mrdenny for March 22, 2013

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

     

• Solving Complex T-SQL Problems, Step-By-Step

  https://www.simple-talk.com/sql/t-sql-programming/solving-complex-t-sql-problems,-step-by-step/

     

• An Orders of Magnitude Problem (T-SQL Tuning)

  http://www.sqlservercentral.com/articles/Performance+Tuning/97355/

     

• Azure SQL Database Maintenance

  https://www.simple-talk.com/cloud/cloud-data/azure-sql-database-maintenance/

     

• Using SQL Server Management Objects with PowerShell

  http://www.sqlmag.com/article/windows-powershell/sql-server-managment-objects-powershell-144832

     

• Error 18456 - State 5 - SQL Login Failed

  http://www.sqlserver-dba.com/2013/03/error-18456-state-5-.html

     

• LAST WEEKS TOP "READING" LINKS #25

  http://www.jasonstrate.com/2013/03/last-weeks-top-reading-links-25

     

• Impact of the query_post_execution_showplan Extended Event in SQL Server 2012

  http://www.sqlperformance.com/2013/03/sql-plan/showplan-impact

  XEVENT로 성능에 대한 플랜을 뽑을 때에는 조심해야겟어욤.

     

• SQL Server 2008R2 / 2012 Standard & Backup Compression

  http://sqlblog.com/blogs/davide_mauri/archive/2013/03/25/sql-server-2008r2-2012-standard-backup-compression.aspx

  SQL2012도 압축 백업 지원되네요^^ BOL 문서 Bug가 있었네.ㅋㅋ

   

• Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks

  http://www.sqlservercentral.com/articles/Stairway+Series/97805/

     

• Storage Performance - Joe Chang

  http://sqlblog.com/blogs/joe_chang/archive/2013/03/25/storage-performance.aspx

  DB 스토리지에 대해 정말 잘 정리해 두두셨네요. 와우~~ DBA라면 잘 봐두심이 좋을 듯... 오늘은 이거나 파볼까..ㅠㅠㅠ

     

• Improving SQL Server Analysis Services Query Response Time with msmdsrv

  http://www.mssqltips.com/sqlservertip/2886/improving-sql-server-analysis-services-query-response-time-with-msmdsrv/

     

• Day 31 of 31 Days of Disaster Recovery: Backup and Restore of the Resource Database

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

  시리즈가 마무리 되었네요. 장애 복구 관련 정리 잘 되어 있어요.

     

• Diagnosing differences between production and development

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/03/24/diagnosing-differences-between-production-and-development.aspx

     

기타

   

• 안전한 패스워드 저장

  http://helloworld.naver.com/helloworld/textyle/318732        

     

• Data Science Laboratory System - Instrumentation

  https://www.simple-talk.com/cloud/data-science/data-science-laboratory-system---instrumentation

  슬슬 공부나 해볼까~~

     

• 자바 개발자 컨퍼런스에 참가한 신입매니저들의 후기! 들어보세요~

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