2012.12.04

   

SQL

• Find Referenced Objects of a particular object
  http://www.google.co.kr/reader/view/?hl=ko&tab=wy
   
• Top 10 Learning Resources for Accidental DBAs
  http://www.sqlskills.com/blogs/glenn/post/Top-10-Learning-Resources-for-Accidental-DBAs.aspx
  DBA를 위한 참고용 자료들을 트위터, 포럼, 블로그 등등 정리해 놓았네요. 전 여기서 트위터 목록의 사람들을 모두 등록.ㅋㅋㅋㅋ

     

  SQL MVP 목록 http://wefollow.com/twitter/mvp
  SQL Server Blogger Rankings http://thomaslarock.com/rankings/ <-- 여기 자료 좋은데요.ㅋㅋ

     

• New version of Partition Management Utility supports SQL2012, ColumnStore Indexes
  http://blogs.msdn.com/b/sqlcat/archive/2012/12/03/new-version-of-partition-management-utility-supports-sql2012-columnstore-indexes.aspx
  새로운 버젼 SQL2012의 파티션 관리 유틸리티가 공유되었네요. http://sqlpartitionmgmt.codeplex.com/

   

• How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower
  http://blogs.msdn.com/b/psssql/archive/2012/12/03/how-it-works-gotcha-varchar-max-caused-my-queries-to-be-slower.aspx
   
• SQL Server: SET SET, A Strange Compatibility Upgradation Issue
  http://connectsql.blogspot.kr/2012/12/sql-server-set-set-strange.html
   
• A Useful Tip For Dealing With A Full Transaction Log Drive
  http://shaunjstuart.com/archive/2012/12/a-useful-tip-for-dealing-with-a-full-transaction-log-drive/
   
• Tip: Resetting Identity Fields
  http://www.sqlservercentral.com/articles/DBCC+CHECKIDENT/94559/

     

• How to Identify and Backup the Latest SQL Server Database in a Series
  http://www.mssqltips.com/sqlservertip/2807/how-to-identify-and-backup-the-latest-sql-server-database-in-a-series/
   

Cloud & BigData & NoSQL

• ACID transaction in the NoSQL world
  http://data.story.lu/2012/12/03/acid-transaction-in-the-nosql-world
  NoSQL 계열의 ACID 트랜잭션을 지원해주는 솔루션은 Redis, Neo4J, ZODB, FoundationDB…
   
• WordPress with SQL Azure

  http://cloud.dzone.com/articles/wordpress-sql-azure
  흥미롭네요. SQL Azure로 WordPress 블로그 데이터가 운영될 수 있게 지원되다니~, MySQL 공부 끝나면 SQL Azure 공부해야지.