SQL

• Delayed Durability in SQL Server 2014

  http://www.sqlperformance.com/2014/04/io-subsystem/delayed-durability-in-sql-server-2014

     

• The default autogrowth settings do NOT come from the Model database.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/28/the-default-autogrowth-settings-do-not-come-from-the-model-database.aspx

     

• PowerShell-Input-Validation Scripts

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/28/powershell-input-validation-scripts.aspx

     

• The Performance of Traversing a SQL Hierarchy

  https://www.simple-talk.com/sql/performance/the-performance-of-traversing-a-sql-hierarchy-/

     

• Last week in Azure SQL Database ? Part 1

  http://www.sqlskills.com/blogs/bobb/last-week-azure-sql-database-part-1/

     

LINKS

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

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

     

Other

• OOM relation to vm.swappiness=0 in new kernel

  http://www.mysqlperformanceblog.com/2014/04/28/oom-relation-vm-swappiness0-new-kernel/

     

• Installing and Running HDP 2.1 on Windows

  http://www.sqlskills.com/blogs/bobb/installing-running-hdp-2-1-windows/

     

• ICYMI: Data platform momentum

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/04/28/icymi-data-platform-momentum.aspx

SQL

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

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

     

• SQLAuthority News ? Microsoft Whitepaper ? Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

  http://blog.sqlauthority.com/2014/04/26/sqlauthority-news-microsoft-whitepaper-optimizing-your-query-plans-with-the-sql-server-2014-cardinality-estimator/

     

• Introduction to Extended Events (video)

  http://www.brentozar.com/archive/2014/04/introduction-extended-events/

     

• Whaddayaknow 'bout #SQLServer Trace Flag 4134?

  http://sql-sasquatch.blogspot.kr/2014/04/whaddayaknow-bout-sqlserver-trace-flag.html

     

• Excessive logging pre-SQL 2012 when changing variable length columns from NULL to NOT NULL

  http://sqlscope.wordpress.com/2014/04/26/excessive-logging-pre-sql-2012-when-changing-variable-length-columns-from-null-to-not-null/

     

• SQL Injection: How it Works and How to Thwart it

  https://www.simple-talk.com/sql/database-administration/sql-injection-how-it-works-and-how-to-thwart-it/

     

• How to Create a Database Master Key

  http://sqlity.net/en/2373/create-database-master-key/

     

• 10 reasons why I HAte you!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/25/10-reasons-why-i-hate-you.aspx

     

• Database Performance Investigation/Intervention, MTPoD, Last Resorts

  http://sql-sasquatch.blogspot.kr/2014/04/database-performance.html

     

• SQL Server Reporting Services Basics: Building SSRS Reports

  https://www.simple-talk.com/sql/reporting-services/sql-server-reporting-services-basics-building-ssrs-reports/

     

• MDX Cell Properties Supported By Excel

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/25/mdx-cell-properties-supported-by-excel.aspx

     

• What does PCI DSS mean for your SQL Server environment?

  http://www.mssqltips.com/sqlservertip/3216/what-does-pci-dss-mean-for-your-sql-server-environment/

     

LINKS

• Friday Followup For April 25, 2014

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

     

     

Other

• The other side of Big Data. Interview with Michael L. Brodie.

  http://www.odbms.org/blog/2014/04/side-big-data-interview-michael-l-brodie/

     

• Managing farms of MySQL servers with MySQL Fabric

  http://www.mysqlperformanceblog.com/2014/04/25/managing-farms-of-mysql-servers-with-mysql-fabric/

     

• 왜 일이 예상대로 끝나지 않는가?

  http://www.mimul.com/pebble/default/2014/04/25/1398387387079.html

SQL

• Version 9.04.0013 of the RML Utilities for x86 and x64 has been released to the download center

  http://blogs.msdn.com/b/psssql/archive/2014/04/24/version-9-04-0013-of-the-rml-utilities-for-x86-and-x64-has-been-released-to-the-download-center.aspx

     

• "If You Can't Do ____, You're Not a Production DBA"

  http://www.brentozar.com/archive/2014/04/youre-not-a-dba-if-you-cant-do-this-one-trick/

     

• Prevent multiple users from running the same SQL Server stored procedure at the same time

  http://www.mssqltips.com/sqlservertip/3202/prevent-multiple-users-from-running-the-same-sql-server-stored-procedure-at-the-same-time/

     

• Most Recent Cumulative Updates for SQL Server 2008-2014

  http://www.sqlskills.com/blogs/glenn/most-recent-cumulative-updates-for-sql-server-2008-2014/

     

LINKS

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

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

     

     

Other

• 빠르게 훝어 보는 node.js - #10 Socket.IO 2/4 API 요약

  http://bcho.tistory.com/899

     

• Encrypted and incremental MySQL backups with Percona XtraBackup

  http://www.mysqlperformanceblog.com/2014/04/24/encrypted-and-incremental-mysql-backups-with-percona-xtrabackup/