2013.04.05

   

SQL

   

• A SQL Server Hardware Tidbit a Day – Day 4        - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/a-sql-server-hardware-tidbit-a-day-day-4/

   

• The PUBLIC role – Do not use it for database access!

  http://basitaalishan.com/2013/04/04/the-public-role-do-not-use-it-for-database-access/

     

• Optimizer Limitations with Filtered Indexes

  http://www.sqlperformance.com/2013/04/t-sql-queries/optimizer-limitations-with-filtered-indexes

  필터드 인덱스 쓸때 고려해야 할 부분이 있네요.

  - 조인 조건

  - 필터드 인덱스는 옵티마이저에게 유니크 정보를 제공하지 않는다.

     

• DBAs vs Devs: ORMs, Caching & Access to Prod

  http://www.brentozar.com/archive/2013/04/dbas-vs-devs-orms-caching-access-to-prod/

     

• Disaster Recovery in the Enterprise – Paying the Price to Avoid Extra Costs

  https://www.simple-talk.com/sql/backup-and-recovery/disaster-recovery-in-the-enterprise-%E2%80%93-paying-the-price-to-avoid-extra-costs/

     

• Detecting Database Drift using SSDT

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/04/04/detecting-database-drift-using-ssdt.aspx

     

• Top Six SQL Monitor Metrics for Analysis

  https://www.simple-talk.com/sql/sql-tools/top-six-sql-monitor-metrics-for-analysis/

     

• Error logging with Bulk Insert

  http://www.sqlservercentral.com/articles/bulk+insert/97017/

     

• SQL Server 2012 Window Function Basics

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

     

• SQL Server Alerts with Text Messaging from SQL Server Database Mail

  http://www.mssqltips.com/sqlservertip/2922/sql-server-alerts-with-text-messaging-from-sql-server-database-mail/

     

기타

   

• SQL Server 2012 Common Criteria Certification

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/04/04/sql-server-2012-common-criteria-certification.aspx

     

• PostgreSQL E.1. Release 9.2.4

  http://www.postgresql.org/docs/9.2/static/release-9-2-4.html

     

• 한번에 보는 자료 구조

  http://www.facebook.com/photo.php?fbid=477172422348934&set=o.352245738171385&type=1&relevant_count=1&ref=nf

     

• 한국 빅데이터, 거짓말에 물들다

  http://www.zdnet.co.kr/news/news_view.asp?artice_id=20130404085036&type=xml

  쩝..