Monday Morning SQL Break – January 25, 2016

unicorn pirateIt’s Monday and time for this week’s blog and twitter round-up. 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 from Microsoft on tuning SQL Server in high performance workloads.  More basically, it’s a list of documented trace flags that can be used to improve performance for SQL Server.  It’s a good list and interesting to see what levers and knobs we can get our hands on.

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (747)
  2. Get Just The Tools: SSMS Download (383)
  3. 31 Days of SSIS – Raw Files Are Awesome (1/31) (351)
  4. 31 Days of SSIS as a Book (319)
  5. Looking to SQL Server 2014 High Availability In Standard Edition (194)
  6. XQuery for the Non-Expert – Value (167)
  7. Security Questions: Removing Logins From Databases (136)
  8. Determining Filegroup for a Table (130)
  9. Security Questions: Difference Between db_datawriter and db_ddladmin? (127)
  10. 31 Days of SSIS – Generating Row Numbers (23/31) (124)

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. Tuning options for SQL Server when running in high performance workloads [38 clicks]
  2. Using Microsoft DiskSpd to Test Your Storage Subsystem [25 clicks]
  3. Scale-Out Querying for Analysis Services with Read-Only Databases [22 clicks]
  4. Fun for the day – Automated Auto-Indexing! [21 clicks]
  5. A Visual Introduction to Machine Learning [14 clicks]
  6. Proactive SQL Server Health Checks, Part 4 : ERRORLOG [13 clicks]
  7. Hekaton with a twist: In-memory table-valued parameters Part 2 [11 clicks]
  8. Resources for Learning Python [10 clicks]
  9. How Distributed SQL DBs, In-Memory and Flash Speed Real-Time Analytics [10 clicks]
  10. Public Speaking Tips [9 clicks]
  11. Changing In-Memory Table definition without down time 3 [9 clicks]
  12. 30 Small Ways to Manage Your Time More Efficiently at Work [8 clicks]
  13. Under The Hood With SQL Server Batch Mode Part 2: Column Store and Batch Mode Fundamentals [7 clicks]
  14. Twitter Storm: Open Source Real-time Hadoop [7 clicks]
  15. Why the Greatest Minds Take Long Walks [6 clicks]
  16. Data Management Gateway Introduction [6 clicks]
  17. Improving the Row Numbering Median Solution [6 clicks]
  18. Clustered Column Store Index: Concurrency and Isolation Level [5 clicks]
  19. Powershell in a Month Day 11 – Filtering [5 clicks]
  20. Using PowerShell to Build your Azure VM Environment [5 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. 31 Days of SSIS – SQL Server Configuration (18/31) (2011-01-18)
  2. 31 Days of SSIS – DTSConfig Configuration (19/31) (2011-01-19)
  3. 31 Days of SSIS – No More Procedures (20/31) (2011-01-20)
  4. 31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31) (2011-01-21)
  5. 31 Days of SSIS – Data Flow Expressions (22/31) (2011-01-22)
  6. 31 Days of SSIS – Generating Row Numbers (23/31) (2011-01-23)
  7. 5 MCM Readiness Indexing Videos You Should Watch (2013-01-23)
  8. 31 Days of SSIS – One Package, Unlimited Databases (24/31) (2011-01-24)
  9. 31 Days of SSIS – One Package, Unlimited Tables (25/31) (2011-01-25)

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. ‘Grizzly Adams’ star Dan Haggerty dead of cancer at 74 [16 clicks]
  2. Minnesota Neighborhood Pranked by Frozen Pants [12 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?