SQL

• SQL Server 2008 R2 Diagnostic Information Queries (Feb 2013) - Grenn

  http://sqlserverperformance.wordpress.com/2013/02/05/sql-server-2008-r2-diagnostic-information-queries-feb-2013/

• Partitioning Relational Data – (Part – 2)

  http://basitaalishan.com/2013/02/05/partitioning-relational-data-part-2/

     

• Partitioning in SQL Server - Part 3

  http://www.databasejournal.com/features/mssql/partitioning-in-sql-server-part-3.html

• Incorrect Results with Indexed Views

  http://sqlblog.com/blogs/paul_white/archive/2013/02/06/incorrect-results-with-indexed-views.aspx

• DBCC WRITEPAGE: an introduction

  http://www.sqlskills.com/blogs/paul/dbcc-writepage/
  와우^^ 괜찮은 명령어네.. 단.. 책임을 못지는 ㅎ.ㅎ
  

  1. To allow automated testing of DBCC CHECKDB and repair by the SQL Server team.
  2. To engineer corruptions for demos and testing.
  3. To allow for last-ditch disaster recovery by manually editing a live, corrupt database.

• Connettersi via SSMS a SQL Azure Databases

  http://blogs.dotnethell.it/suxstellino/Connettersi-via-SSMS-a-SQL-Azure-Databases__19038.aspx

• Windows Azure SQL Database and SQL Server -- Performance and Scalability Compared and Contrasted

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/05/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted.aspx

• How Does the Cloud Change a Systems Administrator's Job?

  http://sqlblog.com/blogs/buck_woody/archive/2013/02/05/how-does-the-cloud-change-a-systems-administrator-s-job.aspx

• Modify sql transaction log file size - increase or decrease

  http://www.sqlserver-dba.com/2013/02/modify-sql-transaction-log-file-size-increase-or-decrease.html

     

• Sysprep improvements in SQL Server 2012 SP1 CU2

  http://sqlblog.com/blogs/greg_low/archive/2013/02/05/sysprep-improvements-in-sql-server-2012-sp1-cu2.aspx

     

• SQL SERVER – Fix: Error: 1505 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name and the index name

  http://blog.sqlauthority.com/2013/02/05/sql-server-fix-error-1505-the-create-unique-index-statement-terminated-because-a-duplicate-key-was-found-for-the-object-name-and-the-index-name/

     

• Important Trace Flags for DBA

  http://sqldbpool.com/2013/02/05/important-trace-flags-for-dba/

     

ETC        

• [입 개발] memcached 는 predictable 하고 Redis는 unpredictable 하다.

  http://charsyam.wordpress.com/2013/02/05/%EC%9E%85-%EA%B0%9C%EB%B0%9C-memcached-%EB%8A%94-predictable-%ED%95%98%EA%B3%A0-redis%EB%8A%94-unpredictable-%ED%95%98%EB%8B%A4/

     

• SQL Reporting Services Pricing Update

  http://www.dzone.com/articles/sql-reporting-services-pricing

     

• API와 서비스를 스마트하게 모니터링 하는 방법, Safari Tour 를 소개합니다.

  http://dev.kthcorp.com/2013/02/05/smart-api-monitoring-safari-tour/

SQL

• SQL Server Baselines Series on SQLServerCentral.com

  http://www.sqlskills.com/blogs/erin/sql-server-baselines-series-on-sqlservercentral-com/

• Getting Started with Extended Events in SQL Server 2012

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

     

• NOEXPAND query hint returns wrong results – CU fix now available

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/02/04/noexpand-query-hint-returns-wrong-results-cu-fix-now-available.aspx

     

• Could not find prepared statement with handle – Msg 8179

  http://www.sqlserver-dba.com/2013/02/could-not-find-prepared-statement-with-handle-msg-8179.html

     

• Database Deployment: The Bits - Versioning

  http://www.simple-talk.com/sql/database-administration/database-deployment-the-bits---versioning/

     

• Capturing Baselines on SQL Server: Wait Statistics

  http://www.sqlservercentral.com/articles/baselines/96270/

     

• Using the Data Profiling SQL Server Integration Services SSIS task

  http://www.mssqltips.com/sqlservertip/2854/using-the-data-profiling-sql-server-integration-services-ssis-task/

     

• Can a table have no columns?

  http://sqlblog.com/blogs/greg_low/archive/2013/02/04/can-a-table-have-no-columns.aspx

     

