2013.02.18 (1)

   

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

날씨가 포근하네요~~ 이번주는 SQL Summit주네요 ~~ 재미난 이슈들 많을 듯...

힘찬 월요일을 만듭시다. 아자아자~~

   

   

SQL

   

• MVP Summit 2013 - Arrivo a Bellevue

  http://blogs.dotnethell.it/suxstellino/MVP-Summit-2013-Arrivo-a-Bellevue__19058.aspx

  아... 나도 가고싶다.. 사진에 닌자고 시리즈와 아래 사진에 이름은 먼지 모르지만 성욱씨랑 이미지가 비슷하넹.ㅋㅋ

     

• Fun with dates

  http://sqlserver365.blogspot.kr/2013/02/fun-with-dates.html

     

• SQL SERVER – Fix : Error – sqljdbc_auth.dll Issue – com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed

  http://blog.sqlauthority.com/2013/02/17/sql-server-fix-error-sqljdbc_auth-dll-issue-com-microsoft-sqlserver-jdbc-sqlserverexception-the-tcpip-connection-to-the-host-localhost-port-1433-has-failed/

     

• PASS BAC PREVIEW SERIES: SQL Professionals and the World of Self-service BI and Big Data

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/15/pass-bac-preview-series-sql-professionals-and-the-world-of-self-service-bi-and-big-data.aspx

   

• The Halloween Problem – Part 2

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

     

• Columnstore Segment Population Skew

  http://www.sqlskills.com/blogs/joe/columnstore-segment-population-skew/

  parallel nonclustered Columnstore index creations 일때 문제가 있네요.

     

• Table Distribution Across Data Files

  http://sqlsalt.com/table-distribution-across-data-files/

  DataFile 정보 결과가 이쁘게 나오네요^^

     

• Could not find the Distributor or the distribution database for the local server-Error while posts a tracer token in Replication

  http://beyondrelational.com/modules/2/blogs/88/Posts/18945/could-not-find-the-distributor-or-the-distribution-database-for-the-local-server-error-while-posts-a.aspx

     

• Database Security Countermeasures against hacker attacks

  http://www.sqlserver-dba.com/2013/02/database-security-countermeasures-against-hacker-attacks.html

  해커님 왔을 때 어떻게 해야 하나요? 이거네요^^

     

• T-SQL Gotcha

  http://sqlserver365.blogspot.kr/2013/02/t-sql-gotcha.html

     

기타

   

• memcache on SSD

  https://github.com/twitter/fatcache

  인민에어 오면 테스트 해봐야징..ㅎㅎ 트윗터에서 발행하는거네요.

     

• InnoDB에서 Auto_Increment를 맹신하지 말자.

  http://gywn.net/2013/02/mysql-innodb-auto-increment/

  학... 어쩐지 중복값이 나오더라니~ 썅~

     

• Using MySQL Sandbox with Percona Server

  http://www.mysqlperformanceblog.com/2013/02/16/using-mysql-sandbox-with-percona-server/

     

• Replication checksums in MySQL 5.6

  http://www.mysqlperformanceblog.com/2013/02/15/replication-checksums-in-mysql-5-6/