RAMESH MEYYAPPAN님의 최신 블로깅 내용 

Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1)
http://blog.sqlworkshops.com/slow-performance-due-to-sql-server-2014-buffer-pool-extension-bpe-and-serial-queries-maxdop-1/

NUMA remote (foreign) memory access overhead on Windows, SQL Server and In-Memory OLTP
http://blog.sqlworkshops.com/slow-performance-due-to-sql-server-2014-buffer-pool-extension-bpe-and-serial-queries-maxdop-1/

드디어 출간 되었습니다.
SQL DBA라면~~

http://www.kyobobook.co.kr/product/detailViewKor.laf?ejkGb=KOR&mallGb=KOR&barcode=9791195328307&orderClick=LAG&Kc=

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

• Data Modifications under Read Committed Snapshot Isolation - Paul White

  http://sqlperformance.com/2014/05/t-sql-queries/data-modifications-under-rcsi

     

• Exotic spinlocks: X_PACKET_LIST and XID_ARRAY

  http://blogs.msdn.com/b/arvindsh/archive/2014/05/14/exotic-spinlocks-x-packet-list-and-xid-array.aspx

     

• SQL Server 2014 is Customer Tested!

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/05/14/sql-server-2014-is-customer-tested.aspx

     

• Implement a SQL Server HA failover solution without shared storage

  http://www.mssqltips.com/sqlservertip/3241/implement-a-sql-server-ha-failover-solution-without-shared-storage/

     

• The Performance of Traversing a SQL Hierarchy

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

     

• Bulk Changed Map (BCM): The Minimally Logged Advantage

  http://sqlity.net/en/2399/bcm/

     

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

  http://sqlblog.com/blogs/jamie_thomson/archive/2014/05/14/did-you-know-documentation-is-built-in-to-usp-ssiscatalog.aspx

     

Other

• The 3 Factors That Will Get You a Job You'll Love

  http://www.dbnewsfeed.com/2014/05/13/the-3-factors-that-will-get-you-a-job-youll-love/

• Technical Interviews ? How to Thrive

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/13/technical-interviews-how-to-thrive.aspx

     

• max_allowed_packet and binary log corruption in MySQL

  http://www.mysqlperformanceblog.com/2014/05/14/max_allowed_packet-and-binary-log-corruption-in-mysql/

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/