Blog Post

Not Quite Monday Morning SQL Break – February 7, 2017


It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to ensure that I get this out the published.  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 a post by Joey D’Antoni (blog | @jdanton) on installing SQL Server vNext on Linux clustering.  If you weren’t aware, the next version of SQL Server will be able to be installed on Linux.  For those looking to use an operating system they are more familiar woth (i.e. Linux) or save some costs licensing, this is a great new option.  Check out some of Joey’s expriences with the next release.

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (623)
  2. 31 Days of SSIS – Raw Files Are Awesome (1/31) (287)
  3. 31 Days of SSIS as a Book (260)
  4. Security Questions: Difference Between db_datawriter and db_ddladmin? (145)
  5. Security Questions: What permissions are required to create temporary tables? (111)
  6. 31 Days of SSIS – Using Breakpoints (2/31) (105)
  7. Security Questions: Removing Logins From Databases (93)
  8. Determining Filegroup for a Table (86)
  9. XQuery for the Non-Expert – Value (82)
  10. Get Just The Tools: SSMS Download (73)

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 on Linux Clustering—A Few Other Notes | The SQL Herald [16 clicks]
  2. Test: The Top Two SQL Server Problems I Find Everywhere – Brent Ozar Unlimited® [16 clicks]
  3. What is Azure SQL Data Warehouse? [14 clicks]
  4. Test: The Top Two SQL Server Problems I Find Everywhere [12 clicks]
  5. 10 ways for a conference to upset their speakers [11 clicks]
  6. Disconnecting SQL Server connections after query execution [9 clicks]
  7. New Formatting in #SQLPrompt [8 clicks]
  8. Why I work remotely — Quartz [8 clicks]
  9. When Always On Isn’t: Handling Outages in Your Application – Brent Ozar Unlimited® [7 clicks]
  10. Database Configuration [7 clicks]
  11. Query Optimizer and Data Definition Language Queries [6 clicks]
  12. How to Query Histogram Target XML in Extended Events – by Kendra Little [6 clicks]
  13. Actual Time Statistics in Execution Plans: Elapsed CPU Time and more [6 clicks]
  14. Collecting the Blocked Process Report (XEvents and Server Side Trace) [6 clicks]
  15. I Am Grateful For Rodney Landrum [6 clicks]
  16. Case study: Troubleshooting Doomed Transactions [5 clicks]
  17. If Your Boss Could Do Your Job, You’re More Likely to Be Happy at Work [5 clicks]
  18. Episode 15: This Week In Data – Why People Are Running to SQL Server [5 clicks]
  19. How to Query Histogram Target XML in Extended Events [5 clicks]
  20. When Always On Isn’t: Handling Outages in Your Application [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 – Exporting Execution Plans (29/31) (2011-01-30)
  2. 31 Days of SSIS – Importing Execution Plans (30/31) (2011-01-30)
  3. 31 Days of SSIS – SSIS Naming Conventions (31/31) (2011-01-31)
  4. Ask the Unicorn: Why is it Important to Know Tables in Filegroups? (2013-02-01)
  5. DMV Version of sp_who2 (2009-02-04)
  6. UPDATE – ORDER BY and Deadlocking (2009-02-05)
  7. Change Trusted State of Foreign Keys (2009-02-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. 16 Examples Of Japanese Ingenuity That Need To Go Worldwide [24 clicks]
  2. ‘Wonder Woman’ Pays Tribute To Christopher Reeve In Her New Trailer [20 clicks]
  3. Someone traced the actual wand in these vintage Disney Channel ads and it’s so, so weird [17 clicks]
  4. How to Self-Diagnose Your Shoulder Pain | Breaking Muscle [11 clicks]
  5. Woman’s jaw-dropping hospital pic is why people with ear gauges might regret a pet snake. | Animals | Someecards [11 clicks]
  6. The longest running streak ever ended Saturday at 19,032 days – The Washington Post [7 clicks]
  7. Northumbria University ‘life-threatening’ caffeine test fine [7 clicks]
  8. I Am Grateful For Rodney Landrum – Home Of The Scary DBA [6 clicks]
  9. Episode 15: This Week In Data – Why People Are Running to SQL Server – [5 clicks]
  10. The Implosion Of Trust And What To Do About It [5 clicks]
  11. Summer Glau Imitates Popular Animal Memes – Album on Imgur [5 clicks]
  12. Senate Finance Committee Republicans Suspend Rules, Advance Nominations Of Tom Price, Steven Mnuchin : NPR [3 clicks]
  13. You’re more likely to be killed by your own clothes than by an immigrant terrorist [3 clicks]
  14. RIP to Veteran Actor John Hurt, Star of Alien and So Many Other Films We Love [3 clicks]
  15. World Nutella Day – February 5th [2 clicks]
  16. Rare ‘lava firehose’ from Hawaii’s Kilauea volcano [2 clicks]
  17. Americans Are Eating So Much Bacon That Reserves Are at a 50-Year Low | [2 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?


You rated this post out of 5. Change rating




You rated this post out of 5. Change rating