SQL

• How to allow Ad hoc updates in SQL Server system catalogs

  http://www.mssqltips.com/sqlservertip/2875/how-to-allow-ad-hoc-updates-in-sql-server-system-catalogs/

• SQL Agent Alert System Error: [264] An attempt was made to send an email when no email session has been established

  http://basitaalishan.com/2013/02/11/sql-agent-alert-system-error-264-an-attempt-was-made-to-send-an-email-when-no-email-session-has-been-established/

     

• Exploring earnings data for the UK [Open Data]

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/02/11/exploring-earnings-data-for-the-uk-open-data.aspx

• Difference between UNIQUE CONSTRAINT versus UNIQUE INDEX

  http://www.sqlserver-dba.com/2013/02/difference-between-unique-constraint-versus-unique-index.html

     

• #0239 - SQL Server 2012 - Msg 402 - The data types datetime and time are incompatible in the add/subtract operator

  http://beyondrelational.com/modules/2/blogs/77/Posts/18855/0239-sql-server-2012-msg-402-the-data-types-datetime-and-time-are-incompatible-in-the-addsubtract-op.aspx

     

• Moving Database Files in SQL Server

  http://www.sqlservercentral.com/articles/Files+and+Filegroups/96031/

     

• Move all SQL Server indexed views to a new filegroup

  http://www.mssqltips.com/sqlservertip/2882/move-all-sql-server-indexed-views-to-a-new-filegroup/

     

• SQL SERVER – What is Semantics Model – A Simple Explanation

  http://blog.sqlauthority.com/2013/02/11/sql-server-what-is-semantics-models-a-simple-explanation/

     

• Day 26 of 31 Days of Disaster Recovery: The Mysterious Case of the Long Backup

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

     

ETC

• fatcache is memcache on SSD. Think of fatcache as a cache for your big data.

  http://data.story.lu/2013/02/11/twitters-fatcache-available-on-github

     

• Testing the StreamInsight Service for Windows Azure

  http://www.simple-talk.com/cloud/platform-as-a-service/testing-the-streaminsight-service-for-windows-azure/

     

• Google on Datastore Query, Index, and Transactions

  http://architects.dzone.com/articles/google-datastore-query-index

안녕하세요. 주디아줌마입니다.

설 연휴 잘 보내셨나요? 연휴동안 쉬었더니~ 헉헉… 어마어마한 자료들이 bb… 아침, 점심 시간 동안 정리해서 올려야겠어요.

SQL

• The Path to In-Memory Database Technology

  http://sqlblog.com/blogs/joe_chang/archive/2013/02/11/the-path-to-in-memory-database-technology.aspx

     

• An in-depth look at change detection in SQL Server - Part 01

  http://www.sqlservercentral.com/articles/change+detection/95930/

     

• Day 27 of 31 Days of Disaster Recovery: Restoring Part of a Database

  http://www.sqlsoldier.com/wp/sqlserver/day-27of31daysofdisasterrecoveryrestoringpartofadatabase

  31day 시리즈가 다되어가네요^^ 정말 재미있는 이슈들 ㅎ.ㅎ

     

• Under rare conditions, using IN clause can cause unexpected SQL behavior

  http://blogs.msdn.com/b/psssql/archive/2013/02/11/under-rare-conditions-using-in-clause-can-cause-unexpected-sql-behavior.aspx

  이런 이슈들이 있었군여^^?

     

• Avoiding SQL Server Query Disaster through Refactoring for Resilience

  http://www.mssqltips.com/sqlservertip/2881/avoiding-sql-server-query-disaster-through-refactoring-for-resilience/

     

• Hardware Sizing Guide for SSAS Tabular

  http://sqlblog.com/blogs/greg_low/archive/2013/02/13/hardware-sizing-guide-for-ssas-tabular.aspx

     

• T-SQL Tuesday #39: Managing your SQL Server Services with PowerShell

  http://sqlblog.com/blogs/allen_white/archive/2013/02/12/t-sql-tuesday-39-managing-your-sql-server-services-with-powershell.aspx

     

