2013.06.03

Update

   

• SQL Server 2012 Service Pack 1 Cumulative Update #4 is available!

  http://sqlblog.com/blogs/aaron_bertrand/archive/2013/06/01/sql-server-2012-service-pack-1-cumulative-update-4-is-available.aspx

   

• KB article: KB #2833645
• Build # is 11.0.3368
• This build has 39 fixes by my count.

   

SQL

   

• The Accidental DBA (Day 1 of 30): Hardware Selection: CPU and Memory Considerations

  http://www.sqlskills.com/blogs/glenn/the-accidental-dba-day-1-of-30-hardware-selection-cpu-and-memory-considerations/
  http://www.sqlskills.com/blogs/glenn/the-accidental-dba-day-2-of-30-hardware-selection-disk-configurations-and-raid-performance-not-capacity/

  Gleen님이 시리즈 시작하셨네요^^ 야호~~

     

• Database Health Reports Beta 6 – Coming Soon

  http://databasehealth.stevestedman.com/download/release-notes/

  Beta 중이라니~ 한번 다운로드 해봐야겠네요^^

     

• SQL Server Agent Does Not Start After Uninstalling/Reinstalling SQL Server 2012

  http://www.sqlskills.com/blogs/glenn/sql-server-agent-does-not-start-after-uninstallingreinstalling-sql-server-2012/

     

• What does MemoryUtilization in sys.dm_os_ring_buffers and Memory_utilization_percentage in sys.dm_os_process_memory represents?

  http://mssqlwiki.com/2013/06/02/what-does-memoryutilization-in-sys-dm_os_ring_buffers-and-memory_utilization_percentage-in-sys-dm_os_process_memory-represents/

     

• The Accidental DBA (Day 2 of 30): Hardware Selection: Disk Configurations and RAID -> Performance not Capacity

  http://www.sqlskills.com/blogs/glenn/the-accidental-dba-day-2-of-30-hardware-selection-disk-configurations-and-raid-performance-not-capacity/

     

• Clustered Index do "NOT" guarantee Physically Ordering or Sorting of Rows

  http://sqlwithmanoj.wordpress.com/2013/06/02/clustered-index-do-not-guarantee-physically-ordering-or-sorting-of-rows/

     

• Writing Your First Common Table Expression with SQL Server

  http://stevestedman.com/2013/06/writing-your-first-common-table-expression-with-sql-server/

     

• T-SQL Tuesday #43 – Hello, Operator?

  http://sqlblog.com/blogs/rob_farley/archive/2013/06/02/t-sql-tuesday-43-hello-operator.aspx

   

• Sample Database for Common Table Expressions

  http://stevestedman.com/2013/06/sample-database-for-common-table-expressions/

     

• Performance Guidance for SQL Server in Windows Azure Virtual Machines

  http://sqlcat.com/sqlcat/b/whitepapers/archive/2013/05/31/performance-guidance-for-sql-server-in-windows-azure-virtual-machines.aspx

  윈도우 애져의 SQL SERVER 성능 가이드 doc로 정리된 문서를 다운로드 하실 수 있습니다.

   

• Enhancements to SQL Server Backup to Cloud in SQL Server 2012 SP1 CU4

  http://sqlblog.com/blogs/sqlos_team/archive/2013/05/31/blog-post-enhancements-to-sql-server-backup-to-cloud-in-sql-server-2012-sp1-cu4.aspx

     

• Logical Query Processing

  http://sqlblog.com/blogs/tamarick_hill/archive/2013/05/31/logical-query-processing.aspx

     

• SQL Server 2012 System views poster available for download

  http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/sql-server-2012-system-views

     

• Windows Pagefile size for dedicated SQL Servers

  http://www.sqlserver-dba.com/2013/05/windows-pagefile-size-for-dedicated-sql-servers.html

     

• The Myth that DROP and TRUNCATE TABLE are Non-Logged

  http://www.sqlperformance.com/2013/05/sql-performance/drop-truncate-log-myth

     

Other

   

• HBase Architecture

  http://architects.dzone.com/articles/hbase-architecture

  50분짜리 발표 자료입니다^^... 단 영어라는 거~~ ㅜㅜ

     

• Using Amazon Login with Windows Azure Access Control

  http://cloud.dzone.com/articles/using-amazon-login-windows

     

• The small improvements of MySQL 5.6: Duplicate Index Detection

  http://www.mysqlperformanceblog.com/2013/05/31/the-small-improvements-of-mysql-5-6-duplicate-index-detection/

     

• MySQL Data Compare: The Manual that Time Forgot

  https://www.simple-talk.com/sql/sql-tools/mysql-data-compare-the-manual-that-time-forgot/

     

• 클라우드 네트워크 관리 기술, OpenFlow

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