• Using Policy Based Management for checking SQL Server Versions

  http://www.mssqltips.com/sqlservertip/2860/using-policy-based-management-for-checking-sql-server-versions/

SQL

• SQL Server 2012 Diagnostic Information Queries (Feb 2013) - Glenn Berry

  http://sqlserverperformance.wordpress.com/2013/02/01/sql-server-2012-diagnostic-information-queries-feb-2013/

• Don't change value of that parameter - CSS SQL Server

  http://blogs.msdn.com/b/psssql/archive/2013/02/03/don-t-change-value-of-that-parameter.aspx

  흥미로운 이슈입니다.

  1) option (optimize for (@BatchID unknown))

  2) dbcc traceon (2389,2390,-1)

  enable automatically generated quick statistics for ascending keys

  http://sqlblog.com/blogs/kevin_kline/archive/2008/05/19/why-isn-t-auto-update-statistics-running.aspx

     

• SQL Server support levels        

  http://www.sqlserver-dba.com/2013/02/sql-server-support-levels.html        

  지원일정 확인하세요^^

  SQL Server 2000 – Extended support will finish on April 19th,2013.

  SQL Server 2005 – Extended support started on April 12th ,2011

• Hurricane Sandy Mash-Up: Hive, SQL Server, PowerPivot & Power View        

  http://blogs.msdn.com/b/cindygross/archive/2013/01/31/mash-up-hive-sql-server-data-in-powerpivot-amp-power-view-hurricane-sandy-2012.aspx

     

• Intel Flash Storage Products for SQL Server - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/interesting-flash-storage-products-from-intel-2/

• SQL Server 2012 Service Pack 1 Cumulative Update 2        

  http://www.sqlskills.com/blogs/glenn/sql-server-2012-service-pack-1-cumulative-update-2/

     

• SQL Server disaster-recovery poster now available

  http://www.sqlskills.com/blogs/paul/sql-server-disaster-recovery-poster-now-available

     

• Customizing Extended Events Templates in SQL Server 2012

  http://www.sqlskills.com/blogs/jonathan/customizing-extended-events-templates-in-sql-server-2012/

     

• ASK THE UNICORN: HOW TO BECOME A DBA?

  http://www.jasonstrate.com/2012/10/ask-the-unicorn-how-to-become-a-dba

     

• Difference between System DSN and User DSN

  http://www.sqlserver-dba.com/2013/02/difference-between-system-dsn-and-user-dsn.html

     

• Benefits of the Bulk-Logged Recovery Model

  http://sqlsalt.com/benefits-of-the-bulk-logged-recovery-model/

     

• Database mirroring cannot be enabled because the database is not in full recovery mode on both partners

  http://www.sqldbadiaries.com/2013/02/01/database-mirroring-cannot-be-enabled-because-the-database-is-not-in-full-recovery-mode-on-both-partners

     

• Silent Truncation of SQL Server Data Inserts

  http://www.mssqltips.com/sqlservertip/2857/silent-truncation-of-sql-server-data-inserts/

     

• SQL SERVER – Difference Between NOLOCK and NOWAIT Hints

  http://blog.sqlauthority.com/2013/02/01/sql-server-difference-between-nolock-and-nowait-hints/

     

     

ETC        

• 페도라-오픈수세, 오라클 마이SQL 뺀다

  http://www.zdnet.co.kr/news/news_view.asp?artice_id=20130202024310

• Hadoop 적용 사례 기사 정리

  http://blrunner.com/41

     

• elasticsearch로 로그 검색 시스템 만들기

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

SQL

• A creative use of IGNORE_DUP_KEY

  http://sqlblog.com/blogs/paul_white/archive/2013/02/01/a-creative-use-of-ignore-dup-key.aspx

• Why does SQL Server not compress data on LOB pages?

  http://sqlblog.com/blogs/hugo_kornelis/archive/2013/01/31/why-does-sql-server-not-compress-data-on-lob-pages.aspx

     

• Why PowerShell for SQL Server?

  http://www.sqlmag.com/article/powerscript/powershell-sql-server-145103

     

• Best Practices + Table Partitioning: Merging Boundary Points

  http://www.brentozar.com/archive/2013/01/best-practices-table-partitioning-merging-boundary-points

     

• Day 24 of 31 Days of Disaster Recovery: Handling Corruption in a Clustered Index

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

  와우^^. 장애 복구~ 백서수준이네요~

     

• Evaluating Policies on Multiple SQL Server Instances using Central Management Server

  http://www.mssqltips.com/sqlservertip/2859/evaluating-policies-on-multiple-sql-server-instances-using-central-management-server/

     

