SQL

• Clarification of Microsoft's SQL Server 2012 Servicing and Support Policy - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/clarification-of-microsofts-sql-server-2012-servicing-and-support-policy/

     

• Squishy Limits in SQL Server Express Edition

  http://sqlblog.com/blogs/kevin_kline/archive/2013/03/28/squishy-limits-in-sql-server-express-edition.aspx

  Express 버젼 사용하시는 분들이 봐두시면 좋겟네요^^. db마다 10G 저장용량 제한, 메모리 1G 제한이지만(메모리 1기가 제한이 딱 데이터버퍼만 이야기 한다 플랜캐시나 다른 데이터 영역은 제한하지 않았으니 1기가 보다 더 쓸수 있다.)

     

• Making the Case for Regular SQL Server Servicing

  http://www.sqlperformance.com/2013/03/system-configuration/sql-server-servicing

     

• Conditional aggregation - SUM Vs COUNT

  http://beyondrelational.com/modules/2/blogs/70/posts/19240/conditional-aggregation-sum-vs-count.aspx

     

• Re-throw Errors with Logging

  http://www.sqlservercentral.com/articles/Error+Handling/97007/

     

• Ad-Hoc XML File Querying

  https://www.simple-talk.com/sql/database-administration/ad-hoc-xml-file-querying/

     

• Using Event Viewer Logging for SSIS Performance Trouble Shooting

  http://itknowledgeexchange.techtarget.com/sql-server/using-event-viewer-logging-for-ssis-performance-trouble-shooting/

     

• Comparison of Queries Written in T-SQL and SQL Server MDX

  http://www.mssqltips.com/sqlservertip/2916/comparison-of-queries-written-in-tsql-and-sql-server-mdx/

     

     

기타

• Simple JSON Encode/Decode in Pure Lua        

  http://regex.info/blog/lua/json

     

• [MongoDB] Deployment Best Practices: Monitor your resources

  http://blog.mongodb.org/post/46504096409/deployment-best-practices-monitor-your-resources

     

• 충격 고로케 개발! 알고보니..

  http://readme.skplanet.co.kr/?p=4338

SQL

• Recommended reading from mrdenny for March 22, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-march-22-2013-3/

     

• Memory objects allocated by SQL Server

  http://www.sqlserver-dba.com/2013/03/memory-objects-allocated-by-sql-server.html

     

• Saving Session State (video)

  http://www.brentozar.com/archive/2013/03/saving-session-state-video/

     

• HASHBYTES: Is CHECKSUM really required?

  http://www.sqlservercentral.com/articles/T-SQL/95932/

     

• SQL Server 2012 Integration Services - PowerShell-Based Project Deployment

  http://www.databasejournal.com/features/mssql/ssis-2012-powershell-based-project-deployment.html

     

• Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell

  http://www.mssqltips.com/sqlservertip/2909/configure-sql-server-2012-alwayson-availability-groups-readonly-routing-using-powershell/

     

기타

• Why MySQL Performance at Low Concurrency is Important

  http://www.mysqlperformanceblog.com/2013/03/27/why-mysql-performance-at-low-concurrency-is-important/        

• MongoDB 2.4 Javascript Changes

  http://blog.mongodb.org/post/46419580374/mongodb-2-4-javascript-changes

     

• Freemium 전략에 대한 고민

  http://www.mimul.com/pebble/default/2013/03/27/1364369991640.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+Smartmob+%28Mimul%27s+Developer+World%29

SQL

• DBCC CHECKDB Execution Memory Grants – Not Quite What You Expect - Jonathan Kehayias

  http://www.sqlskills.com/blogs/jonathan/dbcc-checkdb-execution-memory-grants-not-quite-what-you-expect/

• But what can I *do* with Windows Azure? Backups

  http://sqlblog.com/blogs/buck_woody/archive/2013/03/26/but-what-can-i-do-with-windows-azure-backups.aspx

• UPGRADING TO SQL 2012: TEN THINGS YOU DON'T WANT TO MISS

  http://thomaslarock.com/2013/03/upgrading-to-sql-2012-ten-things-you-dont-want-to-miss

  SQL2012 업그레이드 할 때 봐야할 것 들이네요.

     

• LandsofAmerica.com – Elastic Data Warehouse – A Case Study

  http://www.brentozar.com/archive/2013/03/landsofamerica-com-elastic-data-warehouse/

     

• Skip distributor agent error in sql server transactional replication - How to

  http://beyondrelational.com/modules/2/blogs/88/Posts/19093/skip-distributor-agent-error-in-sql-server-transactional-replication-how-to.aspx

