SQL

• LAG and LEAD for SQL Server 2008

  http://sqlscope.wordpress.com/2014/05/26/lag-and-lead-for-sql-server-2008/

• How Database Mail works in SQL Server ?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/26/how-database-mail-works-in-sql-server.aspx

• Configuring SQL Server 2012 Always On Lab- Part 4

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/26/configuring-sql-server-2012-always-on-lab-part-4.aspx

• Columnstore Case Study #2: Columnstore faster than SSAS Cube at DevCon Security

  http://blogs.msdn.com/b/jimmymay/archive/2014/05/26/columnstore-case-study-2-columnstore-faster-than-ssas-cube-at-devcon-security.aspx

     

• Data Mining Introduction

  http://www.sqlservercentral.com/articles/server/94235/        

     

• Microsoft's free virtual labs

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/26/microsoft-s-free-virtual-labs.aspx

     

LINKS

• LAST WEEK'S TOP 20 "READING" LINKS

  http://www.jasonstrate.com/2014/05/last-weeks-top-reading-links-85/

     

Other

• Faking a slave: Subscribing to mysql row-based-replication changes

  http://www.tocker.ca/2014/05/26/faking-a-slave-subscribing-to-mysql-row-based-replication-changes.html

SQL

• Adventures with SQL Server & perfmon Part 1: Resource Governor & Query Memory

  http://sql-sasquatch.blogspot.kr/2014/05/adventures-with-sql-server-and-perfmon.html

     

• Adventures with SQL Server & perfmon Part 2: TokenAndPermUserStore & spinlock suspects

  http://sql-sasquatch.blogspot.kr/2014/05/adventures-with-sql-server-perfmon-part.html

• How to Work Around Standard Edition's Limits [Video]

  http://www.brentozar.com/archive/2014/05/work-around-standard-editions-limits-video/

     

• Can you partition a temporary table?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/23/can-you-partition-a-temporary-table.aspx

     

• The overhead of #temp table creation tracking

  http://sqlperformance.com/2014/05/t-sql-queries/overhead-temp-table-tracking

• Table Pattern: Rotating Log / Ring Buffer

  http://kejser.org/table-pattern-rotating-log-ring-buffer/

     

• SQL Server 2008 Service Pack 3 Cumulative Update 17

  http://www.sqlskills.com/blogs/glenn/sql-server-2008-service-pack-3-cumulative-update-17

• CREATE ASYMMETRIC KEY ? How to Generate an Asymmetric Key

  http://sqlity.net/en/2417/create-asymmetric-key/

     

• Can you partition a temporary table?

  http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/

     

     

LINKS

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

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

• Friday Followup For May 23, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/23/friday-followup-for-may-23-2014.aspx

     

Other

• 2014 JVM 테크니컬 리더들에 대한 개인적 소견

  http://beyondj2ee.wordpress.com/2014/05/23/2014-jvm-%ED%85%8C%ED%81%AC%EB%8B%88%EC%BB%AC-%EB%A6%AC%EB%8D%94%EB%93%A4%EC%97%90-%EB%8C%80%ED%95%9C-%EA%B0%9C%EC%9D%B8%EC%A0%81-%EC%86%8C%EA%B2%AC/

     

• (SFTW) SQL Server Links 23/05/14

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

     

• PostgreSQL Gets Better NoSQL Capabilities

  http://www.infoq.com/news/2014/05/postgresql-9-4

     

• MySQL soon to store system tables in InnoDB

  http://www.tocker.ca/2014/05/22/mysql-soon-to-store-system-tables-in-innodb.html

SQL

• Dude, who owns that #temp table?

  http://sqlperformance.com/2014/05/t-sql-queries/dude-who-owns-that-temp-table

     

• Capping CPU using Resource Governor ? The Concurrency Mathematics

  http://blogs.msdn.com/b/psssql/archive/2014/05/21/capping-cpu-using-resource-governor-the-concurrency-mathematics.aspx

     

• Backups, Restores, Corruption, and You: How Strong are You?

  http://www.brentozar.com/archive/2014/05/now-available-backup-recovery-advanced/

     

• Implementing Transactions in SQL Server ? Part II

  http://www.sql-server-performance.com/2014/implementing-transactions-sql-server/

• PowerShell ? OS Inventory and Disk Info ? Consolidated Excel File ? EMAIL

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/21/powershell-os-inventory-and-disk-info-consolidated-excel-file-email.aspx