• Powershell write to Word document

  http://www.sqlserver-dba.com/2013/02/powershell-write-to-word-document.html

     

• Creare un backup di un Azure SQL Database con SQL Server Management Studio

  http://blogs.dotnethell.it/suxstellino/Creare-un-backup-di-un-Azure-SQL-Database-con-SQL-Server-Management-Studio__19049.aspx

  제가 찾고 있던 자료네요. SQL애져 환경에서 백업 및 복원은 어떻게 하는가? ㅎㅎ

     

• Expanding AlwaysOn Availability Groups with Replication Publishers

  http://www.simple-talk.com/sql/database-administration/expanding-alwayson-availability-groups-with-replication-publishers/

     

• T-SQL Tuesday #39: Get Role Members With PowerShell

  http://sqlsalt.com/t-sql-tuesday-39-get-role-members-with-powershell/

     

• Behind the scenes of PowerShell and SQL

  http://sqlblog.com/blogs/rob_farley/archive/2013/02/12/behind-the-scenes-of-powershell-and-sql.aspx

     

• SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 5

  http://blog.sqlauthority.com/2013/02/12/sql-server-an-interesting-case-of-redundant-indexes-index-on-col1-col2-and-index-on-col1-col2-col3-part-5/

     

• XML Support and SQL Server (Part 3)

  http://basitaalishan.com/2013/02/11/xml-support-and-sql-server-part-3/

     

     

ETC        

• How Does the Cloud Change a Developer's Job?

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

     

• [입 개발] Cassandra 의 Stage 와 SEDA

  http://charsyam.wordpress.com/2013/02/12/%EC%9E%85-%EA%B0%9C%EB%B0%9C-cassandra-%EC%9D%98-stage-%EC%99%80-seda/

     

• Unexpected problem with triggers and mysqldum

  http://architects.dzone.com/articles/unexpected-problem-triggers

     

• How to Take Advantage of NewSQL in the Cloud

  http://architects.dzone.com/articles/how-take-advantage-newsql

SQL

• Tracking page splits using the transaction log        - 폴 랜달?

  http://www.sqlskills.com/blogs/paul/tracking-page-splits-using-the-transaction-log/        

  확장 이벤트 (sqlserver.transaction_log event) 확인 가능하며, 추가적으로 트랜잭션 로그 확인 가능한 방법들을 소개해주시네요.ㅎ

     

• SOMETHING SMELLS: PARAMETER SNIFFING

  http://thomaslarock.com/2013/02/something-smells-parameter-sniffing/

  추가 참고 링크 : http://www.sommarskog.se/query-plan-mysteries.html

     

• (와우!!) Query hint QUERYTRACEON is now documented publically

  http://blogs.msdn.com/b/psssql/archive/2013/02/07/query-hint-querytraceon-is-now-documented-publically.aspx

     

  예) ELECT x FROM correlated WHERE f1 = 0 and f2 = 1 OPTION (QUERYTRACEON 4199)

  TRACE FLAG : 4199, 2335, 2340, 4137, 4138,

     

• Obtaining rowcounts when using Composable DML [T-SQL]        

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/02/07/obtaining-rowcounts-when-using-composable-dml.aspx        

     

• Exploring the Varbinary Type

  http://www.sqlservercentral.com/articles/Data+Types/95761/

     

• Troubleshooting and Fixing SQL Server Page Level Corruption

  http://www.mssqltips.com/sqlservertip/2871/troubleshooting-and-fixing-sql-server-page-level-corruption/

  참고해볼만함 .

     

• Why to use COALESCE instead of ISNULL

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/02/06/why-to-use-coalesce-instead-of-isnull.aspx

     

     

ETC

• Performing Full-text Searches in MySQL 5.6

  http://www.databasejournal.com/features/mysql/performing-full-text-searches-in-mysql-5.6.html

• Oracle Releases Open Source MySQL 5.6 with NoSQL Features        

  http://www.databasejournal.com/news/oracle-releases-open-source-mysql-5.6-with-nosql-features.html

     

• 2차 인증 소개

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

  OTP만 알고 있었는데 다양한 방식이 있네요.

     

