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/

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

SQL

• Cost Threshold for Parallelism

  http://sqlserver365.blogspot.kr/2013/02/cost-threshold-for-parallelism.html

• Statistics on Ascending Keys

  http://www.benjaminnevarez.com/2013/02/statistics-on-ascending-keys/

     

• Temp table caching improvement for table valued parameters in SQL Server 2012

  http://blogs.msdn.com/b/psssql/archive/2013/02/26/temp-table-caching-improvement-for-table-valued-parameters-in-sql-server-2012.aspx

     

• Discovering resultset definition of DBCC commands in SQL Server 2012

  http://spaghettidba.com/2013/02/26/discovering-resultset-definition-of-dbcc-commands-sql-server-2102/

     

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

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

     

• Full Text Searches on Documents in FileTables

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

     

• Detect SQL Server CPU Pressure

  http://www.mssqltips.com/sqlservertip/2890/detect-sql-server-cpu-pressure/

     

• SET STATISTICS IO – What is Scan count?

  http://sqlwithmanoj.wordpress.com/2013/02/16/set-statistics-io-what-is-scan-count/

     

• SQL SERVER – Beginning SQL 2012 – Aggregation Functions – Abstract from Joes 2 Pros Volume 2

  http://blog.sqlauthority.com/2013/02/26/sql-server-beginning-sql-2012-aggregation-functions-abstract-from-joes-2-pros-volume-2/

     

• SQL Server 2012–what it is and what it isn't

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/02/25/sql-server-2012-what-it-is-and-what-it-isn-t.aspx

     

• Cleaning Up Reporting Services Snapshots

  http://itknowledgeexchange.techtarget.com/sql-server/cleaning-up-reporting-services-snapshots/

     

• ORIGINAL_LOGIN() and SUSER_SNAME() functions

  http://sqldbpool.com/2013/02/25/original_login-and-suser_sname-functions/

     

기타

• NoSQL for NoDBA

  http://architects.dzone.com/articles/nosql-nodba

• Why do we care about MySQL Performance at High Concurrency?

  http://www.mysqlperformanceblog.com/2013/02/26/why-do-we-care-about-performance-at-high-concurrency/        

• ZooKeeper를 활용한 Redis Cluster 관리

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

  제가 관심 있어야하는 redis로 이롷게까지 만들다뉘~ 대단하세요.

     

• NoSQL Job Trends for February 2013

  http://architects.dzone.com/articles/nosql-job-trends-february-2013

  헐.. mongodb가 압도적이네요. 2위는 카산드라, 3위는 hbase, 내 사랑 레디스가 4위

SQL

• THE ACCIDENTAL ARCHITECT

  http://thomaslarock.com/2013/02/the-accidental-architect/        

     

• Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test

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

  이 시리즈들은 최고^^

     

• Script to get the Last Backup Date of database full and t-log backup

  http://sqldbpool.com/2013/02/25/script-to-get-the-last-backup-date-of-database-full-and-t-log-backup/

• SQL Server SINGLE – MULTI – RESTRICTED USER

  http://www.sqlserver-dba.com/2013/02/sql-server-single-multi-restricted-user.html

     

• LAST WEEKS TOP 10 "READING" LINKS #21

  http://www.jasonstrate.com/2013/02/last-weeks-top-10-reading-links-21

     

• Querying with DAX video available on Project Botticelli #dax #ssas #powerpivot

  http://sqlblog.com/blogs/marco_russo/archive/2013/02/25/querying-with-dax-video-available-on-project-botticelli-dax-ssas-powerpivot.aspx

     

• Managing the Database Administrator

  http://www.databasejournal.com/features/db2/managing-the-database-administrator.html

     

• Data Profiling with T-SQL

  http://www.sqlservercentral.com/articles/Data+Profiling/96398/

     

• Backing Up SQL Server Databases Participating In Availability Groups

  http://www.mssqltips.com/sqlservertip/2880/backing-up-sql-server-databases-participating-in-availability-groups/

     

기타

• Hortonworks and Microsoft Bring the Hortonworks Data Platform to Windows

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/25/hortonworks-and-microsoft-bring-the-hortonworks-data-platform-to-windows.aspx

     

• Node.js and MongoLab on Windows Azure

  http://blog.mongolab.com/2013/02/node-js-and-mongolab-on-windows-azure/

     

• A (short) List of Data Science Blogs

  http://www.hilarymason.com/blog/a-short-list-of-data-science-blogs/

     

• Print screen for Remote Desktop

  http://beyondrelational.com/modules/1/justlearned/tips/19033/print-screen-for-remote-desktop.aspx

     

• You can't rollback Redis transactions

  http://openmymind.net/You-Cant-Rollback-Redis-Transaction/

Update

• SQL Server 2008 R2
  • Cumulative Update 11 per SQL Server 2008 R2 SP1

    http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/02/18/cumulative-update-11-for-sql-server-2008-r2-service-pack-1.aspx

       

  • Cumulative Update 5 per SQL Server 2008 R2 SP2

    http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/02/18/cumulative-update-5-for-sql-server-2008-r2-service-pack-2.aspx

• SQL Server 2012
  • Cumulative Update 6 per SQL Server 2012

    http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/02/19/cumulative-update-6-for-sql-server-2012.aspx

SQL

• SQL Performance tuning - Asking the right question

  http://www.sqlserver-dba.com/2013/02/sql-performance-tuning-asking-the-right-question.html

• 7 Things Developers Should Know About SQL Server

  http://www.brentozar.com/archive/2013/02/7-things-developers-should-know-about-sql-server/

  개발자들이 읽어야 할 내용들인데 좋은 내용이 많네요.

     

• A SQL-Based Universal Currency Formatter

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

     

• Testing the StreamInsight Service for Windows Azure

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

     

• 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/

     

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

  http://www.sqlservercentral.com/articles/SQL+Server/95931/

     

• 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/

     

• FEBRUARY 2013 – MONTHLY SQL SERVER CHECKLIST

  http://www.jasonstrate.com/2013/02/february-2013-monthly-sql-server-checklist

     

• LAST WEEKS TOP 10 "READING" LINKS #19

  http://www.jasonstrate.com/2013/02/last-weeks-top-10-reading-links-19

     

ETC

• MongoDB and Hadoop: A Step-by Step Tutorial

  http://blog.mongodb.org/post/43495291219/mongodb-and-hadoop-a-step-by-step-tutorial

     

• Analyzing Slow Query Table in MySQL 5.6

  http://www.mysqlperformanceblog.com/2013/02/18/slow-query-table-in-mysql-5-6/

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

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

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

• 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