MSSQL

• How It Works: CMemThread and Debugging Them

  http://blogs.msdn.com/b/psssql/archive/2012/12/20/how-it-works-cmemthread-and-debugging-them.aspx

• SQL Server Performance Monitoring Tools

  http://www.mssqltips.com/sqlservertip/1067/sql-server-performance-monitoring-tools/

• SQLCLR and sp_OA* procedures are not compatible

  http://blogs.msdn.com/b/psssql/archive/2012/12/20/sqlclr-and-sp-oa-procedures-are-not-compatible.aspx

• Which SQL Server MVP Has Two Thumbs and a Hadoop Certification?

  http://www.brentozar.com/archive/2012/12/which-sql-server-mvp-has-two-thumbs-and-a-hadoop-certification/

• New THROW statement in SQL Server 2012 (vs RAISERROR)

  http://sqlwithmanoj.wordpress.com/2012/12/20/new-throw-statement-in-sql-server-2012-vs-raiserror/

• SQL Server 2012 Cluster with TempDB on Local Disk

  http://www.mssqltips.com/sqlservertip/2817/sql-server-2012-cluster-with-tempdb-on-local-disk/

• SQL SERVER ? Difference Between CURRENT_TIMESTAMP and GETDATE() ? CURRENT_TIMESTAMP Equivalent in SQL Server

  http://blog.sqlauthority.com/2012/12/20/sql-server-difference-between-current_timestamp-and-getdate-current_timestamp-equivalent-in-sql-server/

Update

SQL Server 2008 R2 Service Pack 1 Cumulative Update # 10

• KB Article:  KB #2783135
• 16 fixes are listed at the time of publication
• Build number is 10.50.2868
• Relevant for @@VERSION 10.50.2500 through 10.50.2867

SQL Server 2008 R2 Service Pack 2 Cumulative Update # 4

• KB Article: KB #2777358
• 34 fixes are listed at time of publication
• Build number is 10.50.4270
• Relevant for @@VERSION 10.50.4000 through 10.50.4269

Cumulative Update #5 is available for SQL Server 2012 RTM

• KB Article: KB #2777772
• Build # 11.0.2395
• 28 fixes at the time of writing

MSSQL

• Performance and Stability-Related Fixes in Recent SQL Server 2008 SP3 Cumulative Updates

  http://www.sqlskills.com/blogs/glenn/post/performance-and-stability-related-fixes-in-recent-sql-server-2008-sp3-cumulative-updates.aspx

• Disk and File Layout for SQL Server

  http://blogs.technet.com/b/dataplatforminsider/archive/2012/12/19/disk-and-file-layout-for-sql-server.aspx

     

• Hypothetical Indexes on SQL Server

  http://www.simple-talk.com/sql/database-administration/hypothetical-indexes-on-sql-server/

  가상 인덱스? 유용한 인덱스 여부를 판단하기 위해 테스트 하기 위해 사용하기 위해서는 WITH STATISTICS_ONLY=1로 주시면 됩니다. DTA(Database tunning Advisor)에서도 사용합니다. 가상 인덱스를 사용하기 위해서는 SET AUTOPILOT ON 또는 DBCC AUTOPILOT를 활성화 해줘야 합니다.

  

     

• SQL Server Encryption To Block DBAs Data Access

  http://www.mssqltips.com/sqlservertip/2840/sql-server-encryption-to-block-dbas-data-access/

     

• Database size information - SQL Server
  http://beyondrelational.com/modules/2/blogs/88/Posts/18575/database-size-information-sql-server.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+beyondrelationalmain+%28Technology+stream+from+beyondrelational.com%29

     

• Checking SQL Server Services Owner

  http://www.mssqltips.com/sqlservertip/2823/checking-sql-server-services-owner/

     

• SQL Server 2012 Best Practices Analyzer TempDB Recommendations

  http://www.mssqltips.com/sqlservertip/2833/sql-server-2012-best-practices-analyzer-tempdb-recommendations/
   

