2013.06.19

금일은 업데이트 내용이 많네요^^

장마 시작이라~ 날씨가 후덥지근해서 달달한 커피가 땡기는 날씨네요@.@

   

UPDATE

   

• SQL Server 2012 RTM Cumulative Update 8

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/06/17/sql-server-2012-rtm-cumulative-update-8.aspx

   

• CU#8 KB Article: http://support.microsoft.com/kb/2844205
• Understanding IncrementalServicingModel for SQL Server
• SQL Server Support Information: http://support.microsoft.com/ph/2855

     

• SQL Server 2008 R2 SP1 Cumulative Update #13

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/06/17/sql-server-2008-r2-sp1-cumulative-update-13.aspx

     

  • CU#13 KB Article: http://support.microsoft.com/kb/2855792
  • Understanding IncrementalServicingModel for
  • SQL Server
  • SQL Server Support Information: http://support.microsoft.com/ph/2855

   

• SQL Server 2008 R2 SP2 Cumulative update #7        

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/06/17/sql-server-2008-r2-sp2-cumulative-update-7.aspx        

     

  • CU#7 KB Article: http://support.microsoft.com/kb/2844090
  • Understanding IncrementalServicingModel for SQL Server
  • SQL Server Support
  • Information: http://support.microsoft.com/ph/2855

       

SQL

   

• The Accidental DBA (Day 18 of 30): Baselines

  http://www.sqlskills.com/blogs/erin/the-accidental-dba-baselines

   

• High CPU Troubleshooting with DMV Queries

  http://blogs.msdn.com/b/psssql/archive/2013/06/17/high-cpu-troubleshooting-with-dmv-queries.aspx

  동영상이 나오는데 7분대에서 끊기네요 ㅡ.ㅡ

     

• Forgotten sa password

  http://www.sqlserver-dba.com/2013/06/forgotten-sa-password.html

     

• Usage of CTE - Trick with Dates        

  http://www.sqlservercentral.com/articles/Cursor+vs+Recursive+CTE/99795/

   

• Understanding SQL Server Query Optimization Statistics

  http://www.sql-server-performance.com/2013/understanding-sql-server-query-optimization-statistics

     

• Managing Slowly Changing Dimension with MERGE Statement in SQL Server        

  http://www.databasejournal.com/features/mssql/managing-slowly-changing-dimension-with-merge-statement-in-sql-server.html

   

• Demonstrations of Transaction Isolation Levels in SQL Server

  http://www.mssqltips.com/sqlservertip/2977/demonstrations-of-transaction-isolation-levels-in-sql-server/

     

• Performance Guidance for SQL Server in Windows Azure Virtual Machines        

  http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/Performance%20Guidance%20for%20SQL%20Server%20in%20Windows%20Azure%20Virtual%20Machines.docx

  PDF 자료입니다..

     

Other

   

• Redis: Very Useful As a Distributed Lock

  http://architects.dzone.com/articles/redis-very-useful-distributed

     

• Gaming with NoSQL

  http://architects.dzone.com/articles/gaming-nosql

  게임업계에서도 요즘 화두가 되는 NoSQL.~~

  동영상 자료구요~ 앵그리버드 게임 만든 회사에서 강연하는 동영상입니다.