2012.11.08

안녕하세요. 주디아줌마입니다.
2012.11.08 SQL 관련 자료입니다.

   

• SQL Server 2012 Sp1 Is Now Available
  http://blogs.msdn.com/b/sqlreleaseservices/archive/2012/11/07/sql-server-2012-sp1-is-now-available.aspx
  http://msdn.microsoft.com/en-us/library/bb500435

     

  SP1 추가 또는 개선된 기능

  • Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade
  • Selective XML Index
  • DBCC SHOW_STATISTICS works with SELECT permission
  • New function returns statistics properties
  • SSMS Complete in Express
  • SlipStream Full Installation
  • Business Intelligence highlights (with SQL Server 2012 SP1, Office and SharePoint Server 2013 )
  • Management Object Support Added for Resource Governor DDL

     

• Distributed Query Plan Quality and SQL Server 2012 SP1

  http://www.sqlskills.com/blogs/joe/post/Distributed-Query-Plan-Quality-and-SQL-Server-2012-SP1.aspx

  Flag 9485 - Users have SELECT permissions on all columns in the statistics object.. Users have SELECT permissions on all columns in a filter condition if the filter exis

     

• SQLPASS Summit Keynote Liveblog – Day 1

  http://www.brentozar.com/archive/2012/11/sqlpass-summit-keynote-liveblog-day-1/
  요즘 SQLPASS 기간중이군요^^ Brent Ozar분이 Keynote 정보를 올려주셨습니다. 같이 느껴보아요.

     

• How to save deadlock graph events as .xdl file in SQL Server ?

  http://mssqlfun.com/2012/11/07/how-to-save-deadlock-graph-events-as-xdl-file-in-sql-server/

  데드락 그래프 .xdl 파일 저장하는 방법. 나중에 팁으로 올려 놓을께요~

     

• Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model

  http://www.sqlservercentral.com/articles/Stairway+Series/94552/

  Bulk_logged 복구 모델의 로그 관리. 최소로깅의 의미. 최소로그에 따른 이점과 로그 공간 사용에 대한 정보, Bulk_logged recovery 사용을 위한 최고 전략 등등 볼수 있습니다.

     

  현, database의 로그 정보를 확인하는 Query.

  

     

• Dynamically Add Tables in SSIS Source Queries

  http://www.sql-server-performance.com/2012/dynamically-add-tables-ssis-source-queries/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+SQLServerPerformance+%28Latest+SQL-Server-Performance.com+Updates%29

     

• Introducing sp_ssiscatalog (v1.0.0.0)

  http://sqlblog.com/blogs/jamie_thomson/archive/2012/11/07/introducing-sp-ssiscatalog-v1-0-0-0.aspx