2013.03.04

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

황금연휴 잘 보내셨나요? 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