2014.04.09

   

SQL

   

• SQL Server Diagnostic Information Queries for April 2014

  http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-april-2014

   

• Locking in Microsoft SQL Server (Part 19) ? Concurrency model in in-memory OLTP (Hekaton)

  http://aboutsqlserver.com/2014/04/08/concurrency-model-in-hekaton/

     

• The SQL 2014 Cardinality Estimator Eats Bad TSQL for Breakfast

  http://www.brentozar.com/archive/2014/04/sql-2014-cardinality-estimator-eats-bad-tsql-breakfast/

     

• Divide and Conquer - Performance Tuning

  http://www.sqlservercentral.com/articles/T-SQL/107611/

     

• Improving Query Performance by using correct Search Arguments

  http://www.sqlpassion.at/archive/2014/04/08/improving-query-performance-by-using-correct-search-arguments

     

• Finding Timeout-Prone Code with max_elapsed_time

  http://www.sqlskills.com/blogs/joe/finding-timeout-prone-code-max_elapsed_time

     

• Does your 3:rd party backup software ruin your SQL Server backup plan?

  http://sqlblog.com/blogs/tibor_karaszi/archive/2014/04/09/does-your-3-rd-party-backup-software-ruin-your-sql-server-backup-plan.aspx

     

• SQL Server 2014 brings on-premises and cloud database together to improve data availability and disaster recovery

  http://www.sqlserver.co.uk/index.php/sql-server-2014-brings-on-premises-and-cloud-database-together-to-improve-data-availability-and-disaster-recovery/

     

• Curation and Performance

  http://www.scarydba.com/2014/04/08/curation-performance/

     

• Why So Serious? ? #TSQL2sDAY #53

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/08/why-so-serious-tsql2sday-53.aspx

     

• [SQL Snacks Video] SQL Server Table Partitioning 101

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/08/sql-snacks-video-sql-server-table-partitioning-101.aspx

   

• Antivirus Exclusion Policy for SQL Server

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/08/antivirus-exclusion-policy-for-sql-server.aspx

     

• DAX: Date Calculation Tables

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/08/dax-date-calculation-tables.aspx

     

• SSIS Performance Testing

  http://blogs.lessthandot.com/index.php/datamgmt/ssis/ssis-performance-testing/

     

• When the Cloud is Definitely Right for You

  http://joedantoni.wordpress.com/2014/04/08/when-the-cloud-is-definitely-right-for-you/

     

• A SQL Cmdlet a Day 3 Variables

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/07/a-sql-cmdlet-a-day-3-variables.aspx

     

Other

   

• OpenSSL heartbleed CVE-2014-0160 ? Data leaks make my heart bleed

  http://www.mysqlperformanceblog.com/2014/04/08/openssl-heartbleed-cve-2014-0160/