SQL

• A SQL Server Hardware Tidbit a Day – Day 3 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/a-sql-server-hardware-tidbit-a-day-day-3

     

• How to Find Out About the Latest SQL Server Service Packs and Cumulative Updates - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/how-to-find-out-about-the-latest-sql-server-service-packs-and-cumulative-updates

• DBCC CHECKDB scalability and performance benchmarking on SSDs - Paul S. Randal

  http://www.sqlskills.com/blogs/paul/dbcc-checkdb-scalability-and-performance-benchmarking-on-ssds        

     

• How Many SQL Server ERRORLOG Files Do I Keep?

  http://itknowledgeexchange.techtarget.com/sql-server/how-many-sql-server-errorlog-files-do-i-keep/

     

• Manage Transaction Logs during Index Rebuild

  http://www.sqlserver-dba.com/2013/04/manage-transaction-logs-during-index-rebuild.html

     

• [Video] Bad SQL Server Advice for DBAs

  http://www.brentozar.com/archive/2013/04/video-bad-sql-server-advice-for-dbas/

     

• My first month as DBA – The right tools for the job        

  http://devjef.wordpress.com/2013/04/03/my-first-month-as-dba-the-right-tools-for-the-job/

  DB 쟁이들을 위한 툴들 소개인데 SSMSBoost툴 쥑이네 ㅎㅎㅎ

     

• SSDT naming confusion cleared up. Somewhat.

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/04/03/ssdt-naming-confusion-cleared-up-somewhat.aspx

     

• A Hazard of Using the SQL Merge Statement

  http://www.sqlservercentral.com/articles/MERGE/97867/

  NOT MATCHED BY SOURCE 문제점이 있네요.

     

• Configure the Flat File Source in SQL Server Integration Services 2012 to read CSV files

  http://www.mssqltips.com/sqlservertip/2923/configure-the-flat-file-source-in-sql-server-integration-services-2012-to-read-csv-files/

     

• A Journey from OLTP to OLAP

  http://www.sql-server-performance.com/2013/from-oltp-to-olap

SQL

• SQL Backup and Restore to UNC

  http://www.sqlserver-dba.com/2013/03/sql-backup-and-restore-to-unc.html

     

• The Case of Anti-Virus filter drive interference with File Stream Restore

  http://blogs.msdn.com/b/psssql/archive/2013/03/29/the-case-of-anti-virus-filter-drive-interference-with-file-stream-restore.aspx

     

• Recommended reading from mrdenny for March 29, 2013

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

     

• Choosing a Presentation Tool

  http://www.brentozar.com/archive/2013/03/choosing-a-presentation-tool/

     

• Using the SQL Server APP_NAME function to control stored procedure execution

  http://www.mssqltips.com/sqlservertip/2897/using-the-sql-server-appname-function-to-control-stored-procedure-execution/

     

• Forgotten SQL Server Functions - VARP, SOUNDEX and NTILE

  http://www.mssqltips.com/sqlservertip/2905/forgotten-sql-server-functions--varp-soundex-and-ntile/

     

• Adding clocks when working globally

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/03/28/adding-clocks-when-working-globally.aspx

     

     

기타

• Red Hat unveiled its Big Data strategy

  http://data.story.lu/2013/03/31/red-hat-unveiled-its-big-data-strategy

     

• 마천루의 저주 단상

  http://agbird.egloos.com/5730031

     

• 빅데이타를 이용한 게임 분석 동영상

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

  EA에서 빅데이타 분석에 대한 동영상 자료임. game dba라면 봐야할 것 같음.

     

• Redis 2.6.12 has been released

  http://data.story.lu/2013/03/31/redis-2-6-12-has-been-released

     

• The 4 V's of Big Data

  http://data.story.lu/2013/03/31/the-4-vs-of-big-data

     

• Price of 1 GB of storage over the past 30 yrs:

  http://data.story.lu/2013/03/31/price-of-1-gb-of-storage-over-the-past-30-yrs

  1gb당 저장소 가격입니다. 30년뒤에는 0.1 달러 헉헉.....

     

• MySQL 5.6 – InnoDB Memcached Plugin as a caching layer

  http://www.mysqlperformanceblog.com/2013/03/29/mysql-5-6-innodb-memcached-plugin-as-a-caching-layer/

  와우~

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

