2014.02.14

   

SQL

   

• PREEMPTIVE_OS_WRITEFILEGATHER and Instant File Initialization (IFI)

  http://www.brentozar.com/archive/2014/02/preemptive_os_writefilegather-and-instant-file-initialization-ifi/

   

• Guerrilla Project Management for DBAs

  https://www.simple-talk.com/sql/database-administration/guerrilla-project-management-for-dbas/

     

• SQL SERVER ? Expanding Your Skills ? Notes from the Field #015

  http://www.sqlserver.co.uk/index.php/sql-server-expanding-your-skills-notes-from-the-field-015/

     

• Transaction Isolation Levels

  http://www.sqlservercentral.com/articles/Transaction+Isolation+levels/106363/

     

• SQL Server configuration files

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/13/sql-server-configuration-files.aspx

     

• SQL Server Indexed Views: The Basics

  https://www.simple-talk.com/sql/learn-sql-server/sql-server-indexed-views-the-basics/

     

• Using Windows Azure to Speed up Genome Research and Save Millions of Dollars

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/02/13/using-windows-azure-to-speed-up-genome-research-and-save-millions-of-dollars.aspx

   

• Troubleshooting Concurrency ? A Demo

  http://michaeljswart.com/2014/02/troubleshooting-concurrency-a-demo/

     

• Virtual Lab ? Design and Setup

  http://voiceofthedba.wordpress.com/2014/02/06/virtual-lab-design-and-setup/

     

• Corruption recovery using DBCC WRITEPAGE

  http://www.sqlskills.com/blogs/paul/corruption-recovery-using-dbcc-writepage