Monday Morning SQL Break – January 11, 2016


unicorn pirateIt’s Monday time for this week’s weekly 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 blog post by Bob Beauchemin (blog) on memory-optimized table variables.  It covers their metadata and garbage collection.  Memory-optimized table variables are probably one of my favorite features of SQL Server 2014 – check out this post if you have the time.

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (795)
  2. 31 Days of SSIS – Raw Files Are Awesome (1/31) (353)
  3. 31 Days of SSIS as a Book (317)
  4. Get Just The Tools: SSMS Download (300)
  5. Looking to SQL Server 2014 High Availability In Standard Edition (137)
  6. Security Questions: Removing Logins From Databases (134)
  7. 31 Days of SSIS – Using Breakpoints (2/31) (97)
  8. Determining Filegroup for a Table (95)
  9. The Side Effect of NOLOCK (92)
  10. Security Questions: Difference Between db_datawriter and db_ddladmin? (77)

Last Week’s Top 20 “Reading” Links

Along with the most popular link, here are the top twenty 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. SQL Server 2014 memory-optimized table variables – metadata and garbage collection [33 clicks]
  2. Scoring Data from MySQL or SQL Server using KNIME and ADAPA [31 clicks]
  3. The Case of the Cardinality Estimate Red Herring [29 clicks]
  4. 4 Job Search Mistakes Employers WILL Notice [24 clicks]
  5. How to Take Effective Notes [19 clicks]
  6. Less Than Dot : Blog : Awesome [17 clicks]
  7. How to Design Work Projects for Maximum Learning [16 clicks]
  8. How It Works: XEvent Output and Visualization [16 clicks]
  9. Tracking tempdb growth using Extended Events [16 clicks]
  10. How filtered indexes could be a more powerful feature [15 clicks]
  11. A Full Backup Includes Everything (with a caveat) [15 clicks]
  12. Monitoring SQL Server Disk Space [14 clicks]
  13. Getting Ready for Big Data: Prepping the Data Warehouse [12 clicks]
  14. Buffer Latch Error Restoring SQL Server Database [12 clicks]
  15. Step-By-Step: Creating a File Share in Azure [11 clicks]
  16. Correlating SQL Server 2014 cardinality events and query plan [11 clicks]
  17. Creating a Data Culture [10 clicks]
  18. Something’s Brewing with Azure Data Factory Part 2 [10 clicks]
  19. The Powershell Challenge–Day 9 The Pipelines, deeper [9 clicks]
  20. Your 31 Day Action Plan to Getting More Blog Readers [9 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. Data Reset Trick (2006-01-04)
  2. Wait Stat Categories (2010-01-04)
  3. XQuery for the Non-Expert – Binary Values (2011-01-04)
  4. 31 Days of SSIS – Folder Structures (4/31) (2011-01-04)
  5. Can You Dig It? – Find Estimated RowCounts (2011-01-05)
  6. 31 Days of SSIS – One Variable to Rule Them All (5/31) (2011-01-05)
  7. 31 Days of SSIS as a Book (2012-01-05)
  8. 31 Days of SSIS – Recursive SSIS Package (6/31) (2011-01-06)
  9. 31 Days of SSIS – What The Sorts?! (7/31) (2011-01-07)
  10. Scripting Object Level Permissions (2009-01-08)
  11. 31 Days of SSIS – Merge Join Is My Friend (8/31) (2011-01-08)
  12. 31 Days of SSIS – Override Variables (9/31) (2011-01-09)
  13. Determining Default Trace Location (2013-01-09)
  14. The DBA That Practices Database Restores (2014-01-10)
  15. 31 Days of SSIS – Pivot Transformation (10/31) (2011-01-10)
  16. 31 Days of SSIS – UnPivot Transformation (11/31) (2011-01-11)

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. U.S. Marshals Raid Hoverboard Booth at CES [27 clicks]
  2. 13 Hilarious Reactions Muslims Had On Twitter To ISIS Leader [25 clicks]
  3. Why Your Detox Is Bullsh*t [23 clicks]
  4. The Princess Bride – Fun Facts From Behind the Scenes! [23 clicks]
  5. Couple on Hike Does Not Get Engaged. Woman ‘Literally’ Jumps Off Cliff [20 clicks]
  6. Samuel L Jackson says he carries a firearm and is against gun control [17 clicks]
  7. This One Of A Kind Star Destroyer CPU Will Conquer Your Imagination [15 clicks]
  8. THE FORCE AWAKENS Monopoly to Include Rey After STAR WARS Fan Outrage [15 clicks]
  9. Internet Explorer 8, 9 and 10 Finally Die Next Week [10 clicks]
  10. Hooray For Hollywood: Get Ready For All Of The Comic Book Themed Movies Coming Out In 2016 [9 clicks]
  11. This is not even my final form! [7 clicks]
  12. R.I.P. Jason Wingreen, The Original Voice of Boba Fett in Star Wars: The Empire Strikes Back [6 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?