• Data Mining SQLIO Results

  http://www.sqlservercentral.com/articles/SQLIO/97011/

     

• SQL Server's Auto Update Statistics Async option

  http://www.mssqltips.com/sqlservertip/2904/sql-servers-auto-update-statistics-async-option/

     

• How to Identify and Fix Incorrect SQL Server Operator Settings

  http://www.mssqltips.com/sqlservertip/2908/how-to-identify-and-fix-incorrect-sql-server-operator-settings/

     

• How to use SQL Server to query an external XML file

  http://www.mssqltips.com/sqlservertip/2918/how-to-use-sql-server-to-query-an-external-xml-file/

     

• BI Beginner: Data Explorer is a must have

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/03/25/bi-beginner-data-explorer-is-a-must-have.aspx

     

     

기타

• 구루의 기술뉴스 : 구글 생산성의 비밀 Snippets 외 32건

  http://xguru.net/1253?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+xguru+%28Guru%27s+Blog%29

     

• CEO는 편집장이다 – 모든 작은 디테일 하나에도 완벽을 기하되, 디테일의 개수를 제한해라

  http://xguru.net/1237?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+xguru+%28Guru%27s+Blog%29

Update

KB Article For CU10 of SQL Server 2008 SP3

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

SQL

• What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores/

• DBCC CHECKDB performance and computed-column indexes - Paul S. Randal

  http://www.sqlskills.com/blogs/paul/dbcc-checkdb-performance-and-computed-column-indexes/

     

• Recommended reading from mrdenny for March 22, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-march-22-2013-2/

     

• Solving Complex T-SQL Problems, Step-By-Step

  https://www.simple-talk.com/sql/t-sql-programming/solving-complex-t-sql-problems,-step-by-step/

     

• An Orders of Magnitude Problem (T-SQL Tuning)

  http://www.sqlservercentral.com/articles/Performance+Tuning/97355/

     

• Azure SQL Database Maintenance

  https://www.simple-talk.com/cloud/cloud-data/azure-sql-database-maintenance/

     

• Using SQL Server Management Objects with PowerShell

  http://www.sqlmag.com/article/windows-powershell/sql-server-managment-objects-powershell-144832

     

• Error 18456 - State 5 - SQL Login Failed

  http://www.sqlserver-dba.com/2013/03/error-18456-state-5-.html

     

• LAST WEEKS TOP "READING" LINKS #25

  http://www.jasonstrate.com/2013/03/last-weeks-top-reading-links-25

     

• Impact of the query_post_execution_showplan Extended Event in SQL Server 2012

  http://www.sqlperformance.com/2013/03/sql-plan/showplan-impact

  XEVENT로 성능에 대한 플랜을 뽑을 때에는 조심해야겟어욤.

     

• SQL Server 2008R2 / 2012 Standard & Backup Compression

  http://sqlblog.com/blogs/davide_mauri/archive/2013/03/25/sql-server-2008r2-2012-standard-backup-compression.aspx

  SQL2012도 압축 백업 지원되네요^^ BOL 문서 Bug가 있었네.ㅋㅋ

• Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks

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

     

• Storage Performance - Joe Chang

  http://sqlblog.com/blogs/joe_chang/archive/2013/03/25/storage-performance.aspx

  DB 스토리지에 대해 정말 잘 정리해 두두셨네요. 와우~~ DBA라면 잘 봐두심이 좋을 듯... 오늘은 이거나 파볼까..ㅠㅠㅠ

     

• Improving SQL Server Analysis Services Query Response Time with msmdsrv

  http://www.mssqltips.com/sqlservertip/2886/improving-sql-server-analysis-services-query-response-time-with-msmdsrv/

     

• Day 31 of 31 Days of Disaster Recovery: Backup and Restore of the Resource Database

  http://www.sqlsoldier.com/wp/sqlserver/day31of31daysofdisasterrecoverybackupandrestoreoftheresourcedatabase

  시리즈가 마무리 되었네요. 장애 복구 관련 정리 잘 되어 있어요.

     

• Diagnosing differences between production and development

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/03/24/diagnosing-differences-between-production-and-development.aspx

     

기타

• 안전한 패스워드 저장

  http://helloworld.naver.com/helloworld/textyle/318732        

     

• Data Science Laboratory System - Instrumentation

  https://www.simple-talk.com/cloud/data-science/data-science-laboratory-system---instrumentation

  슬슬 공부나 해볼까~~

     

• 자바 개발자 컨퍼런스에 참가한 신입매니저들의 후기! 들어보세요~

  http://readme.skplanet.co.kr/?p=4307

SQL

