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

• Types of MSSQL Joins

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/types-of-mssql-joins.aspx

     

• The Primary Filegroup Cannot be Backed Up as a File Backup

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/the-primary-filegroup-cannot-be-backed-up-as-a-file-backup.aspx

• Database Master Key Error After Database Restore

  http://www.sqlservercentral.com/articles/Database+Master+Key/107787/

     

• SQL Server Quickie #12 ? Nested Loop Operator

  http://www.sqlpassion.at/archive/2014/03/31/sql-server-quickie-12-nested-loop-operator

     

• Default nullability of a new column

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/default-nullability-of-a-new-column.aspx

     

• Refactoring T-SQL with Windowing Functions        

  http://www.brentozar.com/archive/2014/03/refactoring-t-sql-windowing-functions/

     

• SSIS Web Service Task

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/ssis-web-service-task.aspx

     

• Calculate Distinct Count in a Group By operation in Power Query #powerquery #powerbi

  http://sqlblog.com/blogs/marco_russo/archive/2014/03/31/calculate-distinct-count-in-a-group-by-operation-in-power-query-powerquery-powerbi.aspx

     

LINKS

• Last Weeks Top "Reading" Links #77

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/last-weeks-top-reading-links-77.aspx

     

Other

• Tips to check and improve your storage IO performance with MongoDB

  http://edgystuff.tumblr.com/post/81219256714/tips-to-check-and-improve-your-storage-io-performance

     

• SQL Alias PowerShell scrip

  http://blogs.technet.com/b/sqlpfeil/archive/2014/03/31/sql-alias-powershell-scrip.aspx

     

• Password expiration policy in MySQL Server 5.7

  http://mysqlblog.fivefarmers.com/2014/03/31/password-expiration-policy-in-mysql-server-5-7/

SQL

• The SQL Server 2008 Datetimeoffset Data Type

  http://www.sqlservercentral.com/articles/SQL+Server+2008/72758/

• SSIS Do I Union All or Merge??

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/26/ssis-do-i-union-all-or-merge.aspx

• T4 Support in SSDT

  http://dataidol.com/davebally/2014/03/29/t4-support-in-ssdt/

     

LINKS

• (SFTW) SQL Server Links 28/03/14

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

• Friday Followup For March 28, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/28/friday-followup-for-march-28-2014.aspx

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

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

     

Other

• Innodb redo log archiving

  http://www.mysqlperformanceblog.com/2014/03/28/innodb-redo-log-archiving/

     

• Data Science는 과학이 아니다

  http://agbird.egloos.com/5807485

SQL

• Don't Rely On a Static IP Address for Your SQL Database

  http://blogs.msdn.com/b/psssql/archive/2014/03/27/don-t-rely-on-a-static-ip-address-for-your-sql-database.aspx

     

• Configuring Service Broker for Asynchronous Processing

  http://www.sqlperformance.com/2014/03/sql-performance/configuring-service-broker

     

• Transactional Replication and the Ballooning Log File

  http://www.sqlservercentral.com/articles/Replication/107698/

     

     

Other

• MySQL 5.6.17 ? now with better encryption

  http://mysqlblog.fivefarmers.com/2014/03/27/mysql-5-6-17-now-with-better-encryption/

     

• A conversation with 5 Facebook MySQL gurus

  http://www.mysqlperformanceblog.com/2014/03/27/a-conversation-with-5-facebook-mysql-gurus/

     

• 확률적 자료구조를 이용한 추정 - 유일한 원소 개수(Cardinality) 추정과 HyperLogLog

  http://helloworld.naver.com/helloworld/textyle/711301

SQL

• How to Add Nonclustered Indexes to Clustered Columnstore Indexes

  http://www.brentozar.com/archive/2014/03/add-nonclustered-indexes-clustered-columnstore-indexes/

• SSAS Tabular: Internal Physical Files

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/25/ssas-tabular-internal-physical-files.aspx        

     

• Creating a Disaster Recovery Plan

  http://www.sqlserver-dba.com/2014/03/creating-a-disaster-recovery-plan.html

     

• The Illusion of Updateable Clustered ColumnStore Indexes

  http://www.sqlpassion.at/archive/2014/03/25/the-illusion-of-updateable-clustered-columnstore-indexes

     

• Implementing SQL Server Transaction Retry Logic for failed transactions

  http://www.mssqltips.com/sqlservertip/3188/implementing-sql-server-transaction-retry-logic-for-failed-transactions/

     

• Using EXCEPT to Determine Row Differences

  http://www.sqlservercentral.com/articles/EXCEPT/107520/

     

• Making the Case for INSTEAD OF Triggers ? Part 1

  http://www.sqlperformance.com/2014/03/t-sql-queries/instead-of-triggers-1

     

LINKS

• Last Weeks Top "Reading" Links #76

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/24/last-weeks-top-reading-links-76.aspx