2014.05.15

   

SQL

   

• Data Modifications under Read Committed Snapshot Isolation - Paul White

  http://sqlperformance.com/2014/05/t-sql-queries/data-modifications-under-rcsi

     

• Exotic spinlocks: X_PACKET_LIST and XID_ARRAY

  http://blogs.msdn.com/b/arvindsh/archive/2014/05/14/exotic-spinlocks-x-packet-list-and-xid-array.aspx

     

• SQL Server 2014 is Customer Tested!

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/05/14/sql-server-2014-is-customer-tested.aspx

     

• Implement a SQL Server HA failover solution without shared storage

  http://www.mssqltips.com/sqlservertip/3241/implement-a-sql-server-ha-failover-solution-without-shared-storage/

     

• The Performance of Traversing a SQL Hierarchy

  https://www.simple-talk.com/sql/performance/the-performance-of-traversing-a-sql-hierarchy-/

     

• Bulk Changed Map (BCM): The Minimally Logged Advantage

  http://sqlity.net/en/2399/bcm/

     

• Did you know documentation is built-in to usp_ssiscatalog?

  http://sqlblog.com/blogs/jamie_thomson/archive/2014/05/14/did-you-know-documentation-is-built-in-to-usp-ssiscatalog.aspx

     

Other

   

• The 3 Factors That Will Get You a Job You'll Love

  http://www.dbnewsfeed.com/2014/05/13/the-3-factors-that-will-get-you-a-job-youll-love/

   

• Technical Interviews ? How to Thrive

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/13/technical-interviews-how-to-thrive.aspx

     

• max_allowed_packet and binary log corruption in MySQL

  http://www.mysqlperformanceblog.com/2014/05/14/max_allowed_packet-and-binary-log-corruption-in-mysql/