2013.08.28

197회 SQLTag Daily Links    

Update

   

SQL Server 2012 RTM Cumulative Update #9 is now available.

http://support.microsoft.com/kb/2867319

   

KB Article: KB #2867319.

Build Number is 11.0.2419.

Applicable to @@VERSION 11.0.2100 through 11.0.2410.

   

SQL

   

• SQL SERVER 2014 IN-MEMORY OLTP HEKATON USEFUL LINKS

  http://thomaslarock.com/2013/08/sql-server-2014-in-memory-oltp-hekaton-useful-links/

  Hekaton에 대해서 유용한 링크 정보를 공유해주셨네요.

   

• What is the CXPACKET Wait Type, and How Do You Reduce It?

  http://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/

     

• Back to Basics: SQL Parameter Sniffing due to Data Skews

  http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/08/27/back-to-basics-sql-parameter-sniffing-due-to-data-skews.aspx

     

• How to find out the SQL Server installation date?

  http://sqldbpool.com/2013/08/27/how-to-find-out-the-sql-server-installation-date

   

• How to make sure that view metadata is updated?

  http://sqldbpool.com/2013/08/27/how-to-make-sure-that-view-metadata-is-updated/

  sp_refreshview으로 뷰 정보를 갱신할 수 있네요.

     

• "Top Ten Tips for Optimizing SQL Server Performance"

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/27/top-ten-tips-for-optimizing-sql-server-performance.aspx

     

• When is throttling in Windows Azure SQL Database really throttling….

  http://blogs.msdn.com/b/psssql/archive/2013/08/27/when-is-throttling-in-windows-azure-sql-database-really-throttling.aspx

     

• Query Stats

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/27/query-stats.aspx

     

• Fixing SSRS 2008 R2 Row Limitation

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/27/fixing-ssrs-2008-r2-row-limitation.aspx

     

• How I Learned to Stop Worrying and Trust the Public Cloud

  http://sql-sasquatch.blogspot.kr/2013/08/how-i-learned-to-stop-worrying-and.html

     

• Dynamic Calculation of Inventory with #dax in #powerpivot and #ssas #tabular

  http://sqlblog.com/blogs/marco_russo/archive/2013/08/27/dynamic-calculation-of-inventory-with-dax-in-powerpivot-and-ssas-tabular.aspx

     

• Bulk Move/Rename of SSRS Reports through Web Services

  http://www.sqlservercentral.com/articles/Reporting+Services/101183/

   

• SSIS 2012 - Using PowerShell to Remotely Execute File System Packages in Multi-Server Scenarios        

  http://www.databasejournal.com/features/mssql/ssis-2012-using-powershell-to-remotely-execute-file-system-packages-in-multi-server-scenarios.html

     

• Creating Power View Reports in Excel 2013

  http://www.mssqltips.com/sqlservertip/3027/creating-power-view-reports-in-excel-2013/

     

• 10 Habits of Successful Senior DBAs that You Can Use Today

  http://www.johnsansom.com/10-habits-of-successful-senior-dbas-that-you-can-use-today/

  습관이라는게 무섭죠!! 블로그 글 보면서 많이 반성하게 됩니다^^

     

Other

   

• SQLite 1탄, 이것만은 알고 넘어가자!

  http://gywn.net/2013/08/let-me-intorduce-sqlite/

  (추천) 오매.... 잘 정리해 주셨네요~ 모바일 서비스 대세인 SQLite~

     

• Algorithm of the Week: Lock-based vs. Lock-free Concurrent Algorithms

  http://java.dzone.com/articles/algorithm-week-lock-based-vs

     

• Linux Systems Performance Analytics and Tools

  http://java.dzone.com/articles/linux-systems-performance

     

• Performance Tips for Hadoop on Amazon S3

  http://java.dzone.com/articles/performance-tips-hadoop-amazon