2013.07.09

   

SQL

   

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

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

   

• Ordering steps in a SQL Agent job

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/07/08/ordering-steps-in-a-sql-agent-job.aspx

   

• Sample Database Using In-Memory OLTP

  http://msdn.microsoft.com/en-us/library/dn296374(v=sql.120).aspx

  Hekaton테스트 DB Northwind 생성하기~ 얼~~ db 생성부터 table, sp, view, data 한방에 넣을 수 있어요^^

     

• A more complex discussion of user transactions and memory-optimized tables

  http://www.sqlskills.com/blogs/bobb/a-more-complex-discussion-of-user-transactions-and-memory-optimized-tables/

     

• Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1

  https://www.simple-talk.com/sql/database-administration/exploring-in-memory-oltp-engine-%28hekaton%29-in-sql-server-2014-ctp1/

  Hekaton은 정말 어렵네요..ㅠㅠ~~ 공부해야징~~

     

• Microsoft's SQL Server 2014: More than just in-memory OLTP

  http://www.zdnet.com/microsofts-sql-server-2014-more-than-just-in-memory-oltp-7000016672/

     

• TechEd Europe 2013 lessons learnt :SQL Server 2014,powershell,performance,automation

  http://www.sqlserver-dba.com/2013/07/teched-europe-2013-lessons-learnt-sql-server-2014powershellperformanceautomation.html

     

• Slice on a Calculated Member that uses the Aggregate function

  http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/07/08/slice-on-a-calculated-member-that-uses-the-aggregate-function.aspx

     

• Columnstore Queries in SQL Server 2012

  https://www.simple-talk.com/sql/t-sql-programming/columnstore-queries-in-sql-server-2012/        

     

• SQL Server ? How to change SQL Server ERRORLOG location

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/07/08/sql-server-how-to-change-sql-server-errorlog-location.aspx

     

• Report from a Cube in Reporting Services

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/07/08/report-from-a-cube-in-reporting-services.aspx

     

• Working Around Missed Optimizations

  http://www.sqlperformance.com/2013/07/sql-plan/working-around-missed-optimizations

     

• HOW TO: Find the Physical host of a VM in Hyper ?V

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/07/08/how-to-find-the-physical-host-of-a-vm-in-hyper-v.aspx

     

• A simple trick for "Block Comment" syntax in SSMS

  http://www.sqlservercentral.com/articles/T-SQL/100061/

     

• How to change server level collation for a SQL Server Instance

  http://www.mssqltips.com/sqlservertip/2901/how-to-change-server-level-collation-for-a-sql-server-instance/        

  아주 가끔 써야 할 때가 있죠? collation 변경할 일들이~^^

     

• Untrusted check constraints

  http://sqlmonitormetrics.red-gate.com/untrusted-check-constraints/

     

• Large Scale Data Analytics with XtremeData Parallel SQL Database Engine

  http://architects.dzone.com/articles/large-scale-data-analytics

     

Other

   

• StackMob - Amazon S3 Setup

  http://cloud.dzone.com/articles/stackmob-amazon-s3-setup

  아마존 S3 5분짜리 설치 동영상입니다. 와우~

   

• [입 개발] Sentinel은 어떻게 노드를 찾아낼까?

  http://charsyam.wordpress.com/2013/07/08/%EC%9E%85-%EA%B0%9C%EB%B0%9C-sentinel%EC%9D%80-%EC%96%B4%EB%96%BB%EA%B2%8C-%EB%85%B8%EB%93%9C%EB%A5%BC-%EC%B0%BE%EC%95%84%EB%82%BC%EA%B9%8C

  
  

   와우~
  

  Redis Korean User Group  
  https://www.facebook.com/groups/301632676649865/

  MongoDB Korea
  https://www.facebook.com/groups/213117132175775/