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

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/

SQL

• New Performance Tuning using Wait Statistics Whitepaper

  http://www.sqlskills.com/blogs/jonathan/new-performance-tuning-using-wait-statistics-whitepaper

• Updated "How to Think Like SQL Server" Videos        

  http://www.brentozar.com/archive/2014/04/updated-think-like-sql-server-videos/

     

• Selecting a Processor for SQL Server 2014 ? Part 2

  http://www.sqlperformance.com/2014/03/system-configuration/selecting-a-processor-for-sql-server-2014-2

     

• Enabling Data Compression ? April 2014 Update

  http://shaunjstuart.com/archive/2014/04/enabling-data-compression-april-2014-update/

     

• Where Should You Use a Columnstore Index (with script)?

  http://joedantoni.wordpress.com/2014/04/07/where-should-you-use-a-columnstore-index-with-script/

     

• Maximum IOPS for a 10K or 15K SAS Hard Disk Drive is not 170!

  http://dataidol.com/tonyrogerson/2014/04/07/maximum-iops-for-a-10k-or-15k-sas-hard-disk-drive-is-not-170/

     

• Let's Make Your Life a Little Easier: Strategies for Generating and Optimizing SQL Server

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/07/let-s-make-your-life-a-little-easier-strategies-for-generating-and-optimizing-sql-server.aspx

     

• Improving Performance for Some LIKE "%string%" Searches (SQL Spackle)

  http://www.sqlservercentral.com/articles/SQL+LIKE+SEARCH/108015/

     

• A SQL Cmdlet a Day 2 Piping and Select

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/03/a-sql-cmdlet-a-day-2-piping-and-select.aspx

     

• Free Video On Subselects In MDX

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/07/free-video-on-subselects-in-mdx.aspx

     

• SSIS XML Task

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/07/ssis-xml-task.aspx

     

LINKS

• Last Weeks Top "Reading" Links #78

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/07/last-weeks-top-reading-links-78.aspx