• CPUID PerfMonitor 2 Utility - Grenn

  http://www.sqlskills.com/blogs/glenn/cpuid-perfmonitor-2-utility/

• How to Reclaim Disk Space in your Windows\winsxs directory on Windows Server 2008 R2 SP1 - Grenn

  http://www.sqlskills.com/blogs/glenn/how-to-reclaim-disk-space-in-your-windowswinsxs-directory-on-windows-server-2008-r2-sp1/

     

• Slide 1 - T-SQL Rediscovered with SQL Server 2012

  http://beyondrelational.com/modules/29/presentations/483/slides/19200/slide-1-t-sql-rediscovered-with-sql-server-2012.aspx

• Recommended reading from mrdenny for March 22, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-march-22-2013/

     

• Using FileTable in SQL Server 2012

  http://beyondrelational.com/modules/24/syndicated/391/Posts/19198/using-filetable-in-sql-server-2012.aspx

     

• SSIS 2012 Deep Dive presentation

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/03/22/ssis-2012-deep-dive-presentation.aspx

     

• Moving system databases to the default data and log paths

  http://spaghettidba.com/2013/03/22/move-system-databases-to-the-default-data-and-log-paths/

     

• Sp_updatestats RESAMPLE option

  http://www.sqlserver-dba.com/2013/03/sp_updatestats-resample-option.html

     

• SQL Server : Part 6 : Design consideration of Clustered Index

  http://beyondrelational.com/modules/24/syndicated/535/Posts/19194/sql-server-part-6-design-consideration-of-clustered-index.aspx

     

• An Introduction to SQL Server IO for Developers (video)

  http://www.brentozar.com/archive/2013/03/an-introduction-to-sql-server-io-for-developers-video/

     

• SQL Server Case Sensitive Collations and DMVs

  http://www.mssqltips.com/sqlservertip/2913/sql-server-case-sensitive-collations-and-dmvs/

     

• SQL SERVER – Fix – Error: 1060 The number of rows provided for a TOP or FETCH clauses row count parameter must be an integer

  http://blog.sqlauthority.com/2013/03/22/sql-server-fix-error-1060-the-number-of-rows-provided-for-a-top-or-fetch-clauses-row-count-parameter-must-be-an-integer/

     

• Corruption case

  http://sqlblog.com/blogs/michael_zilberstein/archive/2013/03/22/48339.aspx

  재미있는 case이네요 "A time-out occurred while waiting for buffer latch" 시작 옵션 661으로 서비스 올려서 체크하면 되네요^^

  Express Edition doesn't support DAC에서는 사용할 수 없군요?

     

     

기타

• Amazon 클라우드에서 S3 Read/Write 성능 높이는 방법 - 같은 Region 사용하기

  http://bcho.tistory.com/731        

     

• [입 개발] Redis Tips

  http://charsyam.wordpress.com/2013/03/22/%EC%9E%85-%EA%B0%9C%EB%B0%9C-redis-tips/

  레디스를 쓰기 위해서는 공부를 좀 더해야겟네요.^^

     

• System Center Advisor is now free

  http://blogs.msdn.com/b/psssql/archive/2013/03/20/system-center-advisor-is-now-free.aspx

SQL

• Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection.-SQL Server SSIS

  http://beyondrelational.com/modules/2/blogs/88/Posts/19188/failed-to-acquire-connection-connection-may-not-be-configured-correctly-or-you-may-not-have-the-righ.aspx

     

• Which LOB pages are associated with a specific columnstore segment?

  http://www.sqlskills.com/blogs/joe/which-lob-pages-are-associated-with-a-segment/

• A SECOND MARCH 'INDEX ANALYSIS' UPDATE

  http://www.jasonstrate.com/2013/03/a-second-march-index-analysis-update        

     

• Log Shipping FAQ

  http://www.brentozar.com/archive/2013/03/log-shipping-faq/

     

• Considerations when starting a new SSDT database project - SSIS Junkie

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/03/21/considerations-when-starting-a-new-ssdt-database-project.aspx

     

• SQLServerCentral Runs sp_Blitz - Performance Part 2

  http://www.sqlservercentral.com/articles/SQLServerCentral/96158/

     

• SQL SERVER – Identify Last User Access of Table using T-SQL Script

  http://blog.sqlauthority.com/2013/03/21/sql-server-identify-last-user-access-of-table-using-t-sql-script/

     

• SQL Server Login Management using LOGINPROPERTY function

  http://www.mssqltips.com/sqlservertip/2906/sql-server-login-management-using-loginproperty-function/

  보안 관련 검토할 때 유용할 것 같네요

SQL

• Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth

  https://www.simple-talk.com/sql/database-administration/managing-the-sql-server-transaction-log-dealing-with-explosive-log-growth/

     

