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

• ADMINISTERING SQL SERVER 2012 RUNNING ON WINDOWS SERVER CORE

  http://thomaslarock.com/2013/03/administering-sql-server-running-on-server-core

     

• Getting error while parsing XML data to Sql Server

  http://beyondrelational.com/modules/3/ask/questions/19128/getting-error-while-parsing-xml-data-to-sql-server.aspx

     

• Select all SQL Server Functions

  http://www.sqlserver-dba.com/2013/03/select-all-sql-server-functions.html

     

• Day 30 of 31 Days of Disaster Recovery (T-SQL Tuesday #40): Using Partial Availability and Initialize from Backup to Replicate a Partial Database

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

     

• SQL Server – Generating PERMUTATIONS using T-Sql

  http://beyondrelational.com/modules/24/syndicated/463/Posts/19135/sql-server-generating-permutations-using-t-sql.aspx

     

• Using Filtered Indexes to Improve Performance

  http://www.sql-server-performance.com/2013/sql-server-filtered-indexes-performance

     

• SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek

  http://blog.sqlauthority.com/2013/03/12/sql-server-avoid-using-function-in-where-clause-scan-to-seek/

     

• Filegroups and Non-Clustered Indexes

  http://sqlblog.com/blogs/rob_farley/archive/2013/03/12/filegroups-and-non-clustered-indexes.aspx

     

ETC

• [입 개발] Redis Pub/Sub 시스템은 일반적인 Message Queue와 다르다.

  http://charsyam.wordpress.com/2013/03/12/%EC%9E%85-%EA%B0%9C%EB%B0%9C-redis-pubsub-%EC%8B%9C%EC%8A%A4%ED%85%9C%EC%9D%80-%EC%9D%BC%EB%B0%98%EC%A0%81%EC%9D%B8-message-queue%EC%99%80-%EB%8B%A4%EB%A5%B4%EB%8B%A4/

SQL

• DISTINCT and ORDER BY

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

     

• Validating Instance-Level Index View and MERGE Optimization Activity

  http://www.sqlskills.com/blogs/joe/validating-instance-level-index-view-and-merge-usage/

  Merge 이슈들에 대한 언급이 나오네요

     

• sp_ssiscatalog v1.0.2.0 now available for download [SSIS]

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/03/12/sp-ssiscatalog-v1-0-2-0-now-available-for-download.aspx

     

• Are Filtered Statistics Useful with Parameterization?

  http://www.sqlskills.com/blogs/joe/are-filtered-statistics-in-unmatched-scenarios/

  헐.... 상수형이 아닐경우 필터 통계를 사용하지 못하네요.

     

• #0247-SQL Server - sp_refreshview - Refresh metadata for non-schema bound view

  http://beyondrelational.com/modules/2/blogs/77/Posts/19103/0247-sql-server-sprefreshview-refresh-metadata-for-non-schema-bound-view.aspx

     

• DMV-2 : Explore the secrets of session…… sys.dm_exec_sessions

  http://beyondrelational.com/modules/24/syndicated/992/Posts/19130/dmv-2-explore-the-secrets-of-session-sysdmexecsessions.aspx

     

• PowerShell SnapIns vs. Modules

  http://beyondrelational.com/modules/24/syndicated/396/Posts/19124/powershell-snapins-vs-modules.aspx

     

• #0246 - SQL Server 2012 - FileStream and FileTable related DMVs and Catalog Views

  http://beyondrelational.com/modules/2/blogs/77/Posts/19107/0246-sql-server-2012-filestream-and-filetable-related-dmvs-and-catalog-views.aspx

     

• SQL Visualization in the Spreadsheet

  http://beyondrelational.com/modules/2/blogs/925/posts/19117/sql-visualization-in-the-spreadsheet.aspx

     

• SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.

  http://beyondrelational.com/modules/24/syndicated/463/Posts/19122/sql-server-tsql-to-find-records-matching-certain-criteria-in-all-the-tables-of-a-db.aspx

     

• Databases Five Years from Today

  http://www.brentozar.com/archive/2013/03/databases-five-years-from-today/

     

• Query Optimization Research Papers

  http://www.benjaminnevarez.com/2013/03/query-optimization-research-papers/

  쿼리 최적화 관련 좋은 링크가 달려있네요^^

     

• LAST WEEKS TOP 20 "READING" LINKS #23

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

     

• A TOP Query

  http://sqlblog.com/blogs/rob_farley/archive/2013/03/11/a-top-query.aspx

     

• uantifying the Cost of Compression

  http://blog.kejser.org/2013/03/11/quantifying-the-cost-of-compression/

     

ETC        

• MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

  http://www.mysqlperformanceblog.com/2013/03/11/mysql-5-6-vs-5-5-on-the-star-schema-benchmark/

     

• MySQL performance: Impact of memory allocators (Part 2)

  http://architects.dzone.com/articles/mysql-performance-impact

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

SQL

• Trigger Authoring Decision Tree

  http://sqlblog.com/blogs/merrill_aldrich/archive/2013/03/06/trigger-authoring-decision-tree.aspx

     

  Ad-Hoc XML File Querying

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

     

• Developers: Check Your SQL Server's Health

  http://www.brentozar.com/archive/2013/03/developers-check-your-sql-servers-health/

     

• THAT'S ACTUALLY A DUPLICATE INDEX

  http://www.jasonstrate.com/2013/03/thats-actually-a-duplicate-index/

     

• The Bit Bucket (Greg Low): IDisposable

  http://sqlblog.com/blogs/greg_low/archive/2013/03/06/windows-azure-sql-reporting-now-configurable-in-the-new-portal.aspx

SQL

• Microsoft Update offering SQL Server 2012 SP1 Cumulative Update 2

  http://www.sqlskills.com/blogs/glenn/microsoft-update-offering-sql-server-2012-sp1-cumulative-update-2/

     

• Performance analysis with Wireshark

  http://sqlscope.wordpress.com/2013/03/05/performance-analysis-with-wireshark/

  Wireshark 는 인터넷-PC에서 오가는 모든 패킷을 보고 분석할 수 있는 프로그램

• Job History row limiter

  http://sqlblog.com/blogs/joe_chang/archive/2013/03/05/job-history-row-limiter.aspx

     

• SQL Server 2012 Window Function Basics

  https://www.simple-talk.com/sql/t-sql-programming/sql-server-2012-window-function-basics/

     

• Microsoft's Database Research Lab Conceives PolyBase to Easily Join Relational Data With Data From Hadoop

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/03/05/microsoft-s-database-research-lab-conceives-polybase-to-easily-join-relational-data-with-data-from-hadoop.aspx

     

• DMV-1 : Who All Are connected ?

  http://mssqlfun.com/2013/03/05/dmv-1-who-all-are-connected-sys-dm_exec_connections/

     

• Working with SQL Server Recovery Models

  http://www.sqlservercentral.com/articles/Recovery+Model/96509/

     

• Welcome to SQL Server Day - Spatial style

  http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/759/welcome-to-sql-server-day-spatial-style

     

• Skip Log Reader error in SQL Server replication - How to

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

     

• SQL SERVER – Exporting Query Results to CSV using SQLCMD

  http://blog.sqlauthority.com/2013/03/05/sql-server-exporting-query-results-to-csv-using-sqlcmd/

     

기타

• The Google Interviews

  http://www.kchodorow.com/blog/2013/03/04/the-google-interviews

  몽고DB에서는 유명한 사람인데, 구글로 입사를 했다네요. 인터뷰 내용이에요.        

     

• Wireshark란? (실행, 다운 방법)

  http://cafe.naver.com/bwys/252

안녕하세요. 주디아줌마입니다.
봄인데도 아직도 쌀쌀하네요.^^ 

SQL

• SQL Server 2012 Diagnostic Information Queries (March 2013)        - 그렌아저씨

  https://sqlserverperformance.wordpress.com/2013/03/03/sql-server-2012-diagnostic-information-queries-march-2013/

  쥑이는 스크립트이죠^^

     

• SQL Server Maintenance Plans and Parallelism – CHECKDB

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

  (CHECKDB, CHECKTABLE, CHECKFILEGROUP, and CHECKCATALOG) is single-threaded in Standard Edition에요...

  엔터버젼에서는 max-dop 설정 값에 따라 실행되네요.

• Execution Plan Sanitizer v2        

  http://www.sqlskills.com/blogs/jonathan/execution-plan-sanitizer-v2/        

     

• What events are captured in SQL Transaction Logs?                

  http://www.sqlserver-dba.com/2013/02/what-events-are-captured-in-sql-transaction-logs.html

     

• PRESENTATION MATERIALS "A FUNCTION IS A FUNCTION"

  http://www.jasonstrate.com/2013/02/presentation-materials-a-function-is-a-function/

     

• Six Scary SQL Surprises

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

• MARCH 2013 – MONTHLY SQL SERVER CHECKLIST

  http://www.jasonstrate.com/2013/03/march-2013-monthly-sql-server-checklist/

• LAST WEEKS TOP 10 "READING" LINKS #22

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

  CHECK~~ http://www.sqlballs.com/2013/02/windows-2012-for-dba-setting-your.html

     

• Log cannot be reused, see the log_reuse_wait_desc column in sys.databases – SQL Server Error 9002        

  http://www.sqlserver-dba.com/2013/03/log-cannot-be-reused-see-the-log_reuse_wait_desc-column-in-sysdatabases-sql-server-error-9002.html

     

• How to recover a SQL Server login password.

  http://www.sqlservercentral.com/articles/password+cracking/96540/

     

• How to move a SQL Server Log Shipped Secondary Database to Different SQL Server

  http://www.mssqltips.com/sqlservertip/2873/how-to-move-a-sql-server-log-shipped-secondary-database-to-different-sql-server/

     

• Loop through Flat Files in SQL Server Integration Services

  http://www.mssqltips.com/sqlservertip/2874/loop-through-flat-files-in-sql-server-integration-services/

     

• Disabling vs. Dropping Indexes

  http://www.brentozar.com/archive/2013/02/disabling-vs-dropping-indexes/

     

• A Look At DBCC CHECKCONSTRAINTS and I/O

  http://www.sqlperformance.com/2013/02/io-subsystem/dbcc-checkconstraints

     

• Import data - solving data convertion and truncation error

  http://beyondrelational.com/modules/2/blogs/70/posts/19094/import-data-solving-data-convertion-and-truncation-error.aspx

  varchar를 쓰면 기본 50byte를 쓴다고 하네요^^

     

• SQL Server - What is the purpose of DENSITY in STATISTICS?

  http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/756/sql-server-what-is-the-purpose-of-density-in-statistics

     

• SQL Server Statistics Questions We Were Too Shy to Ask

  https://www.simple-talk.com/sql/performance/sql-server-statistics-questions-we-were-too-shy-to-ask/

     

• SQL SERVER – SSMS does NOT Print NULL Values

  http://blog.sqlauthority.com/2013/03/04/sql-server-ssms-does-not-print-null-values/

     

• Defining Post Deployment Scripts in the SQL Server Data Tools

  http://www.mssqltips.com/sqlservertip/2852/defining-post-deployment-scripts-in-the-sql-server-data-tools/

     

• SQL SERVER – Beginning SQL 2012 – Basics of CONVERT and FORMAT Function – Abstract from Joes 2 Pros Volume 5

  http://blog.sqlauthority.com/2013/03/01/sql-server-beginning-sql-2012-basics-of-convert-and-format-function-abstract-from-joes-2-pros-volume-5/

     

• Traversing the Facebook Graph using Data Explorer

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/02/28/traversing-the-facebook-graph-using-data-explorer.aspx

  오호 신기하네요..ㅋㅋ 쥑이네요.. 페이스북 데이타를 가지고 통계까정. 쥑인다. ㅎ.ㅎ

     

• Where do I find the Performance Dashboard for SQL Server 2008?

  http://www.mssqltips.com/sqlservertip/2896/where-do-i-find-the-performance-dashboard-for-sql-server-2008/

     

• Redundant Query Plan Branches

  http://www.sqlskills.com/blogs/joe/redundant-query-plan-branches/

     

기타

• NoSQL Style - A Gangnam Style Parody

  http://highscalability.com/blog/2013/3/4/nosql-style-a-gangnam-style-parody.html

  동영상 보시면 대략 NoSQL 감이 오실거에요.ㅋㅋ

     

• The Daily Checklist

  http://zenhabits.net/check/

  DB 데일리 체크가 아닙니다^^

     

• InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

  http://www.mysqlperformanceblog.com/2013/03/04/innodb-full-text-search-in-mysql-5-6-part-2-the-queries/

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

황금연휴 잘 보내셨나요? 3일간 애둘보느라~ 힘들었네요. 헉헉 ㅠㅠ

SQL

• List all Objects and Indexes per Filegroup / Partition

  http://basitaalishan.com/2013/03/03/list-all-objects-and-indexes-per-filegroup-partition/

     

• SQL SERVER – Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples

  http://basitaalishan.com/2013/03/03/list-all-objects-and-indexes-per-filegroup-partition/

     

• switchoffset built-in function can cause incorrect cardinality estimate

  http://blogs.msdn.com/b/psssql/archive/2013/03/02/switchoffset-built-in-function-can-cause-incorrect-cardinality-estimate.aspx

     

• Using the Query Designer to convert non-ANSI joins to ANSI

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/03/02/using-the-query-designer-to-convert-non-ansi-joins-to-ansi.aspx

     

• SQL Server has good default values

  http://www.sqlserver-dba.com/2013/03/sql-server-has-good-default-values.html

     

• DBAs moving to architect, constant learning, Azure, big data

  http://sqlblog.com/blogs/greg_low/archive/2013/03/02/sql-down-under-show-56-with-guest-thomas-larock-is-now-online-dbas-moving-to-architect-constant-learning-azure-big-data.aspx

  준비해야되는 건가요 ㅠㅠ

     

• SDU Show 54 with guest Grant Fritchey

  http://www.sqldownunder.com/Portals/0/SDUShowFiles/SDU54FullShow.mp3

  how to trace and optimize queries, along with tips on reading execution plans

     

• Public Release, SQL Server File Layout Viewer

  http://sqlblog.com/blogs/merrill_aldrich/archive/2013/03/01/public-release-sql-server-file-layout-viewer.aspx

  굿~~ 좋은 툴이죵?

     

• Big Data Analytics with Hive, Windows & SQL Server

  http://www.sqlmag.com/blog/sql-server-bi-blog-17/business-intelligence/big-data-analytics-hive-windows-amp-sql-server-144784

     

• Recommended reading from mrdenny for March 01, 2013

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

     

• One or more files do not match the primary file of the database – Error 5173

  http://www.sqlserver-dba.com/2013/03/one-or-more-files-do-not-match-the-primary-file-of-the-database-error-5173.html

     

• Obfuscate sensitive data in your execution plans

  http://www.sqlperformance.com/2013/03/t-sql-queries/obfuscate-execution-plans

     

기타

• 그래서 "빅데이터(Big Data)"가 도대체 뭐냐고…

  http://kimws.wordpress.com/2013/03/03/%EA%B7%B8%EB%9E%98%EC%84%9C-%EB%B9%85%EB%8D%B0%EC%9D%B4%ED%84%B0big-data%EA%B0%80-%EB%8F%84%EB%8C%80%EC%B2%B4-%EB%AD%90%EB%83%90%EA%B3%A0/

  여기서 "상대적으로 구인하기 쉬운 DBA"가 마음이 아프네요 ㅠㅠ

     

• Your own MySQL Database Server on an Android Table

  http://architects.dzone.com/articles/your-own-mysql-database-server

  오호~~

     

• Building Student Hands On Labs in Azure for Free

  http://mythoughtsonit.com/2013/02/building-student-hands-on-labs-in-azure-for-free/

     

• Bootstrapping SQL Server bloggers and blog readers with Twitter!

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/03/04/bootstrapping-sql-server-bloggers-and-blog-readers-with-twitter.aspx

SQL

• 5 SQL Server Virtualization Tips

  http://www.sqlmag.com/article/sql-server/virtualization-tips-145319

     

• dba_runCHECKDB v2(012)

  http://spaghettidba.com/2013/02/27/dba_runcheckdb-v2012/

     

• O'Reilly Strata: Busting Big Data Adoption Myths–Part 2

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/27/o-reilly-strata-busting-big-data-adoption-myths-part-2.aspx

     

• Log Shipping: Preparing for Disaster

  http://www.brentozar.com/archive/2013/02/log-shipping-preparing-for-disaster/

     

• Database server : Monitoring versus reporting

  http://www.sqlserver-dba.com/2013/02/database-server-monitoring-versus-reporting.html

  http://www.sqlserver-dba.com/2011/06/sql-server-dba-top-10-automation-tasks.html                -- 괜찮은 링크 추가.ㅋㅋ

     

• Understanding GRANT, DENY, and REVOKE in SQL Server

  http://www.mssqltips.com/sqlservertip/2894/understanding-grant-deny-and-revoke-in-sql-server/

     

기타

• MySQL optimizer: ANALYZE TABLE and Waiting for table flush

  http://www.mysqlperformanceblog.com/2013/02/27/be-cautious-with-analyze-table/

• Google Cloud Platform Case Studies        

  http://cloud.dzone.com/articles/google-cloud-platform-case