• Expanding All Columns In A Table In Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/21/expanding-all-columns-in-a-table-in-power-query.aspx

     

• Dell Doubles Application Speeds, Processes Transactions 9X Faster with In-Memory OLTP

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/05/21/dell-doubles-application-speeds-processes-transactions-9x-faster-with-in-memory-oltp.aspx

     

Other

• MySQL ? Scalability on Amazon RDS: Scale out to multiple RDS instances

  http://www.sqlserver.co.uk/index.php/mysql-scalability-on-amazon-rds-scale-out-to-multiple-rds-instances/

UPDATE

• The final Cumulative Update for SQL Server 2008 SP3

  http://sqlblog.com/blogs/aaron_bertrand/archive/2014/05/19/the-final-cumulative-update-for-sql-server-2008-sp3.aspx

     마지막 패치네요 ㅠㅠ

• Build # 10.00.5861
• KB Article: KB #2958696
• 9 public fixes
• Relevant for builds 10.00.5500 -> 10.00.5860
• NOT for SQL Server 2008 R2 (10.50.xxxx)

SQL

• How In-Memory Database Objects Affect Database Design: The Conceptual Model

  http://sqlblog.com/blogs/louis_davidson/archive/2014/05/19/how-in-memory-database-objects-affect-database-design-the-conceptual-model.aspx

• SQL Server 2012 AlwaysOn Groups and FCIs Part 4

  http://www.sqlservercentral.com/articles/Mirroring/107295/

     

• How Much Memory Does SQL Server Need?

  http://www.brentozar.com/archive/2014/05/much-memory-sql-server-need/

     

• Architecture of the Microsoft Analytics Platform System

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/05/20/architecture-of-the-microsoft-analytics-platform-system.aspx

     

LINKS

• LAST WEEKS TOP "READING" LINKS #84        

  http://www.jasonstrate.com/2014/05/last-weeks-top-reading-links-84/

     

Other

• 대용량 분산 시스템 아키텍쳐 디자인

  http://bcho.tistory.com/907

     

• Batch mode and expired passwords

  http://mysqlblog.fivefarmers.com/2014/05/20/batch-mode-and-expired-passwords/

     

• Database auditing alternatives for MySQL

  http://www.mysqlperformanceblog.com/2014/05/20/database-auditing-alternatives-mysql/

SQL

• Most common wait stats over 24 hours and changes since 2010

  http://www.sqlskills.com/blogs/paul/common-wait-stats-24-hours/

     

• Using Encrypted Backups in SQL Server 2014

  http://www.sqlservercentral.com/articles/Encryption/109028/

     

• Curious About the SQL Server Server 2014 Cardinality Estimator?

  http://www.brentozar.com/archive/2014/05/curious-sql-server-server-2014-cardinality-estimator/

     

• Missing Indexes Script v2

  http://jasonbrimhall.info/2014/05/15/missing-indexes-script-v2

     

• How to Predict SQL Server Performance

  http://www.sqlserver-dba.com/2014/05/how-to-predict-sql-server-performance.html

     

• Validate File Properties with PowerShell Prior to Import into SQL Server

  http://www.mssqltips.com/sqlservertip/3210/validate-file-properties-with-powershell-prior-to-import-into-sql-server/

     

• Did you know documentation is built-in to usp_ssiscatalog?

  http://www.sqlserver.co.uk/index.php/did-you-know-documentation-is-built-in-to-usp_ssiscatalog/

     

• SQL SERVER ? SSIS Look Up Component ? Cache Mode ? Notes from the Field #028

  http://blog.sqlauthority.com/2014/05/15/sql-server-ssis-look-up-component-cache-mode-notes-from-the-field-028/

     

Other

• High Availability with MySQL Fabric: Part I

  http://www.mysqlperformanceblog.com/2014/05/15/high-availability-mysql-fabric-part/

• Why ALTER TABLE runs faster on Percona Server 5.5 vs. MySQL 5.5

  http://www.mysqlperformanceblog.com/2014/05/15/why-alter-table-runs-faster-on-percona-server/

SQL

• 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/

• Encrypt a file from SSIS using the Advanced Encryption Standard (AES)

  http://www.sqlservercentral.com/articles/AES-256/107713/

     

• Debugging a SQL Server query with WinDbg

  http://www.sqlpassion.at/archive/2014/05/13/debugging-a-sql-server-query-with-windbg/

     

• How to Configure Anti-Virus for SQL Servers

  http://www.brentozar.com/archive/2014/05/configure-anti-virus-sql-servers/

     

