2014.03.17

   

SQL

   

• Some great news for Standard Edition customers in SQL Server 2014

  http://www.sqlperformance.com/2014/03/system-configuration/great-news-for-standard-edition
  2014 STD 최대 메모리가 64GB -> 128GB으로 늘었났네요. Buffer Pool Extensions도 초반 ENT 버젼으로 나왔는데 STD까지 사용 가능.

   

• Top SQL Blogs ? Windows 8 App | from MSDN, MVPs and Top Bloggers

  http://sqlwithmanoj.wordpress.com/2014/03/14/top-sql-blogs-windows-8-app-from-msdn-mvps-and-top-bloggers/

     

• Verify a success of database backups

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/16/verify-a-success-of-database-backups.aspx

     

• Uniquifiers: all rows or the duplicate keys only?

  http://spaghettidba.com/2014/03/14/uniquifiers-all-rows-or-the-duplicate-keys-only/

     

• Dive deep into SQL Server 2014 in-memory OLTP

  http://searchsqlserver.techtarget.com/tip/Dive-deep-into-SQL-Server-2014-in-memory-OLTP

     

• Disk Partition Alignment for Windows Server 2012, SQL Server 2012, and SQL Server 2014

  http://blogs.msdn.com/b/jimmymay/archive/2014/03/14/disk-partition-alignment-for-windows-server-2012-sql-server-2012-and-sql-server-2014.aspx

     

• Performance Tuning with SQL Server Dynamic Management Views

  http://sqlblog.com/blogs/sergio_govoni/archive/2014/03/14/performance-tuning-with-sql-server-dynamic-management-views.aspx

     

• Useful SQL Queries and Projects

  http://java.dzone.com/articles/useful-sql-queries-and

     

• Strange behaviour on CHECK constraint

  http://sqlblog.com/blogs/damian_widera/archive/2014/03/16/strange-behaviour-on-check-constraint.aspx

     

• PowerShell to list the packages stored in Integration Services SQL2008/SQL2008R2

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/14/powershell-to-list-the-packages-stored-in-integration-services-sql2008-sql2008r2.aspx

     

• BI Beginner: Use Power Query To Get Data From Web Pages

  http://sqlblog.com/blogs/john_paul_cook/archive/2014/03/13/bi-beginner-use-power-query-to-get-data-from-web-pages.aspx

     

• Automate Sliding Window Partition Maintenance: Part II

  http://www.sqlservercentral.com/articles/Partitioning/71656/

     

• Why worry about CXPACKET

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/11/why-worry-about-cxpacket.aspx

     

• Local TempDB on SQL 2012

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/11/local-tempdb-on-sql-2012.aspx

     

• When is a Data Management Gateway Needed in Power BI?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/16/when-is-a-data-management-gateway-needed-in-power-bi.aspx

     

• Big Data Basics - Part 4 - Introduction to HDFS

  http://www.mssqltips.com/sqlservertip/3180/big-data-basics--part-4--introduction-to-hdfs/

     

• Real-time query access with PDW

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/13/real-time-query-access-with-pdw.aspx

     

LINKS

   

• (SFTW) SQL Server Links 14/03/14

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

   

• Friday Followup For March 14, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/14/friday-followup-for-march-14-2014.aspx

   

• Recommended reading from mrdenny for March 14, 2014

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-march-14-2014/

     

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

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

     

Other

   

• Everything is Data ? TEDxSNU 발표

  http://zeronova.kr/2014/03/15/everything-is-data-tedxsnu/

     

• Tools and tips for analysis of MySQL's Slow Query Log

  http://www.mysqlperformanceblog.com/2014/03/14/tools-and-tips-for-analysis-of-mysqls-slow-query-log/

     

• 실시간 빅데이터는 어떻게 분석할까

  http://helloworld.naver.com/helloworld/textyle/694050

     

• 린분석(Lean Analytics) with 레진코믹스

  http://xguru.net/1887