2014.04.24

   

SQL

   

• SQL Server bitmap operators, bitmasks and bit arrays

  http://dataidol.com/tonyrogerson/2014/04/23/sql-server-bitmap-operators-bitmasks-and-bit-arrays/

   

• Top Clause and Other Factors in Problematic Execution Plans

  http://sqlblog.com/blogs/joe_chang/archive/2014/04/23/top-clause-and-other-factors-in-problematic-execution-plans.aspx

   

• The Shared Global Allocation Map (SGAM)

  http://sqlity.net/en/2364/sgam/

     

• 6 Essential Tips for Managing SQL Server

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/23/6-essential-tips-for-managing-sql-server.aspx

     

• Developer's Guide to Understanding DBAs [Video]

  http://www.brentozar.com/archive/2014/04/developers-guide-understanding-dbas-video/

     

• SQL Server Partitioning 101

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/23/sql-server-partitioning-101.aspx

     

• Yes, you can install SQL Server 2014 Books Online locally

  http://sqlblog.com/blogs/aaron_bertrand/archive/2014/04/23/yes-you-can-install-sql-server-2014-books-online-locally.aspx

     

• Introducing the Microsoft Analytics Platform System ? the turnkey appliance for big data analytics

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/04/23/introducing-the-microsoft-analytics-platform-system-the-turnkey-appliance-for-big-data-analytics.aspx

     

• Database Normalization Basics

  https://www.simple-talk.com/sql/t-sql-programming/database-normalization-basics

     

• How Do I Show Memory Usage From A Columnstore Index in SQL Server?

  http://joedantoni.wordpress.com/2014/04/23/how-do-i-show-memory-usage-from-a-columnstore-index-in-sql-server/

     

• RS, SharePoint and Forefront UAG Series ? Intro

  http://blogs.msdn.com/b/psssql/archive/2014/04/23/rs-sharepoint-and-forefront-uag-series-intro.aspx

     

• SSAS Deployment Strategies

  http://www.sql-server-performance.com/2014/ssas/

     

LINKS

   

• Last Weeks Top "Reading" Links #80

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/22/last-weeks-top-reading-links-80.aspx

     

Other

   

• Azure Automation

  http://www.scarydba.com/2014/04/23/azure-automation/

     

• 사이드 프로젝트의 효용성 그리고 중요성

  http://www.mimul.com/pebble/default/2014/04/23/1398212595197.html