2013.03.20

   

Update

   

• SQL Server 2012 Service Pack 1 Cumulative Update #3

  Build # 11.0.3349

  KB Article: KB #2812412 http://support.microsoft.com/kb/2812412

  38 fixes!

  Relevant for builds 11.0.3000 -> 11.0.3348

  NOT for SQL Server 2012 RTM (11.0.2100 -> 11.0.2999)

   

• SQL Server 2008 Service Pack 3 Cumulative Update #10

  Build # 10.00.5835

  KB Article: KB #2814783 http://support.microsoft.com/kb/2814783

  8 fixes

  Relevant for builds 10.00.5500 -> 10.00.5834

  NOT for SQL Server 2008 R2 (10.50.xxxx)

   

SQL

   

• Data Collector Clustering Woes

  http://spaghettidba.com/2013/03/19/data-collector-clustering-woes/

     

• SQL Server 2012: Indirect Checkpoint (Target Recovery Time), get the real scoop

  http://blog.sqlworkshops.com/index.php/sql-server-2012-indirect-checkpoint-target-recovery-time-get-the-real-scoop/

  Meyyappan님이 오랜만에 올리시는 내용이네요.. 민석형 한번 해석좀 ㅠㅠ

     

• SQL Server 2012 partitioned table statistics update behavior change when rebuilding index

  http://blogs.msdn.com/b/psssql/archive/2013/03/19/sql-server-2012-partitioned-table-statistics-update-behavior-change-when-rebuilding-index.aspx

  SQL2012에서 변경된 사항이 존재하네요... 파티션드 테이블일 경우 인덱스 리빌드는 기본 샘플링 비율로 통계를 갱신하네요. 만약 full scan을 원하면 update statistics with fullscan을 해줘야 한데요.

     

• SLIDES FROM RENO SQL SERVER USER GROUP AVAILABLE

  http://thomaslarock.com/2013/03/slides-from-reno-sql-server-user-group-available

     

• DataFileType will be assumed to be widechar because the data file has a Unicode signature

  http://www.sqlserver-dba.com/2013/03/datafiletype-will-be-assumed-to-be-widechar-because-the-data-file-has-a-unicode-signature.html

     

• Extended Events did it again: monitoring Stored Procedures performance

  http://sqlblog.com/blogs/davide_mauri/archive/2013/03/19/extended-events-did-it-again-monitoring-stored-procedures-performance.aspx

  XEVENT으로 특정 SP 성능 측정을 할 수 있네요.

     

• SQL Server DMV: sys.dm_exec_requests

  http://basitaalishan.com/2013/03/19/sql-server-dmv-sys-dm_exec_requests/

     

• Is Microsoft SQL Server Supported By ...?

  http://sqlblog.com/blogs/kevin_kline/archive/2013/03/19/is-microsoft-sql-server-supported-by.aspx

     

• SQL Server 2000 Extended Support ending soon………21 days left

  http://beyondrelational.com/modules/24/syndicated/992/Posts/19167/sql-server-2000-extended-support-ending-soon21-days-left.aspx

  잘가~ SQL2000아 ㅠㅠ 그동안 즐거웠다...

     

• Using sys.dm_db_index_operational_stats to analyse how indexes are utilised

  http://beyondrelational.com/modules/24/syndicated/680/Posts/19168/using-sysdmdbindexoperationalstats-to-analyse-how-indexes-are-utilised.aspx

     

• SQL Server : Index Part 3 :Explaining the Clustered Table Structure

  http://beyondrelational.com/modules/24/syndicated/535/Posts/19176/sql-server-index-part-3-explaining-the-clustered-table-structure.aspx

     

• SQL Server : Part 4 :Explaining the Non Clustered Index Structure

  http://beyondrelational.com/modules/24/syndicated/535/Posts/19175/sql-server-part-4-explaining-the-non-clustered-index-structure.aspx

     

• SQL Server : Part 5 : Explaining Non clustered Index on Heap

  http://beyondrelational.com/modules/24/syndicated/535/Posts/19178/sql-server-part-5-explaining-non-clustered-index-on-heap.aspx

     

• Full Text Searches on Documents in FileTables

  https://www.simple-talk.com/sql/database-administration/full-text-searches-on-documents-in-filetables

     

• The Bit Bucket (Greg Low): IDisposable

  http://sqlblog.com/blogs/greg_low/archive/2013/03/19/whitepaper-editing-sigh.aspx

     

• Importing and Processing data from XML files into SQL Server tables

  http://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/

     

     

기타

   

• MongoDB 2.4 has been released

  http://data.story.lu/2013/03/19/mongodb-2-4-has-been-released        

  http://css.dzone.com/articles/mongodb-24-out

  아직 collection level 동기화 릴리지를 못하고 있네요.

     

• Windows Azure HDInsight – Hadoop

  http://redju.tistory.com/286

  HDInsight는 100% Apache Hadoop 솔루션을 클라우드에 가져오는 Microsoft의 Hadoop 기반 서비스입니다.