2014.03.20

   

UPDATE

   

• Cumulative Update #9 for SQL Server 2012 SP1

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-9-for-sql-server-2012-sp1.aspx

     

• Cumulative Update #16 for SQL Server 2008 SP3

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-16-for-sql-server-2008-sp3.aspx

   

SQL

   

• Microsoft officially announces release of SQL Server 2014 (April 1st, 2014)

  http://www.mssqltips.com/sqlservertip/3203/microsoft-officially-announces-release-of-sql-server-2014/

  http://sqlblog.com/blogs/damian_widera/archive/2014/03/19/sql-server-2014-has-come-into-the-light-the-rtm-will-be-available-on-1st-april.aspx

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/sql-server-2014-rtm-april-1st-and-that-s-no-joke.aspx

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/sql-server-2014-rtm-release-date.aspx

     

• How to determine what causes a particular wait type

  http://www.sqlskills.com/blogs/paul/determine-causes-particular-wait-type

     

• An Introduction to Asynchronous Processing with Service Broker

  http://www.sqlperformance.com/2014/03/sql-performance/intro-to-service-broker

     

• Stop the SQL Server Finger Pointing!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/stop-the-sql-server-finger-pointing.aspx

     

• A Primer on Locks, Blocks and Deadlocks

  http://michaeljswart.com/2014/03/a-primer-on-locks-blocks-and-deadlocks/

     

• What is the most worrying cause of log growth (log_reuse_wait_desc)?

  http://www.sqlskills.com/blogs/paul/worrying-cause-log-growth-log_reuse_wait_desc

     

• Performance improvements in SQL Server 2014

  http://www.sqlpassion.at/archive/2014/03/18/performance-improvements-in-sql-server-2014

     

• Parallel Data Warehouse (PDW) benefits made simple

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/parallel-data-warehouse-pdw-benefits-made-simple.aspx

     

• Rollback: What happens when you KILL a session?

  http://www.brentozar.com/archive/2014/03/happens-issue-kill/

     

• Review Your BUCKET_COUNT Statistics with DMV

  http://www.databasejournal.com/features/mssql/review-your-bucketcount-statistics-with-dmv.html

     

• Creating a Date Range from Multiple Rows Based on a Single Date

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

     

• Finding One Problem Query With Extended Events

  http://www.brentozar.com/archive/2014/03/finding-one-problem-query-extended-events/

     

• Where is my Availability Group?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/where-is-my-availability-group.aspx

     

• Troubleshooting Error: 18452, Severity: 14, State: 1

  http://www.sqlserver-dba.com/2014/03/troubleshooting-.html

     

• Natural vs. Surrogate Keys in SQL Server : Getting the Proper Perspective

  http://www.sql-server-performance.com/2014/natural-surrogate-keys/

     

• Collation: Definition

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/19/collation-definition.aspx

     

• Remaining Vigilant, my contribution to #DBAJumpStart ? Part 1

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/remaining-vigilant-my-contribution-to-dbajumpstart-part-1.aspx

     

• Remaining Vigilant, my contribution to #DBAJumpStart ? Part 2

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/19/remaining-vigilant-my-contribution-to-dbajumpstart-part-2.aspx

     

     

Other

   

• JBoss Infinispan 온라인 웨비나 내용 노트

  http://bcho.tistory.com/883