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

UPDATE

• SQL Server 2014 Cumulative Update #1 is Available

  http://sqlblog.com/blogs/aaron_bertrand/archive/2014/04/21/sql-server-2014-cumulative-update-1-is-available.aspx

• KB Article: KB #2931693
• 114 fixes listed at time of publication (121 total)
• Build number is 12.0.2342
• Relevant for @@VERSION 12.0.2000 through 12.0.2341

• April 2014 Cumulative Update for SQL Server 2008 R2 SP2        

  http://sqlblog.com/blogs/aaron_bertrand/archive/2014/04/21/april-2014-cumulative-update-for-sql-server-2008-r2-sp2.aspx        

• KB Article: KB #2938478
• 13 fixes listed at time of publication
• Build number is 10.50.4305
• Relevant for @@VERSION 10.50.4000 through 10.50.4304        

     

SQL

• The Repeatable Read Isolation Level- Paul White

  http://www.sqlperformance.com/2014/04/t-sql-queries/the-repeatable-read-isolation-level

• Cardinality Estimation for Correlated Columns

  http://www.sqlpassion.at/archive/2014/04/22/cardinality-estimation-for-correlated-columns

     

• SQL Server XML Questions You Were Too Shy To Ask

  https://www.simple-talk.com/sql/learn-sql-server/sql-server-xml-questions-you-were-too-shy-to-ask/

     

• SQL Server: Win some, learn some... try a whole buncha

  http://sql-sasquatch.blogspot.kr/2014/04/sql-server-win-some-learn-some-try.html

     

• Dangers of giving dbo in MSDB

  http://jongurgul.com/blog/dangers-giving-dbo-msdb

     

• DAX: Always get the Latest date for a slicer

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/22/dax-always-get-the-latest-date-for-a-slicer.aspx

     

• Microsoft Azure SQL Database Security - Firewall Configuration

  http://www.databasejournal.com/features/mssql/microsoft-azure-sql-database-security-firewall-configuration.html

     

Other

• Using mysqldump and the MySQL binary log ? a quick guide on how to backup and restore MySQL databases

  http://scriptingmysql.wordpress.com/2014/04/22/using-mysqldump-and-the-mysql-binary-log-a-quick-guide-on-how-to-backup-and-restore-mysql-databases/

SQL

• SQL Server Diagnostic Information Queries for April 2014

  http://sqlserverperformance.wordpress.com/2014/04/18/sql-server-diagnostic-information-queries-for-april-2014/

• Delayed durability: performance boost for certain workloads

  http://sqlscope.wordpress.com/2014/04/21/delayed-durability-performance-boost-for-certain-workloads/

     

• Disabling An Index Removes Index Data

  http://shaunjstuart.com/archive/2014/04/disabling-an-index-removes-index-data/

     

• New Book: SQL Server 2014 Query Tuning & Optimization

  http://www.benjaminnevarez.com/2014/04/new-book-sql-server-2014-query-tuning-optimization/

     

• Unexpected View Performance

  http://www.sqlservercentral.com/articles/Views/71787/

     

• Auto Fix Orphaned Users

  http://sqlity.net/en/2353/auto-fix-orphaned-users/

     

• The SQL Server Encryption Hierarchy

  http://sqlity.net/en/2357/encryption-hierarchy/

     

• Web Services And POST Requests In Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/19/web-services-and-post-requests-in-power-query.aspx

     

• Collation: Temporary objects and variables: Demonstration

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/21/collation-temporary-objects-and-variables-demonstration.aspx

     

• Central Management Studio CMS

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/21/central-management-studio-cms.aspx

     

• Automating Database Restores

  http://www.sqlservercentral.com/articles/Backup/108907/

     

LINKS

• Friday Followup For April 18, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/04/18/friday-followup-for-april-18-2014.aspx

     

Other

• MySQL Partitioning ? A Quick Look at Partitioning ? Separate Your Data for Faster Searches

  http://scriptingmysql.wordpress.com/2014/04/18/mysql-partitioning-a-quick-look-at-partitioning-separate-your-data-for-faster-searches/

     

• R and the weather in the local news

  http://blog.revolutionanalytics.com/2014/04/r-and-the-weather-in-the-local-news.html

     

• 무료 node.js 개발툴

  http://bcho.tistory.com/895

     

• 빠르게 훝어 보는 node.js - #9 Socket.IO 1/2

  http://bcho.tistory.com/896