2014.02.12

   

SQL

   

• More on using Transaction SID from the transaction log

  http://www.sqlskills.com/blogs/paul/using-transaction-sid-transaction-log

   

• Best approaches for grouped median

  http://www.sqlperformance.com/2014/02/t-sql-queries/grouped-median

   

• DELETE operations on tables

  http://www.sqlpassion.at/archive/2014/02/11/delete-operations-on-tables

     

• Scratchpad: #SQLServer backup failures after enabling T1118 & T2371

  http://sql-sasquatch.blogspot.kr/2014/02/scratchpad-sqlserver-backup-failures.html

     

• Calculating the length of a hash in SQL Server

  http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/calculating-the-length-of-a-hash-in-sql-server/

     

• Using Row_Number to pick the correct entry

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/11/using-row-number-to-pick-the-correct-entry.aspx

     

• [SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server

  http://thesqlpro.com/2014/02/11/sql-snacks-video-instant-file-initialization

     

• SQL SERVER ? How to filter databases in sp_MSforeachdb

  http://raresql.com/2014/02/11/sql-server-how-to-filter-databases-in-sp_msforeachdb/

   

• T-SQL Tuesday #51 ? Place Your Bets

  http://voiceofthedba.wordpress.com/2014/02/11/t-sql-tuesday-51-place-your-bets/

     

• Why is Your SQL Server Slow? Here's a Hint

  http://www.sqlsoldier.com/wp/sqlserver/whyisyoursqlserverslowheresahint

     

• Scheduled Data Refresh in Power BI #powerbi #powerpivot

  http://www.sqlserver.co.uk/index.php/scheduled-data-refresh-in-power-bi-powerbi-powerpivot/

     

• SSAS: DistinctCount

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/11/ssas-distinctcount.aspx

     

   

Other

   

• R skills attract the highest salaries

  http://blog.revolutionanalytics.com/2014/02/r-salary-surveys.html

     

• Redis 3.0.0 beta-1 is out

  http://data.story.lu/2014/02/11/redis-3-0-0-beta-1-is-out

  클러스터가 나왔군여~~ 오호~~

     

• PERFORMANCE_SCHEMA vs Slow Query Log

  http://www.mysqlperformanceblog.com/2014/02/11/performance_schema-vs-slow-query-log/

     

• WITHer Recursive Queries?

  http://www.mysqlperformanceblog.com/2014/02/11/wither-recursive-queries/