Monday Morning SQL Break – February 22, 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 to an article written by Nelson John on non-clustered indexes.  Since I’m a big fan of indexes, I tend to read any thing that seems good about indexes.  If you try to click through the link, you’ll probably hit a URL error – the correct link should have been

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (819)
  2. 31 Days of SSIS – Raw Files Are Awesome (1/31) (354)
  3. Get Just The Tools: SSMS Download (345)
  4. 31 Days of SSIS as a Book (330)
  5. XQuery for the Non-Expert – Value (170)
  6. Looking to SQL Server 2014 High Availability In Standard Edition (166)
  7. Security Questions: Difference Between db_datawriter and db_ddladmin? (155)
  8. 31 Days of SSIS – Generating Row Numbers (23/31) (127)
  9. Security Questions: Removing Logins From Databases (116)
  10. 10 Monthly Maintenance Tasks for SQL Server (94)

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 : Part 5 : Explaining Non clustered Index on Heap [30 clicks]
  2. Monitoring SQL Server 2012 AlwaysOn Availability Groups Worker Thread Consumption [16 clicks]
  3. Netflix finishes its massive migration to the Amazon cloud [15 clicks]
  4. Locking and Performance [13 clicks]
  5. SQL Server Quickie #6 – THREADPOOL Starvation [13 clicks]
  6. Altering Text Columns: Only a Metadata Change? [12 clicks]
  7. SQL Monitor – managing sql server performance [12 clicks]
  8. SQL Server Diagnostic Information Queries Detailed, Day 18 [11 clicks]
  9. Improved diagnostics for query execution plans that involve residual predicate pushdown [11 clicks]
  10. Get the Active Power Plan of Multiple Servers with PowerShell [10 clicks]
  11. Clustered Column Store Index: Concurrency with INSERT Operations [9 clicks]
  12. SQL Server Diagnostic Information Queries Detailed–Recap [9 clicks]
  13. SQLQueryStress: The Source Code [9 clicks]
  14. Statistics on Ascending Keys – Benjamin Nevarez [8 clicks]
  15. Instead of Goals or Resolutions, Try Creating Rules [8 clicks]
  16. Windows Azure Use Case: Supplementing Infrastructure [8 clicks]
  17. Clustered Columnstore Indexes – part 36 (“Maintenance Solutions for Columnstore”) [7 clicks]
  18. The Ins and Outs of Azure Data Factory – Orchestration and Management of Diverse Data [6 clicks]
  19. SQL Server Diagnostic Information Queries Detailed, Day 10 [6 clicks]
  20. Videos and Training on Windows Azure IaaS from TechEd New Orleans [6 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. Rounding Up to the Nearest 1,000 (2009-02-17)
  2. Can You Dig It? – Plan Cache Series (2011-02-17)
  3. Walmart Store Openings through Power Map (2014-02-18)
  4. Calculate Bitmasks In PowerShell (2013-02-19)
  5. Five Virtual Labs for the SQL Server 2012 DBA (2013-02-21)
  6. SSIS XML DOM Fun (2007-02-22)

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. How I quit my smartphone addiction and really started living [29 clicks]
  2. 25 Things About Life I Wish I Had Known 10 Years Ago [19 clicks]
  3. How People Learn to Become Resilient [14 clicks]
  4. Facebook and the New Colonialism [11 clicks]
  5. Weather be like [8 clicks]
  6. The philosophy of Doctor Who: Is the Doctor good or evil? [7 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?

One thought on “Monday Morning SQL Break – February 22, 2016

Comments are closed.