• [입 개발] Redis의 mem_fragmentation_ratio 는 어떻게 구할까?

  http://charsyam.wordpress.com/2013/02/07/%EC%9E%85-%EA%B0%9C%EB%B0%9C-redis%EC%9D%98-mem_fragmentation_ratio-%EB%8A%94-%EC%96%B4%EB%96%BB%EA%B2%8C-%EA%B5%AC%ED%95%A0%EA%B9%8C/

http://blogs.msdn.com/b/psssql/archive/2013/02/07/query-hint-querytraceon-is-now-documented-publically.aspx

＃. 참고 링크
http://support.microsoft.com/kb/2801413/en-us
http://sqlblog.com/blogs/paul_white/archive/2011/09/21/how-to-find-the-statistics-used-to-compile-an-execution-plan.aspx

querytraceon이 공식화 되었다~

쿼리 최적화 도구 

예) SELECT x FROM correlated WHERE f1 = 0 and f2 = 1 OPTION (QUERYTRACEON 4199)

TRACE FLAG : 4199, 2335, 2340, 4137, 4138, 

권한
DBCC TRACEON은 "Requires membership in the sysadmin fixed server role." sysadmin role을 요구 한다.
권한 제어 EXECUTE AS owner, IMPERSONATE

2013.02.15 가이드라인
http://spaghettidba.com/2013/02/08/using-querytraceon-in-plan-guides/

sysadmin 이 아닌 사용자로 실행하는 dynamic sql 에서 querytraceon 힌트 사용하기 - 김민석
http://sqlsql.tistory.com/259
http://msdn.microsoft.com/ko-kr/library/ms173848.aspx - GRANT 데이터베이스 보안 주체 사용 권한(Transact-SQL)

SQL

• Msg 5042 - The file cannot be removed because it is not empty and dbcc shrinkfile emptyfile

  http://www.sqlserver-dba.com/2013/02/msg-5042-the-file-cannot-be-removed-because-it-is-not-empty-and-dbcc-shrinkfile-emptyfile.html

     

• SQL Monitor - Using the performance data smartly

  http://www.simple-talk.com/sql/sql-tools/sql-monitor---using-the-performance-data-smartly/

     

• Hive Data Warehouse: Lessons Learned (video)

  http://www.brentozar.com/archive/2013/02/hive-data-warehouse-lessons-learned-video/

     

• Move all SQL Server indexed views to a new filegroup

  http://www.mssqltips.com/sqlservertip/2882/move-all-sql-server-indexed-views-to-a-new-filegroup/

     

• Scope of SET TRANSACTION ISOLATION LEVEL

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/02/05/scope-of-set-transaction-isolation-level.aspx

     

• If you are using indexed views and MERGE, please read this!

  http://www.sqlperformance.com/2013/02/t-sql-queries/another-merge-bug

  Merge에 대한 버그 이슈 야그가 많네요..

     

     

ETC

• Hive Data Warehouse: Lessons Learned (video)

  http://www.brentozar.com/archive/2013/02/hive-data-warehouse-lessons-learned-video/

• [입 개발] Redis Internals : PubSub

  http://charsyam.wordpress.com/2013/02/06/%EC%9E%85-%EA%B0%9C%EB%B0%9C-redis-internals-pubsub/        

     

• R 사용하기 – 1. Twitter 내용을 검색해서 wordcloud 로 표현하기

  http://dev.kthcorp.com/2013/02/06/r-quickstart-guide-1-twitter-wordcloud/

  요즘 분석 업계에서 R 모르면~ 간첩이죠? 저도 얼마전에 해봤는데 정말 쉽게 표현되더만요..다시 통계 공부나 해야징 ㅠㅠ

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/

정말 멋진 폴 아저씨~^^

>> 삭제된 테이블을 로그 파일로 복구하기 입니다.  중요 포인트는 풀백업하고 로그 백업이 되어 있어야 합니다.

http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

로그 백업 전이라면 메모리에 있는 로그 정보 보기 : fn_dblog
로그 백업 파일로 로그 정보 보기 : fn_dump_dblog

 20130205_삭제된테이블복구방법.sql

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/