Monday Morning SQL Break – December 28, 2015

unicorn pirateIt’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog.

Most Popular Article Shared

Last weeks most popular link is an article by Paul White (Blog | @SQL_Kiwi).  In this post, Paul goes into how temporary tables behave within stored procedures.  It’s a great read and you should check it out if you haven’t already.

Last Week’s Popular Posts

The most popular posts on this blog in the week are:

  1. 31 Days of SSIS – The Introduction (561)
  2. 31 Days of SSIS – Raw Files Are Awesome (1/31) (269)
  3. 31 Days of SSIS as a Book (241)
  4. Get Just The Tools: SSMS Download (219)
  5. Determining Filegroup for a Table (115)
  6. 31 Days of SSIS – Using Breakpoints (2/31) (114)
  7. XQuery for the Non-Expert – Value (101)
  8. Security Questions: Difference Between db_datawriter and db_ddladmin? (85)
  9. The Side Effect of NOLOCK (81)
  10. Looking to SQL Server 2014 High Availability In Standard Edition (78)

Last Week’s Top ’18’ “Reading” Links

Along with the most popular link, here are the top ‘eighteen’ items relating to SQL Server, technology and careers that were shared last week. If you missed them throughout the week, here’s the opportunity to get caught up on some items that other’s read after I linked them out.

  1. Temporary Tables in Stored Procedures [45 clicks]
  2. Scale-Up (OLTP)—a Technical Reference Guide for Designing Mission-Critical OLTP Solutions [29 clicks]
  3. 10 Mistakes Intelligent People Never Make Twice [24 clicks]
  4. Under The Hood With SQL Server Batch Mode Part 4: Understanding CPU Architectures [21 clicks]
  5. Understanding how SQL Server handles Service Isolation [18 clicks]
  6. RECOMPILE Hints and Execution Plan Caching [16 clicks]
  7. The 3 Most Inspiring TED Talks You Must See [14 clicks]
  8. Detecting merry-go-round scans? Rambling about trace flags 8048 and 8015 [13 clicks]
  9. Statistics (Part 3) – Histograms [13 clicks]
  10. Questions That Make A Difference [12 clicks]
  11. Statistics (Part 6) – Computed Columns [12 clicks]
  12. Sample Size and the Duration of UPDATE STATISTICS: Does It Matter? [11 clicks]
  13. Read-Only Access to Virtual Center for DBAs [10 clicks]
  14. If you fail to plan for your scale, you’ll end up with no workload at all [10 clicks]
  15. Azure DocumentDB: JavaScript as Modern Day T-SQL [9 clicks]
  16. How to Overcome the Naysayers [8 clicks]
  17. Matchbox: Large Scale Bayesian Recommendations [5 clicks]
  18. Sentiment Analysis with Microsoft APS and StreamInsight [4 clicks]

Last Week’s Posts From Previous Years

Sometimes the most useful content on a blog wasn’t written in the past week, it’s often other articles shared in the past that resonate with readers. Check out the following links that I published in past years over the past week:

  1. Can You Dig It? – StmtUseDb Element (2010-12-21)
  2. It’s A Data Type Conversion Chart (2012-12-21)
  3. Can You Dig It? – StmtCond Element (2010-12-22)
  4. Can You Dig It? – StmtCursor and StmtReceive Elements (2010-12-28)

Other Items Shared

Of course, no week would be complete without a few off-topic links. These have nothing to do with technology or your career, but they are interesting and worth a second look.

  1. 3 Reasons Why Melissa Harris Perry’s ‘Star Wars’ Rant Was Totally Out Of Line [33 clicks]
  2. Lawrence Kasdan on the ‘crazy different’ Han Solo film and where ‘Star Wars’ will go from here [29 clicks]
  3. Rick Grimes Would’ve Been So Different Had ‘The Walking Dead’ Landed Its First Casting Choice [25 clicks]
  4. The women of ‘Star Wars’ speak out about their new Empire [15 clicks]
  5. Mel Brooks confirms development on Spaceballs sequel, hopefully with the original cast [13 clicks]
  6. Hollywood’s Christmas is being ruined by unprecedented leaks [12 clicks]
  7. Mark Hamill skips ‘Star Wars’ appearance to visit sick kids [8 clicks]
  8. Use Dynamic Data Masking in SQL Server 2016 CTP 2.1 [7 clicks]
  9. White Christmas, past and present [5 clicks]
  10. Rolling Stone urges court to throw out UVa grads’ lawsuit [3 clicks]

Got something you think I should read and share, leave a comment below. Also, if you want to see all of the links that were tweeted out last week?