2014.04.23

   

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/