SQL

• The Read Committed Isolation Level - Paul White

  http://www.sqlperformance.com/2014/04/t-sql-queries/the-read-committed-isolation-level

• Cardinality Estimation for Disjunctive Predicates in SQL Server 2014 - Paul White

  http://sqlblog.com/blogs/paul_white/archive/2014/04/15/cardinality-estimation-for-disjunctive-predicates-in-2014.aspx

     

• SQL Server 2014 Buffer Pool Extensions

  http://www.brentozar.com/archive/2014/04/sql-server-2014-buffer-pool-extensions/

• A ever-increasing Clustered Key value doesn't scale!

  http://www.sqlpassion.at/archive/2014/04/15/an-ever-increasing-clustered-key-value-doesnt-scale

     

• Why is Affinity Mask Negative in sp_configure?

  http://www.pythian.com/blog/why-is-affinity-mask-negative-in-sp_configure/

     

• Searching for Strings in SQL Server Databases

  https://www.simple-talk.com/sql/t-sql-programming/searching-for-strings-in-sql-server-databases-/

     

• Simple-Talk SQL Server Backup Crib Sheet

  https://www.simple-talk.com/sql/backup-and-recovery/simple-talk-sql-server-backup-crib-sheet

     

• SQL intersection slides and samples

  http://www.sqlperformance.com/2014/04/sql-performance/sql-intersection-slides-and-samples

     

• [SQL Snacks Video] SQL Server Table Partitioning 102

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

     

• FileTable?Adding a file to a folder

  http://voiceofthedba.wordpress.com/2014/04/16/filetableadding-a-file-to-a-folder/

     

• Optional Parameters Causing Index Scans

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/15/optional-parameters-causing-index-scans.aspx

     

• Parallel Data Warehouse (PDW) AU1 released

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/15/parallel-data-warehouse-pdw-au1-released.aspx

     

LINKS

• LAST WEEKS TOP "READING" LINKS #79

  http://www.jasonstrate.com/2014/04/last-weeks-top-reading-links-79/

     

Other

• 왜 개발자들은 이전 개발자를 나쁜 사람으로 모는가?

  http://www.mimul.com/pebble/default/2014/04/16/1397645377481.html

     

• percona-millipede ? Sub-second replication monitor

  http://www.mysqlperformanceblog.com/2014/04/15/percona-millipede-sub-second-replication-monitor/

SQL

• Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

  http://www.sqlskills.com/blogs/joe/optimizing-your-query-plans-with-the-sql-server-2014-cardinality-estimator

• Windows Functions; Who Knew?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/14/windows-functions-who-knew.aspx

     

• SQL SERVER ? Working with Change Data Capture ? Part 1

  http://raresql.com/2014/04/14/sql-server-working-with-change-data-capture-part-1/

     

• Monitor and Alert SQL Stack dumps

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/14/monitor-and-alert-sql-stack-dumps.aspx

     

LINKS

• Last Weeks Top "Reading" Links #79

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

SQL

• The Serializable Isolation Level - Paul White

  http://www.sqlperformance.com/2014/04/t-sql-queries/the-serializable-isolation-level

     

• Collecting Detailed Performance Measurements with Extended Events

  http://www.brentozar.com/archive/2014/04/collecting-detailed-performance-measurements-extended-events/

     

• Collation: Correction Expression, Column, Database

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/10/collation-correction-expression-column-database.aspx

     

• Rolling back transactions with cursors and local variables.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/10/rolling-back-transactions-with-cursors-and-local-variables.aspx

     

• How to create an SSIS conditional data flow task

  http://www.sqlservercentral.com/articles/SQL+Server+Integration+Services+(SSIS)/107380/

     

• Managing SQL Server Services with PowerShell

  http://www.databasejournal.com/features/mssql/managing-sql-server-services-with-powershell.html

     

• Webcast Follow-Up: Introduction to Clustered Indexes and Heaps

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/09/webcast-follow-up-introduction-to-clustered-indexes-and-heaps.aspx

     

Other

• MySQL 5.7 Released

  http://java.dzone.com/articles/mysql-57-released

     

• NewSQL Vs. SQL on Hadoop

  http://java.dzone.com/articles/newsql-vs-sql-hadoop

     

• JavaScript Promises

  http://www.mimul.com/pebble/default/2014/04/10/1397096687204.html

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

SQL

• Why Index Fragmentation and Bad Statistics Aren't Always the Problem (Video)

  http://www.brentozar.com/archive/2014/04/index-fragmentation-bad-statistics-arent-always-problem-video/

• GUID, fragmentation and performance: the eternal flame.

  http://sqlblog.com/blogs/davide_mauri/archive/2014/04/06/guid-fragmentation-and-performance-the-eternal-flame.aspx

     

• Video: SQL Server Performance Tuning with Wait Statistics (Introduction)

  http://www.connectsql.com/2014/04/video-sql-server-performance-tuning.html

     

• SQLServer transaction log writes - 64k aligned?

  http://sql-sasquatch.blogspot.kr/2014/04/sqlserver-transaction-log-writes-64k.html

     

• A SQL Cmdlet a Day 1

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

     

• Getting Started in SQL Server

  http://www.sqlservercentral.com/articles/Career/71608/

     

• High Performance Relational Division in SQL Server

  https://www.simple-talk.com/sql/learn-sql-server/high-performance-relational-division-in-sql-server/

     

• Six Videos To Help You Upgrade your Inner DBA to SQL Server 2014'ness

  http://java.dzone.com/articles/six-videos-help-you-upgrade

     

• SQL Server 2014 Licensing Changes

  http://www.brentozar.com/archive/2014/04/sql-server-2014-licensing-changes/

     

