2013.06.14

금일은 회사 전사 워크샾날입니다. 강원도 횡성으로 고고~ 이 더위에 체육대회를 까악 까악~~

   

   

SQL

   

• The Accidental DBA (Day 13 of 30): Consistency Checking - Erin Stellato

  http://www.sqlskills.com/blogs/erin/the-accidental-dba-day-13-of-30-consistency-checking

   

• False warning "A significant part of sql server process memory has been paged out"

  http://mssqlwiki.com/2013/06/13/false-warning-a-significant-part-of-sql-server-process-memory-has-been-paged-out/

  진짜 이분 사이트는 쥑이는 듯~~ 내공이 보여요~

     

• Preparing to Upgrade your SQL Server

  https://www.simple-talk.com/sql/database-administration/preparing-to-upgrade-your-sql-server/

     

• Maximizing Throughput with TVPs

  http://sqlcat.com/sqlcat/b/technicalnotes/archive/2013/06/13/maximizing-throughput-with-tvps.aspx

     

• My pitch for async stats auto updates and... Yikes! A SQL Server stats update async memory leak!!!

  http://sql-sasquatch.blogspot.kr/2013/06/my-pitch-for-async-stats-auto-updates.html

     

• THE SIDE EFFECT OF NOLOCK (VIDEO)

  http://www.jasonstrate.com/2013/06/the-side-effect-of-nolock-video

     

• SECURITY QUESTIONS: MIGRATE LOGINS BETWEEN SERVERS

  http://www.jasonstrate.com/2013/06/security-questions-migrate-logins-between-servers

   

• Getting Started with Microsoft Big Data, Hive and HDInsight Jump Start

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/13/getting-started-with-microsoft-big-data-hive-and-hdinsight-jump-start.aspx

   

• Plan Operator Tuesday round-up

  http://sqlblog.com/blogs/rob_farley/archive/2013/06/13/plan-operator-tuesday-round-up.aspx

  재미있는 실행계획이네요^^ ㅋㅋㅋㅋ

   

• Upcoming Database Design Pre-Cons

  http://sqlblog.com/blogs/louis_davidson/archive/2013/06/13/upcoming-database-design-pre-cons.aspx

   

• Control Flow vs. Data Flow Demo

  http://www.sqlskills.com/blogs/joe/control-flow-vs-data-flow-demo/

     

• Batch ETL of Multiple Data Files Using an SSIS Foreach Loop Container

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

     

• Moving Data From Excel to SQL Server - 10 Steps to Follow

  https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/

     

• Export to XML Using SSIS

  http://www.sql-server-performance.com/2013/export-to-xml-using-ssis/

     

• SQL Server Integration Services package to delete files from a Network or Local path based on date

  http://www.mssqltips.com/sqlservertip/2930/sql-server-integration-services-package-to-delete-files-from-a-network-or-local-path-based-on-date/

     

     

Other

   

• NoSQL for SQL Professionals

  http://architects.dzone.com/articles/nosql-sql-professionals

  동영상인데, SQL과 NoSQL에 대한 차이~? 저도 살짝 5분 들었습니다 ㅠㅠ

     

• Relational Databases vs. NoSQL Tradeoffs for Startups

  http://architects.dzone.com/articles/relational-databases-vs-nosql

   

• Busting 4 Modern Hardware Myths - Are Memory, HDDs, And SSDs Really Random Access?

  http://highscalability.com/blog/2013/6/13/busting-4-modern-hardware-myths-are-memory-hdds-and-ssds-rea.html

  각각의 장비에 대한 정리가 잘 되어 있네요^^ 개념 잡기 좋을 듯 ㅎㅎㅎ (동영상도 있네요^^)_

     

• MQTT Packet 모니터링

  http://mimul.com/pebble/default/2013/06/13/1371094782475.html