Monday Morning SQL Break – December 7, 2015

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 week’s most popular link is an blog by Kendra_Little (Blog | twitter) on the new query store in SQL Server and how it functions against OPTION(RECOMPILE).  This is worth the read, so check it out.

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (789)
  2. 31 Days of SSIS – Raw Files Are Awesome (1/31) (354)
  3. Get Just The Tools: SSMS Download (348)
  4. 31 Days of SSIS as a Book (254)
  5. Looking to SQL Server 2014 High Availability In Standard Edition (188)
  6. The Side Effect of NOLOCK (159)
  7. XQuery for the Non-Expert – Value (136)
  8. 31 Days of SSIS – Using Breakpoints (2/31) (130)
  9. Security Questions: What permissions are required to create temporary tables? (110)
  10. Security Questions: Difference Between db_datawriter and db_ddladmin? (95)

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. Does OPTION (RECOMPILE) Prevent Query Store from Saving an Execution Plan? [39 clicks]
  2. Be the change [32 clicks]
  3. A programmer wrote scripts to secretly automate a lot of his job — and email his wife and make a latte [30 clicks]
  4. Inline Nonclustered Indexes [21 clicks]
  5. Using PowerShell to Generate a Transaction Log Restore Script [18 clicks]
  6. Calling all user group leaders! We want to present for you in 2016! [17 clicks]
  7. Why is SQL Server Slow Sometimes – But Only Sometimes? [16 clicks]
  8. Technical Debt [15 clicks]
  9. I Don’t Want To Create Indexes Because It Will Slow Down My Application [14 clicks]
  10. Please help improve SQL Server statistics! [14 clicks]
  11. 5 Questions with Amanda Crisp [14 clicks]
  12. Dan Holmes : Custom Built Statistics [12 clicks]
  13. SQL Server 2012 SP3 Adds Memory Grant and Performance Features [12 clicks]
  14. Test if a File Exists with Powershell [11 clicks]
  15. The Mysterious telemetry_xevents Session in SQL Server 2016 [10 clicks]
  16. Filtering Events in Trace/Profiler and Extended Events [9 clicks]
  17. Savepoints and conditional transactions [9 clicks]
  18. Just Say No [9 clicks]
  19. Analyzing Your Indexing Strategies – Salt Lake City SQLSaturday 2015 [8 clicks]
  20. Relational By Default [7 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. Lost in Translation – Deprecated System Tables – sysprotects (2012-11-30)
  2. Deadlocks on exchangeEvent and threadpool (2009-12-02)
  3. Does Your Stored Procedure Grant Itself Permissions? (2009-12-03)
  4. Lost in Translation – Deprecated System Tables – sysprocesses (2012-12-03)
  5. Lost in Translation – Deprecated System Tables – syslockinfo (2012-12-06)

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. The age of ‘pre-crime’ has arrived [55 clicks]
  2. Acceptance Of Profound-Sounding “Bullsh*t” Linked To Lower Intelligence [25 clicks]
  3. Inside Amazon’s Giant Warehouse That Makes Black Friday Palatable [21 clicks]
  4. Here’s Our First Good Look At Benedict Cumberbatch As Doctor Strange [19 clicks]
  5. Cable crews’ live airing from San Bernardino shooters’ house triggers criticism [8 clicks]
  6. How To Summon A Demon [8 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?