2014.01.27

   

   

   

SQL

   

• SQL Server Hekaton (XTP) in-memory tables: Choosing the correct BUCKET_COUNT for a Hash Index

  http://dataidol.com/tonyrogerson/2014/01/25/sql-server-hekaton-xtp-in-memory-tables-choosing-the-correct-bucket_count-for-a-hash-index/

   

• Final Service Packs for SQL Server 2008 and SQL Server 2008 R2

  http://www.sqlskills.com/blogs/glenn/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2/

     

• SQL SERVER ? Writing SQL Queries Made Easy with dbForget SQL Complete

  http://www.sqlserver.co.uk/index.php/sql-server-writing-sql-queries-made-easy-with-dbforget-sql-complete/

     

• Parameterization and filtered indexes (part 2)

  http://sqlblog.com/blogs/hugo_kornelis/archive/2014/01/24/parameterization-and-filtered-indexes-part-2.aspx

     

• SQL SERVER ? Standard Reports

  http://raresql.com/2014/01/24/sql-server-standard-reports/

   

• The SQL Server Sqliosim Utility

  http://www.sqlservercentral.com/redirect/articles/106205/

     

• It's all about Restoring.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/24/it-39-s-all-about-restoring.aspx

     

• Watch Brent Tune Queries

  http://www.brentozar.com/archive/2014/01/watch-brent-tune-queries/

     

• SQL SERVER ? Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server

  http://www.sqlserver.co.uk/index.php/sql-server-query-plan-analysis-of-pivot-and-unpivot-with-profiler-of-dbforge-studio-for-sql-server/

     

• Review of the book SQL Server 2012 Reporting Services Blueprints

  http://www.sqlserver.co.uk/index.php/review-of-the-book-sql-server-2012-reporting-services-blueprints/

     

• Merge Replication Identity Range Management,an identity disorder? Part 1

  http://www.pythian.com/blog/merge-replication-identity-range-managementan-identity-disorder-part-1/

     

• A Versioning system for SSRS

  http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/94119/

     

• Eight key SQL Server 2014 features

  http://searchsqlserver.techtarget.com/tip/Eight-key-SQL-Server-2014-features

     

LINKS

   

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

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

   

• Friday Followup For January 24, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/24/friday-followup-for-january-24-2014.aspx

     

• (SFTW) SQL Server Links 24/01/14

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

     

     

Other

   

• Monitoring the Performance of Multi-Tiered Windows Azure Applications

  http://cloud.dzone.com/articles/monitoring-performance-multi

   

• Vert.x 노트

  http://bcho.tistory.com/852

     

• MySQL server memory usage troubleshooting tips

  http://www.mysqlperformanceblog.com/2014/01/24/mysql-server-memory-usage-2/

     

• R을 프로덕션 레벨에서 사용하자!

  http://freesearch.pe.kr/archives/4016

     

• 10 Tips to Improve MongoDB Security

  http://java.dzone.com/articles/10-tips-improve-mongodb