2013.07.08

짧지만 긴 여름 휴가를 끝내고 돌아왔습니다. 남자 애 두 명 데리고 물 놀이장 다녀온게 다네요^^

   

SQL

   

• July, the 31 Days of SQL Server DMO's ? Day 5 (sys.dm_exec_query_plan)

  http://sqlblog.com/blogs/tamarick_hill/archive/2013/07/05/july-the-31-days-of-sql-server-dmo-s-day-5-sys-dm-exec-query-plan.aspx

   

• July, the 31 Days of SQL Server DMO's ? Day 6 (sys.dm_exec_cached_plans)

  http://sqlblog.com/blogs/tamarick_hill/archive/2013/07/06/july-the-31-days-of-sql-server-dmo-s-day-6-sys-dm-exec-cached-plans.aspx

     

• July, the 31 Days of SQL Server DMO's ? Day 7 (sys.dm_exec_procedure_stats)

  http://sqlblog.com/blogs/tamarick_hill/archive/2013/07/07/july-the-31-days-of-sql-server-dmo-s-day-7-sys-dm-exec-procedure-stats.aspx

   

• SQL SERVER ? Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL

  http://blog.sqlauthority.com/2013/07/07/sql-server-check-database-level-isnullconcat-and-session-level-settings-concat_null_yields_null-using-t-sql/

     

• Report Server Analytics with PowerPivot

  http://troubleshootingsql.com/2013/07/07/report-server-analytics-with-powerpivot/

   

• Error message "Invalid column name 'uses_native_compilation'" when scripting objects in SQL 2014 CTP1

  http://blogs.msdn.com/b/arvindsh/archive/2013/07/05/error-message-invalid-column-name-uses-native-compilation-when-scripting-objects-in-sql-2014-ctp1.aspx

     

• Column Order in an Index

  http://www.sqlservercentral.com/articles/Indexing/71376/

     

• SQL Server Trace Flags

  http://www.sqlservercentral.com/articles/trace+flags/70131/

  최신 Trace flag~~ 한아 한테 필요해 보여~ ㅋㅋㅋ

     

Other

   

• NoSQL Databases: Why, What, and When

  http://architects.dzone.com/articles/nosql-databases-why-what-and

     

• Schema changes ? what's new in MySQL 5.6?

  http://www.mysqlperformanceblog.com/2013/07/05/schema-changes-whats-new-in-mysql-5-6/

     

• Redis - Caching Server

  http://java.dzone.com/articles/redis-caching-server

  Redis 설치부터 개념 정리까지^^