2014.04.29

   

SQL

   

• Delayed Durability in SQL Server 2014

  http://www.sqlperformance.com/2014/04/io-subsystem/delayed-durability-in-sql-server-2014

     

• The default autogrowth settings do NOT come from the Model database.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/28/the-default-autogrowth-settings-do-not-come-from-the-model-database.aspx

     

• PowerShell-Input-Validation Scripts

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/28/powershell-input-validation-scripts.aspx

     

• The Performance of Traversing a SQL Hierarchy

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

     

• Last week in Azure SQL Database ? Part 1

  http://www.sqlskills.com/blogs/bobb/last-week-azure-sql-database-part-1/

     

LINKS

   

• Log Buffer #368, A Carnival of the Vanities for DBAs

  http://www.pythian.com/blog/log-buffer-368-a-carnival-of-the-vanities-for-dbas/

     

Other

   

• OOM relation to vm.swappiness=0 in new kernel

  http://www.mysqlperformanceblog.com/2014/04/28/oom-relation-vm-swappiness0-new-kernel/

     

• Installing and Running HDP 2.1 on Windows

  http://www.sqlskills.com/blogs/bobb/installing-running-hdp-2-1-windows/

     

• ICYMI: Data platform momentum

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/04/28/icymi-data-platform-momentum.aspx