2013.02.13 (1)

안녕하세요. 주디아줌마입니다.

설 연휴 잘 보내셨나요? 연휴동안 쉬었더니~ 헉헉… 어마어마한 자료들이 bb… 아침, 점심 시간 동안 정리해서 올려야겠어요.

   

SQL

• The Path to In-Memory Database Technology

  http://sqlblog.com/blogs/joe_chang/archive/2013/02/11/the-path-to-in-memory-database-technology.aspx

     

• An in-depth look at change detection in SQL Server - Part 01

  http://www.sqlservercentral.com/articles/change+detection/95930/

     

• Day 27 of 31 Days of Disaster Recovery: Restoring Part of a Database

  http://www.sqlsoldier.com/wp/sqlserver/day-27of31daysofdisasterrecoveryrestoringpartofadatabase

  31day 시리즈가 다되어가네요^^ 정말 재미있는 이슈들 ㅎ.ㅎ

     

• Under rare conditions, using IN clause can cause unexpected SQL behavior

  http://blogs.msdn.com/b/psssql/archive/2013/02/11/under-rare-conditions-using-in-clause-can-cause-unexpected-sql-behavior.aspx

  이런 이슈들이 있었군여^^?

     

• Avoiding SQL Server Query Disaster through Refactoring for Resilience

  http://www.mssqltips.com/sqlservertip/2881/avoiding-sql-server-query-disaster-through-refactoring-for-resilience/

     

• Hardware Sizing Guide for SSAS Tabular

  http://sqlblog.com/blogs/greg_low/archive/2013/02/13/hardware-sizing-guide-for-ssas-tabular.aspx

     

• T-SQL Tuesday #39: Managing your SQL Server Services with PowerShell

  http://sqlblog.com/blogs/allen_white/archive/2013/02/12/t-sql-tuesday-39-managing-your-sql-server-services-with-powershell.aspx

     

• Powershell write to Word document

  http://www.sqlserver-dba.com/2013/02/powershell-write-to-word-document.html

     

• Creare un backup di un Azure SQL Database con SQL Server Management Studio

  http://blogs.dotnethell.it/suxstellino/Creare-un-backup-di-un-Azure-SQL-Database-con-SQL-Server-Management-Studio__19049.aspx

  제가 찾고 있던 자료네요. SQL애져 환경에서 백업 및 복원은 어떻게 하는가? ㅎㅎ

     

• Expanding AlwaysOn Availability Groups with Replication Publishers

  http://www.simple-talk.com/sql/database-administration/expanding-alwayson-availability-groups-with-replication-publishers/

     

• T-SQL Tuesday #39: Get Role Members With PowerShell

  http://sqlsalt.com/t-sql-tuesday-39-get-role-members-with-powershell/

     

• Behind the scenes of PowerShell and SQL

  http://sqlblog.com/blogs/rob_farley/archive/2013/02/12/behind-the-scenes-of-powershell-and-sql.aspx

     

• SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 5

  http://blog.sqlauthority.com/2013/02/12/sql-server-an-interesting-case-of-redundant-indexes-index-on-col1-col2-and-index-on-col1-col2-col3-part-5/

     

• XML Support and SQL Server (Part 3)

  http://basitaalishan.com/2013/02/11/xml-support-and-sql-server-part-3/

     

     

ETC        

   

• How Does the Cloud Change a Developer's Job?

  http://sqlblog.com/blogs/buck_woody/archive/2013/02/12/how-does-the-cloud-change-a-developer-s-job.aspx

     

• [입 개발] Cassandra 의 Stage 와 SEDA

  http://charsyam.wordpress.com/2013/02/12/%EC%9E%85-%EA%B0%9C%EB%B0%9C-cassandra-%EC%9D%98-stage-%EC%99%80-seda/

     

• Unexpected problem with triggers and mysqldum

  http://architects.dzone.com/articles/unexpected-problem-triggers

     

• How to Take Advantage of NewSQL in the Cloud

  http://architects.dzone.com/articles/how-take-advantage-newsql