• System Center Advisor is now free

  http://blogs.msdn.com/b/psssql/archive/2013/03/20/system-center-advisor-is-now-free.aspx

     

• The Problem with Window Functions and Views

  http://www.sqlperformance.com/2013/03/t-sql-queries/the-problem-with-window-functions-and-views

• The Power of the SQL Server Database Owner

  http://www.mssqltips.com/sqlservertip/2907/the-power-of-the-sql-server-database-owner/

     

기타

Amazon 클라우드에서 S3 Read/Write 성능 높이는 방법-Partitioning        

http://bcho.tistory.com/730

>> 파일명을 가지고 hashing을 하여 파일을 분산 저장

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 기반 서비스입니다.

SQL

• implicit data type conversion and COALESCE

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/03/17/implicit-data-type-conversion-and-coalesce.aspx

     

• Trapping SQL Server Errors with Extended Events

  http://sqlblog.com/blogs/davide_mauri/archive/2013/03/17/trapping-sql-server-errors-with-extended-events.aspx

  SQL 서버 에러 수집할 수 있네요.

     

• Adding/Modifying files and filegroup in Database - SQL Server

  http://beyondrelational.com/modules/2/blogs/88/Posts/19159/addingmodifying-files-and-filegroup-in-database-sql-server.aspx

     

• Recommended reading from mrdenny for March 15, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-march-15-2013

     

• SSIS: How to validate Flat File Row Length?

  http://beyondrelational.com/modules/24/syndicated/398/Posts/19157/ssis-how-to-validate-flat-file-row-length.aspx

     

• Whitepaper: Plan Caching and Recompilations in SQL Server 2012

  http://sqlblog.com/blogs/greg_low/archive/2013/03/16/whitepaper-plan-caching-and-recompilations-in-sql-server-2012.aspx

  다운로드 위치 : http://msdn.microsoft.com/en-us/library/dn148262.aspx

  와우~ 오랜만에 하얀 책이 나왔네여zzz 44page 정도 됩니다.^^

     

기타

• 구글은 왜 구글 리더를 죽였는가?        

  http://www.mimul.com/pebble/default/2013/03/17/1363530979973.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+Smartmob+%28Mimul%27s+Developer+World%29

  심히 마음이 아프네요 ㅠㅠ... 구글리더..

     

• 에버노트에 쓰여져 있던 빅데이터(Big Data) 에 대한 단상…

  http://kimws.wordpress.com/2013/03/17/%EB%B9%85%EB%8D%B0%EC%9D%B4%ED%84%B0big-data-%EC%97%90-%EB%8C%80%ED%95%9C-%EB%A9%94%EB%AA%A8/

     

• MongoDB's growing ecosystem

  http://blog.10gen.com/post/45270275688/mongodbs-growing-ecosystem

     

• [Redis] Lua scripting in Redis: Links to useful ressources

  http://grokbase.com/t/gg/redis-db/133fhz84tp/lua-scripting-in-redis-links-to-useful-ressources

  레디스 하시는분들 루아를 좀 봐두셔야겠져? ㅠㅠ

     

  * http://evalsha.com

  * http://sunilarora.org/redis-lua-scripting

  * https://github.com/nrk/redis-lua

  * https://github.com/andyet/redis-lua-example/tree/master/models/scripts

  * https://github.com/dcartoon/redis-lua-scripts

     

• 네트워크 트래픽 분석 기술, NetFlow 소개와 활용

  http://helloworld.naver.com/helloworld/textyle/310727

SQL

• Navistar Uses Microsoft Big Data Solution to Determine Optimal Pricing Structure

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/03/14/navistar-uses-microsoft-big-data-solution-to-determine-optimal-pricing-structure.aspx

     

• Index Tuning        

  http://sqlserver365.blogspot.kr/2013/03/index-tuning.html

     

• Database stuck RESTORING

  http://www.sqlserver-dba.com/2013/03/database-stuck-restoring.html

     

• Introduction to Hive Partitioning

  http://www.brentozar.com/archive/2013/03/introduction-to-hive-partitioning/

     

• Find missing indexes using SQL Servers index related DMVs

  http://beyondrelational.com/modules/24/syndicated/680/Posts/19142/find-missing-indexes-using-sql-servers-index-related-dmvs.aspx

     

기타

• [Redis] How does Redis release memory?

  http://grokbase.com/t/gg/redis-db/133e1hjk08/how-does-redis-release-memory

     

• MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

  http://www.mysqlperformanceblog.com/2013/03/14/mysql-5-6-10-optimizer-limitations-index-condition-pushdown/