SQL

• Geek City: Join With Me! - Kalen Delaney

  http://sqlblog.com/blogs/kalen_delaney/archive/2013/02/14/index-intersection.aspx

     

• Hardware 301 Presentation - Glenn Berry's

  http://sqlserverperformance.wordpress.com/2013/02/14/hardware-301-presentation/

  여기 문서좀 다운로드 해서 업로드 해주세요 ㅠㅠ... 울 회사 다운로드 안돼..

     

• Speaking at PASS Database Administration Virtual Chapter

  http://sqlserverperformance.wordpress.com/2013/02/08/speaking-at-pass-database-administration-virtual-chapter/

  Glenn 아저씨가 pass에서 virtual 강의하신다네요. 아 가고 싶당 ㅠㅠ...

     

• Recommended SQL Server 2012 SP1 Hotfix available for msiexec issue (KB2793634)

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/02/14/recommended-sql-server-2012-sp1-hotfix-available-for-msiexec-issue-kb2793634.aspx

     

• Drop Connections with ROLLBACK IMMEDIATE to allow a Detach database

  http://www.sqlserver-dba.com/2013/02/drop-connections-with-rollback-immediate-to-allow-a-detach-database.html

  자주 쓰는 구문이네요^^

     

• Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies        

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

  masterdb 문제가 되었을 때 조치하는거네요^^ /f, /t3608로 sql을 시작하고, sqlcmd로 경로를 변경한다.

     

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

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

     

• Script Replication with PowerShell

  http://sqlserver365.blogspot.kr/2013/02/script-replication-with-powershell.html

     

• Full Text Searches on Documents in FileTables

  http://www.simple-talk.com/sql/database-administration/full-text-searches-on-documents-in-filetables/

     

• MDX Guide for SQL Folks: Part III - Advanced Analysis

  http://www.sqlservercentral.com/articles/MDX/95065/

     

• Customized SQL Agent Job Notifications

  http://www.mssqltips.com/sqlservertip/2863/customized-sql-agent-job-notifications/

     

• SQL SERVER – Development Productivity Tool – dbForge Studio for SQL Server

  http://blog.sqlauthority.com/2013/02/14/sql-server-development-productivity-tool-dbforge-studio-for-sql-server/

  쩝.. 유료 툴이네여~?

     

• Has the term "big data" completely lost meaning yet?

  http://sqlblog.com/blogs/greg_low/archive/2013/02/10/has-the-term-big-data-completely-lost-meaning-yet.aspx

     

• SQL SERVER – Primary Key and NonClustered Index in Simple Words

  http://blog.sqlauthority.com/2013/02/10/sql-server-primary-key-and-nonclustered-index-in-simple-words/

     

• Find the database owner name from the owner_sid - t-sql and suser_sname

  http://www.sqlserver-dba.com/2013/02/find-the-database-owner-name-from-the-owner_sid-t-sql-and-suser_sname.html

     

• What Does Big Data Mean to You?

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/08/what-does-big-data-mean-to-you.aspx

     

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

  http://sqlcat.com/sqlcat/b/msdnmirror/archive/2013/02/08/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted.aspx

     

• Recommended reading from mrdenny for February 08, 2013

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

     

• Using QUERYTRACEON in plan guides

  http://spaghettidba.com/2013/02/08/using-querytraceon-in-plan-guides/

  아하~^^

     

• WSFC Failure Threshold and Automatic Failovers

  http://sqlsalt.com/wsfc-failure-threshold-and-automatic-failovers/

     

• Manual Log Shipping with PowerShell

  http://spaghettidba.com/2013/02/08/manual-log-shipping-with-powershell/

     

• Database backup does not cause blocking

  http://www.sqlserver-dba.com/2013/02/database-backup-does-not-cause-blocking.html

     

• SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD

  http://blog.sqlauthority.com/2013/02/08/sql-server-backup-and-restore-database-using-command-prompt-sqlcmd/

     

