2012.11.19

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

지난 2주간 김장을 했더니 몸이 온몸이 아프네요. 흑흑~~

   

• Using SSIS to Collect Baseline Data for Merge Replication
  http://www.sqlmag.com/content1/topic/sql-server-integration-services-merge-replication-143874/catpath/sql-server/utm_source/feedburner/utm_medium/feed?utm_campaign=feed%3a+sqlmag%2fdbsadmin+(sql%3Earticles%3Edatabase+administration)

     

• Interesting Flash Storage Products From Intel

  http://www.sqlskills.com/blogs/glenn/post/Interesting-Flash-Storage-Products-From-Intel.aspx

     

• Analysis Services - Errors when trying to add a User as a Server Admin

  http://blogs.msdn.com/b/psssql/archive/2012/11/16/analysis-services-errors-when-trying-to-add-a-user-as-a-server-admin.aspx

     

• PASS Summit 2012 Recap & the Milestones of SQL Server 2012

  http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/16/pass-summit-2012-recap.aspx

     

• Windows Azure Virtual Machine: A look at Windows Azure IaaS Offerings (Part 1)

  http://cloud.dzone.com/articles/windows-azure-virtual-machine-0?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+zones%2Farchitects+%28Architects+Zone%29

     

• Faking Hardware NUMA on a SMP Machine for Learning and Demos

  http://www.sqlskills.com/blogs/jonathan/post/Faking-Hardware-NUMA-on-a-SMP-Machine-for-Learning-and-Demos.aspx

     

• Steps to add Log Shipping monitor into an existing SQL Server

  http://www.mssqltips.com/sqlservertip/2799/steps-to-add-log-shipping-monitor-into-an-existing-sql-server/

     

• DBA Best Practices - A Blog Series: Episode 1 - Backups

  http://sqlblog.com/blogs/argenis_fernandez/archive/2012/11/15/dba-best-practices-a-blog-series-episode-1-backups.aspx

     

  DBCC CHECKDB WITH PHYSICALONLY (SQL2008 R2 SP1 CU4+)를 traceflags 2562 and/and Or 2549를 사용하면 물리적인 체크 속도를 향상 가능.(http://support.microsoft.com/kb/2634571)

     

• SQL SERVER – Retrieving Random Rows from Table Using NEWID()

  http://blog.sqlauthority.com/2012/11/16/sql-server-retrieving-random-rows-from-table-using-newid/

  Random 정보를 얻을 때 newid()를 쓰면 유용.

     

• DBCC CHECKDB 실행과 히스토리 관리

  http://sqlmvp.kr/140172840029