• SQL SERVER – Select the Most Optimal Backup Methods for Server
  http://blog.sqlauthority.com/2012/12/18/sql-server-select-the-most-optimal-backup-methods-for-server/

MSSQL

• The DBA's Holiday Checklist

  http://blogs.technet.com/b/dataplatforminsider/archive/2012/12/17/the-dba-s-holiday-checklist.aspx

• Trimming the Transaction Log Fat (By Paul Randal)

  http://www.sqlperformance.com/2012/12/io-subsystem/trimming-t-log-fat

video http://www.youtube.com/watch?v=yTtIqEj_xjE&feature=youtu.be

Source http://www.sqlskills.com/InsiderContent/YouTube/Insider201104-2Code.zip

• "Don't Touch That Button!" Four Dangerous Settings in SQL Server (video)

  http://www.brentozar.com/archive/2012/12/dont-touch-that-button-four-dangerous-settings-in-sql-server-video/

     

  절대 세팅하지 말것!

  

     

  

     

  

     

  

     

  

     

• Logon Triggers Can Stop SQL Agent From Starting

  http://shaunjstuart.com/archive/2012/12/logon-triggers-can-stop-sql-agent-from-starting-2/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+ShaunJStuart+%28Shaun+J+Stuart+-+SQL+Server+DBA%29

  로그온 트리거로 인한 SQLAgent가 시작할 수 없을 수도 있다. 이때는 시작 타입을 지연된 시작으로 설정한다.

  

MSSQL

• How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)

  http://blogs.msdn.com/b/psssql/archive/2012/12/13/how-it-works-sql-server-numa-local-foreign-and-away-memory-blocks.aspx
  민석형님이 봐주시면 좋을 듯?
   

• SQL Server Quickie #5 – Bookmark Lookup Deadlocks

  http://www.sqlpassion.at/blog/PermaLink,guid,0536d65c-1f3b-41ec-b309-297c100eb951.aspx

  산타모자 쓰시고 나와서 데드락 설명을 하시네요 발음이~

     

• Azure SQL Database Import/Export Service - Change always brings both challenges and benefits

  http://blogs.msdn.com/b/psssql/archive/2012/12/14/azure-sql-database-import-export-service-change-always-brings-both-challenges-and-benefits.aspx

     

• Instant Index Insight: How to Use sp_BlitzIndex (video)

  http://www.brentozar.com/archive/2012/12/instant-index-insight-how-to-use-sp_blitzindex-video/

  sp_BlitzIndex 괜찮은 스크립트인것 같아요. 개인적으로 그랜 아저씨 스크립트가 더 환상적이라고 생각됩니다. 이 스크립트를 사용하는 방법 동영상입니다.

     

• #0221 - SQL Server - SSMS - Database Properties - Number of Users value

  http://beyondrelational.com/modules/2/blogs/77/Posts/18553/0221-sql-server-ssms-database-properties-number-of-users-value.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+beyondrelationalmain+%28Technology+stream+from+beyondrelational.com%29

     

• Querying SQL Server Agent Job History Data

  http://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/

     

• SQL Server SP_Congifure 변경 사항 캡처

  http://sqlmvp.kr/140175032346

     

MySQL

• Full table scan vs full index scan performance

  http://architects.dzone.com/articles/full-table-scan-vs-full-index?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+zones%2Farchitects+%28Architects+Zone%29

http://www.mysqlperformanceblog.com/2012/12/14/the-optimization-that-often-isnt-index-merge-intersection/

MSSQL

• New Version Of SP_Blitz With Some Contributions From Me

  http://shaunjstuart.com/archive/2012/12/new-version-of-sp_blitz-with-some-contributions-from-me/

• sp_Blitz v16: Snapshots, Recompiles, ShrinkDB, and More

  http://www.brentozar.com/archive/2012/12/sp_blitz-v16-snapshots-recompiles-shrinkdb-and-more/

• Logical function ? Choose ? SQL Server 2012

  http://sqldbpool.com/2012/12/13/logical-function-choose-sql-server-2012/