기타

• L4/L7 스위치의 대안, 오픈 소스 로드 밸런서 HAProxy

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

  와~~

     

• Windows shell: commands - John Paul

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/02/13/windows-shell-commands.aspx

     

• [Redis] Slowlog

  http://dol9.tistory.com/215

  http://dol9.tistory.com/214

     

추천

• http://ola.hallengren.com/

  DBA라면 한번씨 보시면 좋을 듯.. 관리를 위한 좋은 스크립트가 많네요

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

설 연휴동안에 너무 쉬었더니~ 아직도 엄청 남았네요^^ 부랴부랴 올려야겠어요.

SQL

• Buffer pool disfavoring - 폴

  http://www.sqlskills.com/blogs/paul/buffer-pool-disfavoring/

     

• Breaking Down 18065 - CSS SQL SERVER Engineers

  http://blogs.msdn.com/b/psssql/archive/2013/02/13/breaking-down-18065.aspx

     

• Graphically Viewing Extended Events Deadlock Graphs - Jonathan Kehayias

  http://www.sqlskills.com/blogs/jonathan/graphically-viewing-extended-events-deadlock-graphs/

• DBCC SHOW_STATISTICS Works With SELECT Permission - Benjamin Nevarez

  http://www.benjaminnevarez.com/2013/02/dbcc-show_statistics-works-with-select-permission/

• The Halloween Problem – Part 1 - Paul White

  http://www.sqlperformance.com/2013/02/t-sql-queries/halloween-problem-part-1

     

• DBA Best Practices - A Blog Series: Episode 3 - Use a Wiki for Documentation

  http://sqlblog.com/blogs/argenis_fernandez/archive/2013/02/13/dba-best-practices-a-blog-series-episode-3-use-a-wiki-for-documentation.aspx

  제가 요즘 고민하는 것들이 올라오네요? 문서를 위한 위키~~ 저도 이거 고민중에요^^

     

• Day 25 of 31 Days of Disaster Recovery: Improving Performance of Backups and Restores

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

  backup시 buffer 관련도 야그가 나왔네요.

     

• How to get list of all available parameter of .EXE file ?

  http://mssqlfun.com/2013/02/13/how-to-get-list-of-all-available-parameter-of-exe-file/

     

• Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above

  http://mssqlfun.com/2013/02/11/refresh-intellisense-in-ssmssql-server-management-studio-2008-above/

  인테릴젼스 리플래쉬 기능 이런 기능도 있군요??

     

• Move or Relocate the files of Resoruce Database in SQL Server 2005

  http://mssqlfun.com/2013/02/07/move-or-relocate-the-files-of-resoruce-database-in-sql-server-2005/

  master, resource db는 같은 경로에 있어야 한다는군요.

     

• How to find/modify SQLServer Agent logfile location?

  http://mssqlfun.com/2013/01/31/how-to-findmodify-sqlserver-agent-logfile-location/

     

• SQL Server Silent unattended installation using configuration file

  http://mssqlfun.com/2013/01/29/sql-server-silent-unattended-installation-using-configuration-file/

  예전, 주언형님 책에 나와있던 내용이네요^^ 설치 간편하게 하는 방법.. 200백대~300백대는 그냥 껌이죵~~

     

• Extracting DACPACs from all databases with Powershell        

  http://spaghettidba.com/2013/02/13/extracting-dacpacs-from-all-databases-with-powershell/

• Cannot execute as the database principal

  http://www.sqlserver-dba.com/2013/02/cannot-execute-as-the-database-principal.html

     

     

ETC

• SQL and NoSQL Symbiosis

  http://architects.dzone.com/articles/sql-and-nosql-symbiosis

• Using R — .Call("hello")

  http://architects.dzone.com/articles/using-r-%E2%80%94-call%E2%80%9Chello%E2%80%9D

  우리도 R 공부해 보아요..

  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/

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/

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/