2014.03.11

   

SQL

   

• How to read and interpret the SQL Server log

  http://rusanu.com/2014/03/10/how-to-read-and-interpret-the-sql-server-log/

     

• Handle conversion between time zones in SQL Server - part 2

  http://www.mssqltips.com/sqlservertip/3174/handle-conversion-between-time-zones-in-sql-server--part-2/

   

• Applying The Scientific Method to SQL Server Performance Tuning

  https://www.simple-talk.com/sql/performance/applying-the-scientific-method-to-sql-server-performance-tuning/

     

• Why I Developed SQL Code Guard: A Fairy Tale from a DBA

  http://sqlcodeguard.blogspot.co.uk/2014/02/why-i-developed-sql-code-guard-fairy.html

     

• AlwaysOn Availability Groups - What Not to do when Adding Databases

  https://www.simple-talk.com/sql/database-administration/alwayson-availability-groups---what-not-to-do-when-adding-databases/

     

• How Agile esProc Syntax Facilitates Hadoop Coding

  http://beyondrelational.com/modules/2/blogs/925/posts/19847/how-agile-esproc-syntax-facilitates-hadoop-coding.aspx

     

• #0325 - SQL Server - fn_trace_gettable - Get database name change history from default trace

  http://beyondrelational.com/modules/2/blogs/77/Posts/19844/0325-sql-server-fntracegettable-get-database-name-change-history-from-default-trace.aspx

     

LINKS

   

• LAST WEEKS TOP "READING" LINKS #74

  http://www.jasonstrate.com/2014/03/last-weeks-top-reading-links-74/

     

Other

   

• New mydumper 0.6.1 release offers performance and usability features

  http://www.mysqlperformanceblog.com/2014/03/10/new-mydumper-0-6-1-release-offers-several-performance-and-usability-features/

     

• NoSQL Job Trends: February 2014

  http://java.dzone.com/articles/nosql-job-trends-february-2014