• SQL SERVER – Significance of Table Input Parameter to Stored Procedure – Guest Post by Vikas Munjal – Koenig Solutions

  http://blog.sqlauthority.com/2013/01/31/sql-server-significance-of-table-input-parameter-to-stored-procedure-guest-post-by-vikas-munjal-koenig-solutions/

     

     

기타        

• [kth 모바일 리포터]스마트폰 이용고객 이제 지갑 열 준비 되었다!!

  http://dev.kthcorp.com/2013/01/31/customer_story5/

SQL

• Express Edition revisited, focus on SSMS

  http://sqlblog.com/blogs/tibor_karaszi/archive/2013/01/30/express-edition-revisited-focus-on-ssms.aspx

• AppDomain unloading messages flooding the SQL Server error log

  http://blogs.msdn.com/b/psssql/archive/2013/01/30/appdomain-unloading-messages-flooding-the-sql-server-error-log.aspx

• Forcing "Custom Properties" of a Data Flow Transformation to support DTS Expression

  http://sqlblog.com/blogs/davide_mauri/archive/2013/01/30/forcing-custom-properties-of-a-data-flow-transformation-to-support-dts-expression.aspx

• The Okapis of SQL Server Indexes

  http://www.brentozar.com/archive/2013/01/the-okapis-of-sql-server-indexes/

• Different ways to find End of the month

  http://beyondrelational.com/modules/2/blogs/70/posts/18723/different-ways-to-find-end-of-the-month.aspx

  월의 마지막일을 구하는 script

• SQL Server Performance Tuning – Index Tuning

  http://www.sql-server-performance.com/2013/sql-server-index-tuning/

• Using WITH ROWCOUNT and PAGECOUNT option of SQL Server UPDATE STATISTICS

  http://www.mssqltips.com/sqlservertip/2870/using-with-rowcount-and-pagecount-option-of-sql-server-update-statistics/

ETC

• Git에 대한 생각..

  http://beyondj2ee.wordpress.com/2013/01/30/git%EC%97%90-%EB%8C%80%ED%95%9C-%EC%83%9D%EA%B0%81/

SQL

• SQL2012 보안가이드 PDF - 최인규 이사님, 이장래 수석님

  http://www.sqlroad.com/62 내용이 알차고 좋습니다 @.@

  

     

• [SQL2012BI]5. MSSQL 2012 DW 셋팅 - 김상수님
  http://www.sqler.com/539653#5
  DW 환경 SQL 세팅올려 주셨는데 DW 환경에서 고려해야 할 사항들입니다. DW 가이드라인으로 쓰면 아주 좋을 것 같네요 ~

     

• How Does the Cloud Change a Database Administrator's Job?

  http://sqlblog.com/blogs/buck_woody/archive/2013/01/29/how-does-the-cloud-change-a-database-administrator-s-job.aspx

• SQL Server – How to use READ_COMMITED_SNAPSHOT isolation level

  http://www.sqlserver-dba.com/2013/01/sql-server-how-to-use-read_commited_snapshot-isolation-level.html

     

• Providing SQL Agent Job Log Data for Developers

  http://www.mssqltips.com/sqlservertip/2858/providing-sql-agent-job-log-data-for-developers/

     

• Day 23 of 31 Days of Disaster Recovery: Restoring Differential Backups With New Files

  http://www.sqlsoldier.com/wp/sqlserver/day-23-of-31-days-of-disaster-recovery-restoring-differential-backups-with-new-files 연재식으로 재해복구를 31일간 올려주네요~ 내용도 알차요 ㅎ.ㅎ

     

• Visualizing Data File Layout III

  http://sqlblog.com/blogs/merrill_aldrich/archive/2013/01/28/visualizing-data-file-layout-iii.aspx

     

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

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

Update

• KB Article For CU2 of SQL Server 2012 SP1

  CU#2 KB Article: http://support.microsoft.com/kb/2790947

  추가된 기능 2가지 http://blogs.technet.com/b/stbnewsbytes/archive/2013/01/24/january-24-2013-news-thursday-microsoft-virtualization-jump-start-and-more-server-and-tools-news.aspx

     

• KB Article For CU9 of SQL Server 2008 SP3

  CU#9 KB Article: http://support.microsoft.com/kb/2799883 

     

SQL

• Using constraints to enforce uniqueness of ordered sets of rows

  http://sqlblog.com/blogs/alexander_kuznetsov/archive/2013/01/28/using-constraints-to-enforce-uniqueness-of-ordered-sets-of-rows.aspx

     

• SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?

  http://mssqlfun.com/2013/01/21/sql-server-reserve-1-user-connection-for-dac-dedicated-administrator-connection-want-to-confirm/

• SQL Server Table Partitioning Tutorial: Videos and Scripts

  http://www.brentozar.com/archive/2013/01/sql-server-table-partitioning-tutorial-videos-and-scripts/

     

• SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell

  http://www.databasejournal.com/features/mssql/ssis-2012-introduction-to-managing-sql-server-with-powershell.html

     

• Update statistics in parallel

  http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/95820/

     

• SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query

  http://blog.sqlauthority.com/2013/01/28/sql-server-basic-explanation-of-set-lock_timeout-how-to-not-wait-on-locked-query/

     

• Day 22 of 31 Days of Disaster Recovery: Which DBCC CHECK Commands Update Last Known Good DBCC

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

     

• Do you need sysadmin rights to backup a database?

  http://spaghettidba.com/2013/01/09/do-you-need-sysadmin-rights-to-backup-a-database/

SQL

• Common Table Expressions (CTEs), Window Functions, and Views

  http://www.sqlskills.com/blogs/jonathan/ctes-window-functions-and-views/

• Optimizing T-SQL queries that change data

  http://sqlblog.com/blogs/paul_white/archive/2013/01/26/optimizing-t-sql-queries-that-change-data.aspx

• Column store solutions

  http://sqlscope.wordpress.com/2013/01/27/column-store-solutions/

  Column Store Index는 ent 버젼만 사용하게 되었는데 다음 버젼에서는 해제된다는 내용입니다. 또한 추가적으로

  nonclustered index 생성 가능, 부모테이블 및 파티션 테이블의 읽기 전용으로만 사용되는 부분도 기능 업글된다는 내용이네요.

• Continuous deployment of SSDT database projects to Windows Azure using Team Foundation Service

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/01/27/continuous-deployment-of-ssdt-database-projects-to-windows-azure-using-team-foundation-service.aspx

• Backup TO DISK, TAPE and now URL - Backup On-Premises SQL Server Databases to Azure Storage

  http://sqlblog.com/blogs/greg_low/archive/2013/01/27/backup-to-disk-tape-and-now-url-backup-on-premises-sql-server-databases-to-azure-storage.aspx

  SQL애져 환경에서 URL을 통한 백업이가능하네요. http://blogs.msdn.com/b/windowsazure/archive/2013/01/24/sql-server-backup-and-restore-to-cloud-simplified.aspx

• Undoing a change will now undo a check-out in Visual Studio 2012        

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/01/26/undoing-a-change-will-now-undo-a-check-out-in-visual-studio-2012.aspx

• SQL Server – Min Memory Per query and performance

  http://www.sqlserver-dba.com/2013/01/sql-server-min-memory-per-query-and-performance.html

• SQL Server 2008 Service Pack 3 Cumulative Update 9

  http://sqlserverperformance.wordpress.com/2013/01/25/sql-server-2008-service-pack-3-cumulative-update-9/

  2008/2008R2 지원 서비스는 2014.1.14로 끝나네요. 2008 시스템 쓰시는 분들은 어서 업그레이드 하세요~

• Database Backup Integrity Checks with PowerShell

  http://sqlsalt.com/backup-integrity-checks-with-powershell/

• SQL Server - Find Default Data location and Default Log Location

  http://www.sqlserver-dba.com/2013/01/sql-server-find-default-data-location-and-default-log-location-.html

• Replication Latency

  http://sqlserver365.blogspot.kr/2013/01/replication-latency.html

• SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query

  http://blog.sqlauthority.com/2013/01/25/sql-server-basic-explanation-of-query-hint-nowait-how-to-not-wait-on-locked-query/

ETC

• TimingWheel을 이용한 타이머 구현

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

Update

• Cumulative Update #2 for SQL Server 2012 Service Pack 1

CU#2 KB Article: http://support.microsoft.com/kb/2790947

Understanding Incremental ServicingModel for SQL Server

SQL Server Support Information: http://support.microsoft.com/ph/2855

SQL

• SQL Server Backup and Restore to Cloud Simplified

  http://blogs.msdn.com/b/windowsazure/archive/2013/01/23/sql-server-backup-and-restore-to-cloud-simplified.aspx