• What happens when the OLAP Query Log doesn't turn on

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/13/what-happens-when-the-olap-query-log-doesn-t-turn-on.aspx

     

• Cycle SQL Server Error Logs based on size using PowerShell

  http://www.mssqltips.com/sqlservertip/3229/cycle-sql-server-error-logs-based-on-size-using-powershell/

     

• SQL SERVER ? Simple Example of Incremental Statistics ? Performance improvements in SQL Server 2014 ? Part 2

  http://www.sqlserver.co.uk/index.php/sql-server-simple-example-of-incremental-statistics-performance-improvements-in-sql-server-2014-part-2/

SQL

• Doug Broke It: Minimal Logging [Video]

  http://www.brentozar.com/archive/2014/05/doug-broke-minimal-logging-video/

• Administering Database Master Keys in SQL Server

  http://www.sqlservercentral.com/articles/Encryption/108750/

     

• CERTPROPERTY ? Digging Deeper into SQL Server Certificates

  http://sqlity.net/en/2397/certproperty/

     

• Powershell for the perfmon files

  http://troubleshootingsql.com/2014/05/12/powershell-for-the-perfmon-files/

     

• Filetable?Nesting folders and files

  http://voiceofthedba.wordpress.com/2014/05/12/filetablenesting-folders-and-files/

     

• Add Node to Windows Server 2008 Cluster

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/12/add-node-to-windows-server-2008-cluster.aspx

     

• SQL SERVER 2012 ? Fix ? Error : 22960- Change data capture instance has not been enabled for the source table

  http://raresql.com/2014/05/12/sql-server-2012-fix-error-22960-change-data-capture-instance-has-not-been-enabled-for-the-source-table/

     

• Configuring SQL Server 2012 Always On Lab- Part 2

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/12/configuring-sql-server-2012-always-on-lab-part-2.aspx

     

• SQL SERVER ? What is Incremental Statistics? ? Performance improvements in SQL Server 2014 ? Part 1

  http://www.sqlserver.co.uk/index.php/sql-server-what-is-incremental-statistics-performance-improvements-in-sql-server-2014-part-1/

     

LINKS

• LAST WEEKS TOP "READING" LINKS #83

  http://www.jasonstrate.com/2014/05/last-weeks-top-reading-links-83/

Other

• xDebug 설치로 PHP 디버깅 하기

  http://jinhokwon.blogspot.kr/2014/05/xdebug-php.html

     

• Local에 git 저장소 만들기

  http://insanehong.kr/post/create-repository/

SQL

• The Read Committed Isolation Level - Paul White

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

• Causes of IO_COMPLETION and WRITE_COMPLETION SQL Server wait types

  http://www.sqlskills.com/blogs/paul/causes-io_completion-write_completion-sql-server-wait-types

     

• Delayed Durability in SQL Server 2014 - Aaron Bertrand

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

     

• How Automatic Updates to Statistics Can Affect Query Performance

  http://sqlperformance.com/2014/05/sql-performance/auto-stats-effects

     

• SQLskills community mentoring ? round 6

  http://www.sqlskills.com/blogs/paul/sqlskills-community-mentoring-round-6/

     

• Optimizing Transaction Log Throughput

  https://www.simple-talk.com/sql/database-administration/optimizing-transaction-log-throughput/

     

• Dream DBA

  http://www.pythian.com/blog/how-to-become-a-dream-dba/

• Shrinking tempdb no longer prohibited

  http://www.sqlskills.com/blogs/paul/shrinking-tempdb-longer-prohibited

• Introducing sp_BlitzCache™

  http://www.brentozar.com/archive/2014/05/introducing-sp_blitzcache/

     

• Clustered Columnstore Indexes: Exploring Delta Store and Delete Bitmap

  http://aboutsqlserver.com/2014/05/06/clustered-columnstore-indexes-exploring-delta-store-and-delete-bitmap/

     

• The Cardinality Estimator in SQL Server 2014 ? Going Forward and Backward

  http://voiceofthedba.wordpress.com/2014/04/30/the-cardinality-estimator-in-sql-server-2014-going-forward-and-backward/

     

• 4 Lightweight Ways to Tell if a Database is Used

  http://www.brentozar.com/archive/2014/05/4-lightweight-ways-tell-database-used/

     

• SQL Server Debugging with WinDbg ? an Introduction

  http://www.sqlpassion.at/archive/2014/05/05/sql-server-debugging-with-windbg-an-introduction/

     