LINKS

• Log Buffer #366, A Carnival of the Vanities for DBAs

  http://www.pythian.com/blog/log-buffer-366-a-carnival-of-the-vanities-for-dbas/

     

• Friday Followup For April 4, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/04/friday-followup-for-april-4-2014.aspx

     

• (SFTW) SQL Server Links 04/04/14

  http://www.johnsansom.com/sftw-sql-server-links-040414/

     

Other

• Facebook's Yoshinori Matsunobu on MySQL, WebScaleSQL & Percona Live

  http://www.mysqlperformanceblog.com/2014/04/04/facebooks-yoshinori-matsunobu-mysql-webscalesql-percona-live/

• 빠르게 훝어 보는 node.js - #6 MongoDB 연동 (mongo-native)

  http://bcho.tistory.com/889

SQL

• Unexpected SPID change

  http://sqlblog.com/blogs/sergio_govoni/archive/2014/04/04/unexpected-spid-change.aspx

     

• I think I am getting duplicate query plan entries in SQL Server's procedure cache

  http://blogs.msdn.com/b/psssql/archive/2014/04/03/i-think-i-am-getting-duplicate-query-plan-entries-in-sql-server-s-procedure-cache.aspx

• Columnstore Indexes and Transparent Data Encryption in SQL Server 2014

  http://joedantoni.wordpress.com/2014/04/03/columnstore-indexes-and-transparent-data-encryption-in-sql-server-2014/

     

• What happens to in-flight data compression in an emergency?

  http://www.brentozar.com/archive/2014/04/happens-flight-data-compression-emergency/

     

• SQL Server 2012 AlwaysOn Groups and FCIs Part 3

  http://www.sqlservercentral.com/articles/AlwaysOn/106315/

     

Other

• THE PROBLEM WITH SQL AZURE

  http://thomaslarock.com/2014/04/problem-sql-azure

     

• MySQL 5.7 just rocks! ;-)

  http://dimitrik.free.fr/blog/archives/04-01-2014_04-30-2014.html#182

     

• Data Science Laboratory System - Distributed File Databases

  https://www.simple-talk.com/cloud/data-science/data-science-laboratory-system---distributed-file-databases

     

• 경계 구분히 모호해진 네트워크 기반 솔루션들

  http://www.techsuda.com/archives/3265

SQL

• Bushy Joins- Joe Chang

  http://sqlblog.com/blogs/joe_chang/archive/2014/04/02/bushy-joins.aspx

• Build your own server with Supermicro motherboards - Joe Chang

  http://sqlblog.com/blogs/joe_chang/archive/2014/04/02/build-your-own-server-with-supermicro-motherboards.aspx

     

• Deck from "Practical SQL Server Cardinality Estimation"

  http://www.sqlskills.com/blogs/joe/deck-from-practical-sql-server-cardinality-estimation

     

• Tracking Automatic Updates to Statistics

  http://www.sqlperformance.com/2014/04/extended-events/tracking-auto-stats

     

• Are Table Variables as Good as Temporary Tables in SQL 2014?

  http://www.brentozar.com/archive/2014/04/table-variables-good-temp-tables-sql-2014/

• 14 SQL Server Indexing Questions We Were Too Shy To Ask        

  https://www.simple-talk.com/sql/performance/14-sql-server-indexing-questions-we-were-too-shy-to-ask/

     

• How much overhead does encryption add to a SQL Server query

  http://www.mssqltips.com/sqlservertip/3196/how-much-overhead-does-encryption-add-to-a-sql-server-query/

     

• Installing SQL Server 2014 (RTM) on Windows Server 2012        

  http://miteshc.wordpress.com/2014/04/02/installing-sql2014-on-win2012r2/

     

• SQL 2012 Setup Rules ? The 'Missing Reference'

  http://blogs.msdn.com/b/arvindsh/archive/2014/04/02/sql-setup-rules-reference.aspx

     

• Setting up and using file tables

  http://sqlscope.wordpress.com/2014/04/02/setting-up-and-using-file-tables/

     

• Availability databases in unhealthy data synchronization state (Error: 35285, Severity: 16, State: 1.)

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/02/availability-databases-in-unhealthy-data-synchronization-state-error-35285-severity-16-state-1.aspx

     

Other

• DB-Engines Ranking of database management systems, April 2014

  http://db-engines.com/en/ranking

     

• Redefining ?ssl option

  http://mysqlblog.fivefarmers.com/2014/04/02/redefining-ssl-option/

SQL

• SQL Server 2014 Has Been Released

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/04/01/sql-server-2014-now-generally-available.aspx

  http://www.microsoft.com/en-us/server-cloud/products/sql-server/

     

• Nasty day-1 bug causing page checksums to miss corruptions on 2008 R2/2012/2014 

  http://www.sqlskills.com/blogs/paul/nasty-day-1-bug-causing-page-checksums-miss-corruptions-2008-r220122014

     

• SQL Server 2014's new cardinality estimator (Part 1)

  http://blogs.msdn.com/b/psssql/archive/2014/04/01/sql-server-2014-s-new-cardinality-estimator-part-1.aspx

• Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/01/microsoft-announces-that-it-will-no-longer-support-sql-server-and-that-sql-2014-was-an-april-fools-joke.aspx

• New Backup Behavior in SQL 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/01/new-backup-behavior-in-sql-2014.aspx

     

• Tuesday Tips: SQL Server Optimization

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/01/tuesday-tips-sql-server-optimization.aspx

     

• DAX: Calculating different rates on user defined inputs

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/01/dax-calculating-different-rates-on-user-defined-inputs.aspx