• Backup and Restore to Cloud Simplified in SQL Server 2012 SP1 CU2

  http://sqlblog.com/blogs/sqlos_team/archive/2013/01/24/backup-and-restore-to-cloud-simplified-in-sql-server-2012-sp1-cu2.aspx

• NOLOCK is not a turbo button

  http://itknowledgeexchange.techtarget.com/sql-server/nolock-is-not-a-turbo-button/

• SQL SERVER DATA TOOLS: WHY MUST LIFE BE SO HARD?

  http://thomaslarock.com/2013/01/sql-server-data-tools-why-must-life-be-so-hard/

• Another reason to use THROW clause instead of RAISERROR | SQL Server 2012

  http://sqlwithmanoj.wordpress.com/2013/01/24/another-reason-to-use-throw-clause-instead-of-raiserror-sql-server-2012

  SQL2012에서는 예외처리 쉽네요잉!^^ TRY~CATCH와 THROW 처리만 해주면 되니~ @.@

• When a Query Isn't Quite a Query

  http://www.brentozar.com/archive/2013/01/when-a-query-isnt-quite-a-query/

• T-SQL Restore Script Generator

  http://www.sqlservercentral.com/articles/Restore+database/95839/

  쥑인다~~ @.@ 내가 찾던 Script~~

• SQL Server – LCK_M_IS and how to reduce it - sql wait type

  http://www.sqlserver-dba.com/2013/01/sql-server-lck_m_is-and-how-to-reduce-it-sql-wait-type.html

  참 정리 잘 해놓으셨네^^

• Encrypting SQL Server backups with open source tools

  http://www.mssqltips.com/sqlservertip/2861/encrypting-sql-server-backups-with-open-source-tools/

  SQL2012 버젼부터 backup 할때 password 처리 부분이 없어졌는데 opensource로 암호화 처리가 가능한 유용한 방법 소개네요^^ 요즘 오픈 소스 및 프로젝트가 대세내요~ @.@

• Introduction to SQL Server Check Constraints

  http://www.sql-server-performance.com/2013/introduction-sql-server-check-constraints

• SQL SERVER – How to Use Instead of Trigger – Guest Post by Vikas Munjal – Koenig Solutions

  http://blog.sqlauthority.com/2013/01/24/sql-server-how-to-use-instead-of-trigger-guest-post-by-vikas-munjal-koenig-solutions/

• Visualizing Data File Layout II

  http://sqlblog.com/blogs/merrill_aldrich/archive/2013/01/23/visualizing-data-file-layout-ii.aspx

ETC

• 국내 오픈소스 DB툴 Tadpole (올챙이)를 소개 합니다

  http://beyondj2ee.wordpress.com/2013/01/24/%EA%B5%AD%EB%82%B4-%EC%98%A4%ED%94%88%EC%86%8C%EC%8A%A4-db%ED%88%B4-tadpole-%EC%98%AC%EC%B1%99%EC%9D%B4%EB%A5%BC-%EC%86%8C%EA%B0%9C-%ED%95%A9%EB%8B%88%EB%8B%A4/

  몽고디비, MySQL 등등 DB 툴입니다. 쥑인다 @@~ 몽고DB나 해볼까??
   

  

SQL

• SQL Server Management Studio Query Designer

  http://www.mssqltips.com/sqlservertip/1086/sql-server-management-studio-query-designer/

• Choosing the Right SQL Server Version: It's Trickier than You'd Think

  http://www.brentozar.com/archive/2013/01/choosing-the-right-sql-server-version-its-trickier-than-youd-think/

• Capturing Baselines on SQL Server: Where's My Space?

  http://www.sqlservercentral.com/articles/baselines/96059/

• Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues

  http://www.mssqltips.com/sqlservertip/2827/troubleshooting-sql-server-resourcesemaphore-waittype-memory-issues/
  이전에도 올렸던 것 같은데~ 흠..

• SQL Server - How much resource is a SQL database using - memory, disk, IOPS,CPU

  http://www.sqlserver-dba.com/2013/01/sql-server-how-much-resource-is-a-sql-database-using-memory-disk-iopscpu.html

• Visualizing Data File Layout I

  http://sqlblog.com/blogs/merrill_aldrich/archive/2013/01/22/visualizing-data-file-layout-i.aspx

  내부 데이터 파일을 볼 수 있는 툴 소개입니다~
   

ETC

• 추천 시스템 분석 – 어떻게 아마존과 넷플릭스가 당신의 취향을 예상하는가?

  http://dev.kthcorp.com/2013/01/23/deconstructing-recommender-systems/