• How to Restore a Certificate in SQL Server

  http://sqlity.net/en/2384/restore-certificate/

     

• SQL intersection slides and samples

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

     

• SELECT INTO ? Moving Data From A To B

  http://kejser.org/databases/select-into-moving-data-from-a-to-b/

     

• Cannot Failover Nodes Using TempDB on Local Storage

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/08/cannot-failover-nodes-using-tempdb-on-local-storage.aspx

     

• Further Testing with Automatic Updates to Statistics

  http://www.sqlskills.com/blogs/erin/testing-automatic-updates-statistics

     

• DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/30/dba-myths-truncate-table-deletes-all-the-rows-of-a-table-instantly.aspx

     

• Differential Changed Map (DCM): How SQL Server Tracks Changed Pages

  http://sqlity.net/en/2387/dcm/

     

• SQL Server 2014 Clustered Columnstore Indexes and Partitioning

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/01/sql-server-2014-clustered-columnstore-indexes-and-partitioning.aspx

     

• Migrating SQL Server logins

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/07/migrating-sql-server-logins.aspx

     

• Using Kerberos With SQL Server ? Part 1 ? Double Hop

  http://www.seangallardy.com/2014/05/using-kerberos-with-sql-server-part-1-double-hop

     

• Using Kerberos With SQL Server ? Part 2 ? Across Domains

  http://www.seangallardy.com/2014/05/using-kerberos-with-sql-server-part-2-across-domains

     

• Configuring SQL Server 2012 Always On Lab- Part 1

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/05/configuring-sql-server-2012-always-on-lab-part-1.aspx

     

• Why is there a sysobjects when we already have sys.objects?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/05/why-is-there-a-sysobjects-when-we-already-have-sys-objects.aspx

     

• Does SQL Server do a CHECKDB during an instance restart?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/07/does-sql-server-do-a-checkdb-during-an-instance-restart.aspx

     

• SQL SERVER ? What is SSAS Tabular Data model and Why to use it ? Part 2

  http://blog.sqlauthority.com/2014/05/07/sql-server-what-is-ssas-tabular-data-model-and-why-to-use-it-part-2/

     

LINKS

• Friday Followup For May 2, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/02/friday-followup-for-may-2-2014.aspx

     

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

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

     

• LAST WEEKS TOP "READING" LINKS #82

  http://www.jasonstrate.com/2014/05/last-weeks-top-reading-links-82/

     

Other

• DynamoDB의 Write Capacity를 낮춰서 DynamoDB 비용 줄이기

  http://readme.skplanet.com/?p=7570

     

• Use MySQL to store NoSQL and SQL data in the same database using memcached and InnoDB

  https://scriptingmysql.wordpress.com/2014/05/01/use-mysql-to-store-nosql-and-sql-data-in-the-same-database-using-memcached-and-innodb/

     

• Parallel Query for MySQL with Shard-Query

  http://java.dzone.com/articles/parallel-query-mysql-shard

     

• How to identify and cure MySQL replication slave lag

  http://www.mysqlperformanceblog.com/2014/05/02/how-to-identify-and-cure-mysql-replication-slave-lag/

     

• Row-based replication, MySQL 5.6 upgrades and temporal data types

  http://www.mysqlperformanceblog.com/2014/05/06/row-based-replication-mysql-5-6-upgrades-and-temporal-data-types/

SQL

• How It Works: Behavior of a 1 Trillion Row Index Build (Gather Streams from SORT)

  http://blogs.msdn.com/b/psssql/archive/2014/04/29/how-it-works-behavior-of-a-1-trillion-row-index-build-gather-streams-from-sort.aspx

• Memory and IO in Tempdb: SQL 2014 Improvement

  http://www.brentozar.com/archive/2014/04/memory-ssd-tempdb-temp-table-sql-2014/

     

• SQL Server Quickie #13 ? Hash Join Operator

  http://www.sqlpassion.at/archive/2014/04/29/sql-server-quickie-13-hash-join-operator

     

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

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

     

• Five tips to avoid a performance bottleneck or other SQL Server snares

  http://searchsqlserver.techtarget.com/tip/Five-tips-to-avoid-a-performance-bottleneck-or-other-SQL-Server-snares

     

• How to grab multiple parent/child elements from XML Data Source

  http://blogs.msdn.com/b/psssql/archive/2014/04/29/how-to-grab-multiple-parent-child-elements-from-xml-data-source.aspx

     

LINKS

• Last Weeks Top "Reading" Links #81

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

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