• SQL Server Clustering Myths

  http://www.mssqltips.com/sqlservertip/2837/sql-server-clustering-myths/

• VM-ware Shared folders are really Slow

  http://blog.kejser.org/2012/12/12/vm-ware-shared-folders-are-really-slow/

MSSQL
 

• How To Return Document Property Values in Full-Text Search

  http://www.sqlskills.com/blogs/bobb/post/returning-document-property-values-in-full-text-seach.aspx

• Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats

  http://www.sqlskills.com/blogs/joe/post/detecting-cardinality-estimate-issues-with-sysdm_exec_query_stats.aspx

• The Least Expensive SQL Server 2012 High Availability Solution

  http://itknowledgeexchange.techtarget.com/sql-server/the-least-expensive-sql-server-2012-high-availability-solution/

• SQL Server 2012 Service Pack 1 & Cumulative Update 1

  http://www.sqlperformance.com/2012/12/system-configuration/sql-2012-slipstream

  SQL2012 버젼에서 slipstream install에 대한 방법.

• Is the SAN dying???

  http://sqlblog.com/blogs/rick_heiges/archive/2012/12/11/is-the-san-dying.aspx

MSSQL

• How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!
  http://blogs.msdn.com/b/psssql/archive/2012/12/11/how-it-works-sql-server-32-bit-pae-awe-on-sql-2005-2008-and-2008-r2-not-using-as-much-ram-as-expected.aspx

     

• SQL Server 2012 security: Changes for the newest version

  http://searchsqlserver.techtarget.com/feature/SQL-Server-2012-security-Changes-for-the-newest-version

     

• How Fast is Project Codenamed "Hekaton" – It's 'Wicked Fast'!
  http://blogs.technet.com/b/dataplatforminsider/archive/2012/12/11/how-fast-is-project-codenamed-hekaton-it-s-wicked-fast.aspx

  Hekaton에 대한 소개 영상입니다. 온라인게임을 위한 single point에 대한 빠른 성능을 보여준다는 내용이네요. 초당 250,000얼 헉.. 엄청난 속도이네요. 울 게임 프젝이 나오기 전에 나와야 할 텐데. 기존 nosql 진영의 redis와 memcacheDB를 안 써도 되고 괜찮네요.

     

• Thinking about the inaccurate_cardinality_estimate Event

  http://www.sqlskills.com/blogs/joe/post/thinking-about-the-inaccurate_cardinality_estimate-event.aspx

  확장이벤트의 SQL2012에서 추가된 inaccurate_cardinality_estimate에 대한 자료입니다. 확장이벤트를 사용하는 이유가 아시다시피 실행시 실제 실행계획 및 통계 정보를 추출하지 못한다는 문제이겠지요. 캡쳐 가능한 방법이 프로파일러에서 Showplan XML Statistics Profile Or Showplan Statistics Profile로 가능하겠지만 상당한 비용이 들지요. 이를 가능하게 해주는 inaccurate_cardinality_estimate 이벤트입니다.

     

• Whither Hadoop?
  http://www.brentozar.com/archive/2012/12/whither-hadoop/

     

• Windows Server 2012 환경에서 SQL Server 2008 R2 장애 조치 클러스터 규칙 단계 오류

  http://laigo.kr/733

     

• Handling Deadlocked Schedulers is a piece of cake now

  http://troubleshootingsql.com/2012/12/11/handling-deadlocked-schedulers-is-a-piece-of-cake-now/

     

• Reporting Services Disaster Recovery

  http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69699/

MSSQL

• TRANSACTION_MUTEX and Multi-Session Transaction Access

  http://www.sqlperformance.com/2012/12/t-sql-queries/transaction-mutex
  재미난 시스템 SP들입니다. 트랜잭션을 따른 세션에서 공유할 수 있게 해주네요.

  

     

  

     

• Joins in single-table queries

  http://sqlblog.com/blogs/rob_farley/archive/2012/12/11/joins-in-single-table-queries.aspx

     

