2013.01.25

Update

   

• Cumulative Update #2 for SQL Server 2012 Service Pack 1

   

CU#2 KB Article: http://support.microsoft.com/kb/2790947

Understanding Incremental ServicingModel for SQL Server

SQL Server Support Information: http://support.microsoft.com/ph/2855

   

SQL

   

• SQL Server Backup and Restore to Cloud Simplified

  http://blogs.msdn.com/b/windowsazure/archive/2013/01/23/sql-server-backup-and-restore-to-cloud-simplified.aspx

   

• Backup and Restore to Cloud Simplified in SQL Server 2012 SP1 CU2

  http://sqlblog.com/blogs/sqlos_team/archive/2013/01/24/backup-and-restore-to-cloud-simplified-in-sql-server-2012-sp1-cu2.aspx

   

• NOLOCK is not a turbo button

  http://itknowledgeexchange.techtarget.com/sql-server/nolock-is-not-a-turbo-button/

   

• SQL SERVER DATA TOOLS: WHY MUST LIFE BE SO HARD?

  http://thomaslarock.com/2013/01/sql-server-data-tools-why-must-life-be-so-hard/

   

• Another reason to use THROW clause instead of RAISERROR | SQL Server 2012

  http://sqlwithmanoj.wordpress.com/2013/01/24/another-reason-to-use-throw-clause-instead-of-raiserror-sql-server-2012

  SQL2012에서는 예외처리 쉽네요잉!^^ TRY~CATCH와 THROW 처리만 해주면 되니~ @.@

   

• When a Query Isn't Quite a Query

  http://www.brentozar.com/archive/2013/01/when-a-query-isnt-quite-a-query/

   

• T-SQL Restore Script Generator

  http://www.sqlservercentral.com/articles/Restore+database/95839/

  쥑인다~~ @.@ 내가 찾던 Script~~

   

• SQL Server – LCK_M_IS and how to reduce it - sql wait type

  http://www.sqlserver-dba.com/2013/01/sql-server-lck_m_is-and-how-to-reduce-it-sql-wait-type.html

  참 정리 잘 해놓으셨네^^

   

• Encrypting SQL Server backups with open source tools

  http://www.mssqltips.com/sqlservertip/2861/encrypting-sql-server-backups-with-open-source-tools/

  SQL2012 버젼부터 backup 할때 password 처리 부분이 없어졌는데 opensource로 암호화 처리가 가능한 유용한 방법 소개네요^^ 요즘 오픈 소스 및 프로젝트가 대세내요~ @.@

   

• Introduction to SQL Server Check Constraints

  http://www.sql-server-performance.com/2013/introduction-sql-server-check-constraints

   

• SQL SERVER – How to Use Instead of Trigger – Guest Post by Vikas Munjal – Koenig Solutions

  http://blog.sqlauthority.com/2013/01/24/sql-server-how-to-use-instead-of-trigger-guest-post-by-vikas-munjal-koenig-solutions/

   

• Visualizing Data File Layout II

  http://sqlblog.com/blogs/merrill_aldrich/archive/2013/01/23/visualizing-data-file-layout-ii.aspx

   

ETC

   

• 국내 오픈소스 DB툴 Tadpole (올챙이)를 소개 합니다

  http://beyondj2ee.wordpress.com/2013/01/24/%EA%B5%AD%EB%82%B4-%EC%98%A4%ED%94%88%EC%86%8C%EC%8A%A4-db%ED%88%B4-tadpole-%EC%98%AC%EC%B1%99%EC%9D%B4%EB%A5%BC-%EC%86%8C%EA%B0%9C-%ED%95%A9%EB%8B%88%EB%8B%A4/

  몽고디비, MySQL 등등 DB 툴입니다. 쥑인다 @@~ 몽고DB나 해볼까??