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/