2014.04.10

   

SQL

   

• Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)

  http://sqlblog.com/blogs/kevin_kline/archive/2014/04/09/top-10-dba-mistakes-on-sql-server-now-with-prizes-for-participation.aspx

     

• Five Reasons a Production DBA Should Learn to Read Execution Plans

  http://www.brentozar.com/archive/2014/04/five-reasons-production-dba-learn-read-execution-plans/

     

• Recommended Intel Processors For SQL Server 2014 OLTP Workloads

  http://www.sqlskills.com/blogs/glenn/recommended-intel-processors-for-sql-server-2014-oltp-workloads

     

• SQL Server 2014: TEMPDB Hidden Performance Gem

  http://blogs.msdn.com/b/psssql/archive/2014/04/09/sql-server-2014-tempdb-hidden-performance-gem.aspx

     

• srarw - sequential read after random write (ZFS, WAFL, reFS)

  http://sql-sasquatch.blogspot.kr/2014/04/srarw-sequential-read-after-random.html

   

• Dedicated Administrator Connection

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/09/dedicated-administrator-connection.aspx

     

• A SQL Cmdlet a Day 4 SQLPS

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/08/a-sql-cmdlet-a-day-4-sqlps.aspx

     

• Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function

  http://www.sqlservercentral.com/articles/Stairway+Series/108723/

     

• How come I can create SQL Server objects but not access these objects

  http://www.mssqltips.com/sqlservertip/3201/how-come-i-can-create-sql-server-objects-but-not-access-these-objects/

     

     

Other

   

• Heartbleed: Separating FAQ From FUD

  http://www.mysqlperformanceblog.com/2014/04/09/heartbleed-separating-faq-from-fud/

     

• Heartbeat

  http://freesearch.pe.kr/archives/4047