2013.01.24

   

SQL

   

• Merge Operation in Memory-Optimized Tables

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/01/22/merge-operation-in-memory-optimized-tables.aspx

   

• Did Microsoft Stop Releasing SQL Server Service Packs?

  http://www.brentozar.com/archive/2014/01/did-microsoft-stop-releasing-sql-server-service-packs/

   

• What's new in SQL Server 2014? Is it worth the upgrade?

  http://www.mssqltips.com/sqlservertip/3120/whats-new-in-sql-server-2014-is-it-worth-the-upgrade/

     

• Transaction Log buffers; How is write latency hurting SQL Server? Draft

  http://sql-sasquatch.blogspot.kr/2014/01/transaction-log-buffers-how-is-write.html

     

• For the last time, NO, you can't trust IDENT_CURRENT()

  http://www.sqlperformance.com/2014/01/t-sql-queries/ident-current

     

• SQL Server Agent in Express Edition

  http://spaghettidba.com/2014/01/23/sql-server-agent-in-express-edition/

     

• Statistics Starters Presentation: Scripts, the Database, and Some Answers

  http://www.sqlskills.com/blogs/erin/statistics-starters-presentation-scripts-the-database-and-some-answers/

     

• State Transition of Checkpoint Files in Databases with Memory-Optimized Tables

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/01/23/state-transition-of-checkpoint-files-in-databases-with-memory-optimized-tables.aspx

   

• Script to Collect Database Information Quickly

  http://www.pythian.com/blog/script-to-collect-database-information-quickly/

     

• Generating Concurrent Activity

  http://michaeljswart.com/2014/01/generating-concurrent-activity/

   

• SQL SERVER ? Tools for Proactive DBAs ? Policy Based Management ? Notes from the Field #012

  http://www.sqlserver.co.uk/index.php/sql-server-tools-for-proactive-dbas-policy-based-management-notes-from-the-field-012/

     

• Search multiple SQL Server Error Logs at the same time

  http://www.mssqltips.com/sqlservertip/3135/search-multiple-sql-server-error-logs-at-the-same-time/

     

• 6 Desktop BI Tools

  http://beyondrelational.com/modules/2/blogs/925/posts/19817/6-desktop-bi-tools.aspx

     

• "Could not add cluster access…" during SQL 2012 Failover Cluster Instance setup

  http://blogs.msdn.com/b/arvindsh/archive/2014/01/23/could-not-add-cluster-access-error-when-installing-sql-2012-failover-cluster-instance.aspx

     

     

Other

   

• Introducing Windows Azure WebJobs

  http://www.hanselman.com/blog/IntroducingWindowsAzureWebJobs.aspx

     

• 10 MySQL Settings to Tune After Installation

  http://java.dzone.com/articles/10-mysql-settings-tune-after

     

• Percona Server: Improve Scalability with Percona Thread Pool

  http://www.mysqlperformanceblog.com/2014/01/23/percona-server-improve-scalability-percona-thread-pool/