• 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을 하여 파일을 분산 저장

SQL

• Break large delete operations into chunks

  http://www.sqlperformance.com/2013/03/io-subsystem/chunk-deletes

• Find missing indexes using SQL Servers index related DMVs

  http://basitaalishan.com/2013/03/13/find-missing-indexes-using-sql-servers-index-related-dmvs/

     

• SQL Server Backup to Cloud – Managing Interrupted backups

  http://blogs.msdn.com/b/sqlosteam/archive/2013/03/12/sql-server-backup-to-cloud-managing-interrupted-backups.aspx

     

• Break large delete operations into chunks

  http://www.sqlperformance.com/2013/03/io-subsystem/chunk-deletes

     

• Log Shipping Part 2: When Disaster Strikes (video)

  http://www.brentozar.com/archive/2013/03/log-shipping-part-2-when-disaster-strikes-video/

     

• Cost of Process Defrag in Analysis Services Tabular #ssas #tabular

  http://sqlblog.com/blogs/marco_russo/archive/2013/03/13/cost-of-process-defrag-in-analysis-services-tabular-ssas-tabular.aspx

     

• Getting Started with Extended Events in SQL Server 2012

  https://www.simple-talk.com/sql/database-administration/getting-started-with-extended-events-in-sql-server-2012/

     

• Configuring "drill to details" behavior in PowerPivot: Part 1

  http://beyondrelational.com/modules/24/syndicated/477/Posts/19139/configuring-drill-to-details-behavior-in-powerpivot-part-1.aspx

     

ETC

• MySQL Backup tools used by Percona Remote DBA for MySQL

  http://www.mysqlperformanceblog.com/2013/03/13/mysql-backup-tools-used-by-percona-remote-dba-for-mysql/        

     

• Linux에서 sysstat 설치하기

  http://beyondj2ee.wordpress.com/2013/03/13/linux%EC%97%90%EC%84%9C-sysstat-%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0/

SQL

• Top 10 Free SQL Server Tools

  http://www.johnsansom.com/top-10-free-sql-server-tools/

  참고로 전 9번 ClearTrace툴을 요긴하게 많이 썼습니다^^

     

• Recommended reading from mrdenny for March 08, 2013

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

     

• How to check for SQL ghost records?

  http://www.sqlserver-dba.com/2013/03/how-to-check-for-sql-ghost-records.html

     

• BCP - Changing the default column terminator

  http://beyondrelational.com/modules/2/blogs/70/posts/19120/bcp-changing-the-default-column-terminator.aspx

     

• SQL Server Maintenance Plans and Parallelism – Index Rebuilds

  http://www.sqlskills.com/blogs/erin/sql-server-maintenance-plans-and-parallelism-index-rebuild/

     

• SQL WAIT TYPE – DTC and how to reduce it

  http://www.sqlserver-dba.com/2013/03/sql-wait-type-dtc-and-how-to-reduce-it.html

     

• Six Scary SQL Surprises

  http://www.red-gate.com/products/dba/dba-bundle/entrypage/hard-earned-lessons-3

     

     

     

ETC

• 5 Tips for Effective Technical Documentation        

  http://sqlsalt.com/5-tips-for-effective-technical-documentation/

SQL

• Execution Plan Analysis: The Mystery Work Table

  http://sqlblog.com/blogs/paul_white/archive/2013/03/08/execution-plan-analysis-the-mystery-work-table.aspx

• Monitor SQL Server TempDB usage

  http://www.sqlserver-dba.com/2013/03/monitor-sql-server-tempdb-usage.html

• INDEX ANALYSIS MARCH UPDATE

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

• You don't have a Big Data problem.

  http://www.brentozar.com/archive/2013/03/you-dont-have-a-big-data-problem/

  이분 말씀이 맞는지도? 빅데이타에 대해서 고민하게 되네요^^

     

• SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function

  http://blog.sqlauthority.com/2013/03/07/sql-server-check-if-string-is-a-palindrome-in-using-t-sql-script-reverse-function/

• A SQL-Based Universal Currency Formatter

  https://www.simple-talk.com/sql/learn-sql-server/a-sql-based-universal-currency-formatter/

     

• Views and ORDER BY

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/03/06/views-and-order-by.aspx

     

기타

• New job, new computer, new software installs

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/03/07/new-job-new-computer-new-software-installs.aspx