• SQL Server 2012 도움말 설치

  http://sqlmvp.kr/140174756411

     

• Editing sqlcmdvariable nodes in SSDT Publish Profile files using msbuild

  http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/10/editing-sqlcmdvariable-nodes-in-ssdt-publish-profile-files-using-msbuild.aspx

     

• sp_Blitz v14 Adds VLFs, DBCC, Failsafe Operators, and More

  http://www.brentozar.com/archive/2012/12/sp_blitz-v14-adds-vlfs-dbcc-failsafe-operators-and-more/

     

• Query for server DefaultData & DefaultLog folders

  http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/10/query-for-server-defaultdata-defaultlog-folders.aspx

     

• How to add database file to a Log Shipped database in SQL Server

  http://www.mssqltips.com/sqlservertip/2824/how-to-add-database-file-to-a-log-shipped-database-in-sql-server/

MSSQL

• MERGE Bug with Filtered Indexes
  http://sqlblog.com/blogs/paul_white/archive/2012/12/10/merge-bug-with-filtered-indexes.aspx

     

• SQL Authority News – Download SQL Server Data Type Conversion Chart
  http://blog.sqlauthority.com/2012/12/09/sql-authority-news-download-sql-server-data-type-conversion-chart/

     

• Microsoft and Hadoop – Windows Azure HDInsight

  http://architects.dzone.com/articles/microsoft-and-hadoop-%E2%80%93-windows?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+zones%2Farchitects+%28Architects+Zone%29

     

• Exploring Column Correlation and Cardinality Estimates

  http://www.sqlskills.com/blogs/joe/post/exploring-column-correlation-and-cardinality-estimates.aspx

  흥미로운 이슈입니다. 자동 통계 생성에 대한 문제점을 소개하는 내용. AUTO_CREATE_STATISTICS Option은 쿼리 옵티마이져가 개별화된 컬럼을 예측으로 기반으로 해서 통계 정보를 생성합니다.
   

• SQL Server Backup Questions We Were Too Shy to Ask

  http://www.simple-talk.com/sql/database-administration/sql-server-backup-questions-we-were-too-shy-to-ask/

  백업 및 복원 관련 이슈들 정리. 특히 복원 필요 없이 백업 파일을 가지고 script를 뽑을 수 있는 기능이 재미있네요.

     

• The current state of a MERGE Destination for SSIS

  http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/07/the-current-state-of-a-merge-destination-for-ssis.aspx

     

• Database Deployment: The Bits - Copying Data Out
  http://www.simple-talk.com/sql/t-sql-programming/database-deployment-the-bits---copying-data-out/

     

• SQL Server 2012 Setup just got smarter…
  http://blogs.msdn.com/b/psssql/archive/2012/12/06/sql-server-2012-setup-just-got-smarter.aspx

     

     

• Exploring Column Correlation and Cardinality Estimates

MSSQL

• Performance Related Fixes in Post-SQL Server 2008 R2 Service Pack 1 Builds
  http://www.sqlskills.com/blogs/glenn/post/performance-related-fixes-in-post-sql-server-2008-r2-service-pack-1-builds.aspx

     

• The Perfect Combination: SQL Server 2012, Windows Server 2012 and System Center 2012

  http://blogs.technet.com/b/dataplatforminsider/archive/2012/12/06/the-perfect-combination-sql-server-2012-windows-server-2012-and-system-center-2012.aspx

     

• SQL Server Management Studio: "Include Client Statistics" Button
  http://www.brentozar.com/archive/2012/12/sql-server-management-studio-include-client-statistics-button/
   
• The perils of double-dash comments [T-SQL]
  http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/06/the-perils-of-double-dash-comments-t-sql.aspx
   
• T-SQL 코드 가이드 라인
  http://www.slideshare.net/chris1adkin/t-sql-coding-guidelines
   
• Dynamic PIVOT CLR
  http://www.sqlservercentral.com/articles/.Net/94922/