2014.02.21

   

UPDATE

   

• February 2014 Cumulative Update for SQL Server 2008 R2 SP2

  http://sqlblog.com/blogs/aaron_bertrand/archive/2014/02/19/february-2014-cumulative-update-for-sql-server-2008-r2-sp2.aspx

   

• KB Article: KB #2926028
• 12 fixes listed at time of publication
• Build number is 10.50.4302
• Relevant for @@VERSION 10.50.4000 through 10.50.4301        

   

SQL

   

• Knee-Jerk Wait Statistics : SOS_SCHEDULER_YIELD

  http://www.sqlperformance.com/2014/02/sql-performance/knee-jerk-waits-sos-scheduler-yield

   

• Hardware Update 2014 and Server Sizing - Joe Chang

  http://sqlblog.com/blogs/joe_chang/archive/2014/02/18/hardware-update-2014-and-server-sizing.aspx

     

• MSA accounts used with SQL

  http://blogs.msdn.com/b/sqlosteam/archive/2014/02/19/msa-accounts-used-with-sql.aspx

   

• Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization

  https://www.simple-talk.com/sql/performance/fixing-cache-bloat-problems-with-guide-plans-and-forced-parameterization/

   

• Understanding Graphical Execution Plans - Part 2: How to Create One

  http://www.sqlservercentral.com/articles/Execution+Plan/105772/

     

• Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/19/using-sys-dm-os-ring-buffers-to-troubleshoot-connectivity-issues.aspx

     

• Configuring the Maximum Degree of Parallelism

  http://www.sql-server-performance.com/2014/maximum-degree-parallelism/

     

• Getting a query plan

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/19/getting-a-query-plan.aspx

     

• The Evolution of SQL Server Instrumentation

  http://www.brentozar.com/archive/2014/02/evolution-sql-server-instrumentation/

     

• The Strange Story About the MERGE that Killed the Cluster

  http://www.dbnewsfeed.com/2014/02/20/the-strange-story-about-the-merge-that-killed-the-cluster

     

• Snap All the Things!

  http://sqlblog.com/blogs/merrill_aldrich/archive/2014/02/20/snap-all-the-things.aspx

     

• Send me your wait stats and get my advice and 30 days of free Pluralsight in return

  http://www.sqlskills.com/blogs/paul/send-wait-stats-get-advice-30-days-free-pluralsight-return

     

• PowerShellGUI Tools ? Disk,Memory and Process ? Modules

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/20/powershellgui-tools-disk-memory-and-process-modules.aspx

     

Other

   

• Virtual Lab ? Creating Differencing Disks

  http://voiceofthedba.wordpress.com/2014/02/20/virtual-lab-creating-differencing-disks/        

     

• If You Can Do Just One Lab to Learn Windows Azure, This is It

  http://java.dzone.com/articles/if-you-can-do-just-one-lab

     

• Windows Azure 무료 평가판 등록 이슈

  http://redju.tistory.com/390